SAP Knowledge Base Article - Preview

2352118 - DB6CONV fails with DB2 LUW errors SQL0204N and SQL0552N

Symptom

  • Execution of DB6CONV results in 

              SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name. SQLSTATE=42704
              SQL0552N "SAP<SID>" does not have the privilege to perform operation "CREATE TABLE". SQLSTATE=42502 

 

  • ST22_dump.log shows the following:

          Database Interface Information
          ERROR in ExecuteDirect[dbdb6.c, 6955] CON = 0 (BEGIN) [dbsldb6trc.c#1675] dsql_db6_exec_immediate( SQLExecDirect ):
          [IBM][CLI Driver][DB2/LINUXX8664] SQL0552N "SAP<SID>" does not have the privilege to perform operation "CREATE TABLE". SQLSTATE=42502
          CALL SYSPROC.ADMIN_MOVE_TABLE( 'SAP<SID>', '<source_tabname>', '<target_tabname>', '', 'INIT' )
          -- SYSTEM( <SID> , SAP<SID> ) -- HASH_VALUE( 3196834254 )
          ABAP location info 'DB6CONVP', 6771
          ERROR in ExecuteDirect[dbdb6.c, 6955] (END) [dbsldb6trc.c#1675]
    


Read more...

Environment

DB6CONV
DB2 LUW
SAP Netweaver all versions

Keywords

SQL0552N, SQL0204N, DB6CONV, ADMIN_MOVE_TABLE , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6-SYS , Database Interface/DBMS , 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.