SAP Knowledge Base Article - Preview

3287039 - SQL0555N on DB2 EXPLAIN tables during migration.

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

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.