2472993 - SQL0104N with "DATA_OBJECT_P_SIZE" | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2472993 - SQL0104N with "DATA_OBJECT_P_SIZE"

Symptom

Below error can be seen in transaction SM21 and the related work process trace file:

C  *** ERROR in prepareStatement[/bas/745_REL/src/dbs/db6/dbdb6.c, 14242] (END)
B  ***LOG BY2=> sql error -104 performing OPC [dbds         437]
B  ***LOG BY0=> SQL0104N  An unexpected token "," was found following "DATA_OBJECT_P_SIZE,".  Expected tokens may include:  "<space>
C  *** ERROR in prepareStatement[/bas/745_REL/src/dbs/db6/dbdb6.c, 14242] CON = 4 (BEGIN)
C  &+***      dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/AIX64] SQL0104N  An unexpected token "," was found foll
C  &+***      owing "DATA_OBJECT_P_SIZE,".  Expected tokens may include:  "<space>".  SQLSTATE=42601
C  &+***
C  &+***      SELECT TABSCHEMA,        TABNAME,        (DATA_OBJECT_P_SIZE +         INDEX_OBJECT_P_SIZE +         LONG_OBJECT_P
C  &+***      _SIZE +         LOB_OBJECT_P_SIZE +         XML_OBJECT_P_SIZE) AS TOTAL_P_SIZE,        DATA_OBJECT_P_SIZE,,
C  &+***       REORG_PENDING,        DICTIONARY_SIZE FROM   SYSIBM.SYSDUMMY1,        SAPTOOLS.DBH_STG_TABLESTO WHERE  TABSCHEMA
C  &+***      = ? AND        SNAPSHOT_TIMESTAMP = ( SELECT SNAPSHOT_TIMESTAMP                               FROM   SYSIBM.SYSDUM
C  &+***      MY1,                                      SAPTOOLS.DBH_STG_TABLESTO                               ORDER BY SNAPSHO
C  &+***      T_TIMESTAMP DESC                               FETCH FIRST 1 ROWS ONLY ) ORDER BY TABSCHEMA ASC, TABNAME ASC WITH
C  &+***      UR
C  &+***        cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0
C  &+***
C  &+***      ABAP location info 'CL_SQL_STATEMENT==============CP', 500
C  &+***
C  *** ERROR in prepareStatement[/bas/745_REL/src/dbs/db6/dbdb6.c, 14242] (END)
B  ***LOG BY2=> sql error -104 performing OPC [dbds         437]
B  ***LOG BY0=> SQL0104N  An unexpected token "," was found following "DATA_OBJECT_P_SIZE,".  Expected tokens may include:  "<space>


Read more...

Environment

DB2 for LUW database releases: 10.5

Product

SAP Solution Manager 7.2

Keywords

Slow system, Dbacockpit, DATA_OBJECT_P_SIZE , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors for DB2 Universal Database , 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.