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.
SAP Knowledge Base Article - Preview