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