SAP Knowledge Base Article - Preview

2781256 - SQL0204N <TABNAME> is an undefined name error in SAP_COLLECTOR_PERFMON_RSDB_DAILY

Symptom

The issue can be observed in the following ways:

  • SQL0204N in job log of SAP_COLLECTOR_PERFMON_RSDB_DAILY

    DBSTATC_Chk:Setting VOLATILE flag according to DBSTATC DB6PM 000
    DBSTATC_Chk:SQL statement ALTER TABLE <SCHEMA>.<TABNAME> VOLATILE failed with SQL error 204 DB6PM 000
    DBSTATC_Chk:SQL0204N "<SCHEMA>.<TABNAME>" is an undefined name. SQLSTATE=42704 DB6PM 000
    Exception CX_DB6_CON in program CL_DB6_JOB_TABLE_MAINTENANCE==CP / CL_DB6_JOB_TABLE_MAINTENANCE==CM003 at line Err. ADBC with return code = 1.208 DB6PM 189
    DBSTATC_Chk:Exception CX_DBA_JOB in class CL_DB6_JOB_TABLE_MAINTENANCE method lin DB6PM 000

  • DBACockpit -> Jobs -> DBA Log -> Errors

    DBSTATC/VOLATILE Consistency Check    ADBC error


Read more...

Environment

IBM DB2 on Linux, Unix or Windows

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BW-SYS-DB-DB6 , BW 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.