SAP Knowledge Base Article - Preview

2352118 - DB6CONV: Errors SQL0204N and SQL0552N during conversion/reorganisation of data objects.

Symptom

Some Examples of the error in context.

Execution of DB6CONV results in 

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

DB6conv.log example

ONLINE CONVERSION: Start of Step 4 (SWAP)
CALL SYSPROC.ADMIN_MOVE_TABLE( 'SAP<SID>', '<TABNAME>', '', '', 'SWAP' )ADMIN_MOVE_TABLE - SWAP step aborted.
SQL0552N "SAP<SID>" does not have the privilege to perform operation "RENAME INDEX". SQLSTATE=42502
Content (key,value) of SYSTOOLS.ADMIN_MOVE_TABLE

 ST22_dump.log shows the following:

Database Interface Information:
SQL0552N "SAP<SID>" does not have the privilege to perform operation "CREATE TABLE".
CALL SYSPROC.ADMIN_MOVE_TABLE( 'SAP<SID>', '<source_tabname>', '<target_tabname>', '', 'INIT' ) SYSTEM( <SID> , SAP<SID> ) -- HASH_VALUE( XXXXXXXX )
ABAP location info 'DB6CONVP', XXX

 


Read more...

Environment

DB2 LUW
SAP Netweaver all versions

Keywords

SQL0552N, SQL0204N, DB6CONV, ADMIN_MOVE_TABLE, Aborted, Cancelled, authorisations, incorrect, OS, Reorganisation, AMT , 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.