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
Keywords
Slow system, Dbacockpit, DATA_OBJECT_P_SIZE , 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.