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.