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 ONE Support launchpad (Login required).

Search for additional results

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