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 for DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration with DB2 Universal Database , BC-DB-DB6-SYS , Database Interface/DBMS for DB2 Universal Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.