SAP Knowledge Base Article - Preview

2680942 - DB2 LUW SQL0601N Object with illegal database status: '<tablename>' exists not, '<tablename>~~OLD' exists not, '<tablename~' exists not!

Symptom

  • EUSWITCH.log
    1 ETQ201 Entering upgrade-phase "MAIN_SWITCH/EU_SWITCH" ("YYYYMMDD24MMSSmsms")
    . . .
    4EETQ399 Object with illegal database status: '<tablename>' exists not, '<tablename>~~OLD' exists not, '<tablename~' exists not!

  • SQLSTMTSTD.001
    EXECUTING /usr/sap/<SID>/SUM/abap/bin_749/SAPuptool execdb ../var/RENAME_T_TOLD01.TQL
    Logging to '/usr/sap/<SID>/SUM/abap/log/RENAME_T_TOLD01.LOG'
    1EETQ008 Error message: DBSL error 102 (db code -601):
    1EETQ008 SQL0601N The name of the object to be created
    1EETQ009X is identical to the existing name "<schema>.<tablename>~0" of type
    1EETQ009X "INDEX". SQLSTATE=42710
    1EETQ003 exit code: "20"

  • RENAME_T_TOLD01.TQ
       1 ETQ399 Executing SQL script '../var/RENAME_T_TOLD01.TQL'.
       2 ETQ399 Connecting to database 'db6'.
       4 ETQ010 Date & Time: YYYYMMDD24MMSSmsms
       3 ETQ398 SQL: RENAME "<tabname>" TO "<tabname>~~OLD"
       4 ETQ010 Date & Time: YYYYMMDD24MMSSmsms
       1EETQ008 Error message: DBSL error 102 (db code -601):
       1EETQ008 SQL0601N The name of the object to be created
       1EETQ009X is identical to the existing name "<schema>.<tablename>~0" of type
       1EETQ009X "INDEX". SQLSTATE=42710
       1EETQ003 exit code: "20"

    SQL0601N  The name of the object to be created is identical to the existing name "<schema>.<tabname>~0" of type "INDEX".  SQLSTATE=42710 [dbdbslst#376]


Read more...

Environment

  • SUM
  • DB2 LUW (Linux Unix Windows)

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.