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
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.
SAP Knowledge Base Article - Preview