Symptom
During a system rename with SWPM,
Step: CALL SYSPROC.ADMIN_TASK_REMOVE ('SAPTOOLS.DBH_UOW_COLLECT', NULL) fails with the error SQL0901N The SQL statement or command failed because of a database system error. (Reason "Key to Data Mismatch Error".)
Step: CALL SYSPROC.ADMIN_TASK_ADD ('SAPTOOLS.DBH_UOW_COLLECT', NULL, NULL, NULL, '*/1 * * * *', 'SAPTOOLS', 'DBH_UOW_COLLECT', NULL, NULL, NULL) fails with the error
SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SYSTOOLS.ADMINTASKS" from having duplicate values for the index key.
Read more...
Environment
Db2 LUW IBM
BC-INS-SWPM
Product
Keywords
DB2ATS, DCF , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.