SAP Knowledge Base Article - Preview

2524977 - SQL0552N "DB2<SID>" on operation "TRANSFER OWNERSHIP

Symptom

  • Below error can be seen in the transfer_ownership_SAP<SID>_tables.log while doing system copy using SWPM(Software Provisioning Manager).
    =====================================
    transfer ownership of table "SAP<source sid>"."<tabname>" to user SAP<target sid> preserve privileges
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.
    During SQL processing it returned:
    SQL0552N "DB2<target sid>" does not have the privilege to perform operation "TRANSFER OWNERSHIP". SQLSTATE=42502
  • From SAPinst_dev.log:
    The step transfer_ownership with Step Key
    First error is : <SQL0552N "DB2<SID>"does not have the Privilege to perform operation "TRANSFER >?.


" on operation "TRANSFER OWNERSHIP"> Read more...

Environment

Db2 LUW IBM 9.7 or higher

Product

SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

Backup, Restore, SECADM, SYSADM, Authorization, Security, DBADM, Perform, system copy, migration, SWPM, target, SAPAPP, SAPMON, SAPTOOLS , KBA , BC-DB-DB6-DBA , Database Administration , 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.