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 for Me (Login required).

Search for additional results

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