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
DB2 LUW 9.7, 10.1, 10.5
DBH_STG_TABLE, CL_DB6_JOB_RUNSTATS_TABLE, SQL0150N , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem
About this pageThis 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.