2169003 - REORG error in DBACOCKPIT | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2169003 - REORG error in DBACOCKPIT

Symptom

REORG in DBAcockpit GUI fails with:

Runstat_Tab:Exception CX_DBA_ADBC in class CL_DBA_RDI_QUERY method
Runstat_Tab: Message: ADBC-Fehler
Runstat_Tab: SQL statement: MERGE INTO SAPTOOLS.DBH_STG_TABLE AS T

The resultant job log will show the following:

Reorg_Table:  SQL Code: 150-
Reorg_Table:  SQL Message: SQL0150N The target fullselect, view, typed table, ma
Reorg_Table:  terialized query table, range-clustered table, or staging table in the
Reorg_Table:  INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for
Reorg_Table:  which the requested operation is not permitted.SQLSTATE=428

 


Read more...

Environment

DB2 LUW 9.7, 10.1, 10.5

Product

SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

DBH_STG_TABLE, CL_DB6_JOB_RUNSTATS_TABLE, SQL0150N , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors for 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.