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