SAP Knowledge Base Article - Preview

2638360 - DB6: SQL0220N in explain plan of DBACockpit

Symptom

During running explain plan in DBACockpit, following errors happen:

C *** ERROR in ExecuteDirect[dbdb6.c, 5934] CON = 0 (BEGIN)
C &+ dsql_db6_exec_immediate( SQLExecDirect ):
   [IBM][CLI Driver][DB2/LINUXX8664] SQL0220N The Explain table "SAP<SID>.EXPLAIN_OBJECT",
   column "PAGES" does not have the proper definition or is missing. SQLSTATE=55002


Read more...

Environment

  • IBM Db2 LUW Database 9.7 or higher
  • SAP Netweaver 6.20 or higher

Keywords

DB6, SQL0220N, EXPLAIN, DBACockpit , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , 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.