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.