Symptom
During System Copy using SWPM the following SQL0555N error is reported during transfer ownership of restore.
===========================
INFO 2022-12-15 13:30:19.080 (SAP-LMS\db2sid) (startInstallation) [synxccuren.cpp:646] id=syslib.process.userSwitchSuccessful CSyCurrentProcessEnvironmentImpl::setUser()
Switched to user: SAP-LMS\db2sid.
WARNING 2022-12-15 13:30:20.703 (SAP-LMS\SIDadm) (startInstallation) [iaxxbjsmod.cpp:83] id=modlib.jslib.childAppReturn
Execution of the command "G:\db2\db2sid\db2_software\BIN\db2cmd.exe /C /w /i db2 -td; -vf transfer_ownership_SAPSIDDB_tables_2.sql -r transfer_ownership_SAPSIDDB_tables_2.res -z transfer_ownership_SAPSIDDB_tables_2.out" finished with return code 4.
TRACE 2022-12-15 13:30:20.766 (SAP-LMS\SIDadm) (startInstallation)
Found Error, error_codes[0] = <revoke control on table "SAPSIDDB"."EXPLAIN_STATEMENT" from user db2<sid>
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0555N An authorization ID cannot revoke a privilege from itself.
SQLSTATE=42502>
....................................................................
TRACE 2022-12-15 13:30:20.766 (SAP-LMS\SIDadm) (startInstallation)
Found Error, error_codes[33] = <revoke all privileges on table "SAPSIDDB"."EXPLAIN_INSTANCE" from user db2<sid>
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0555N An authorization ID cannot revoke a privilege from itself.
SQLSTATE=42502>
===========================
You see this error for the <schema>.EXPLAIN* tables only.
Read more...
Environment
- SAP Netweaver AS ABAP & Java any release
- IBM DB2 LUW (DB6) any release
Product
Keywords
SQL0555N , EXPLAIN , SYSTEM COPY , MIGRATION , REVOKE , transfer_ownership , 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.