SAP Knowledge Base Article - Preview

3051958 - Querying Db2 sap standard tables produces SQLCODE = -20008

Symptom

Attempt to query SAP standard tables from Dbacockpit   (ie, DB2CCHOUR, DB2CCDAILY,DB2REOTS, DBCON, etc.)   produces the following error:
=============================================================================================
M Wed Apr 28 19:45:54 2021
M  ThEMsgArrived: sysmsg_for_rfc = 0
C  *** ERROR => DB2 Call 'SQLExecDirectW' Error: conHdl = 00 SQLCODE = -20008 : [IBM][CLI Driver][DB2] ATTEMPT TO USE UNSUPPORTED FE
 [dbdb2cli.c   6403]
C  {root-id=6089301496BA2D00E100805EAC146CC7}_{conn-id=00000000000000000000000000000000}_0
C  DB2Trc: EXPLAIN PLAN SET QUERYNO0001524507 FOR select count(*) from DB2CCHOUR FETCH FIRST 0000000250 ROWS\
C  DB2Trc:  ONLY;
B  ***LOG BY2=> sql error -20008 performing EXE [dbds         578]
B  ***LOG BY0=> [IBM][CLI Driver][DB2] ATTEMPT TO USE UNSUPPORTED FEATURE SAPABAP.PLAN_TABLE. REASON CODE: 2 [dbds         578]
B  ***LOG BY1=> sql error -20008 [dbacds       1843]
=============================================================================================


Read more...

Environment

  • SAP Netweaver 702 sp18 or earlier
  • Db2 v12

Other SAP Basis releases may be affected.

Product

SAP Customer Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

KBA , BC-DB-DB2-DBA , DB2 for z/OS - Database administration , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.