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 ONE Support launchpad (Login required).

Search for additional results

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