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 , 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.