2509073 - DB6: SQL0601N error during upgrade phase MAIN_TRANSEXEC/PARMVNT_TRPRE or MAIN_SHDRUN/SUBMOD_FDC_RUN/SQLRUNTASK_RRC_TRIGGERS_FDC

• In upgrade phase at Phase MAIN_TRANSEXEC/PARMVNT_TRPRE, you see the following error:

MVNTABS ERRORS: ddlntabs and RETURN CODE in <...>_PARMVNT_TRPRE.HRP
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...

    Retcode 1024: error in DDL statement for "DDDBSTMTHD" - repe
 
    Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is
    identical to the existing name "SAP<sid>.DDDBSTMTHD~0" of type "INDEX". SQLSTATE=42710" in
       DDL statement for "DDDBSTMTHD "
    --------------- DB-ROLLBACK() ---------------
    error in DDL, nametab for "DDDBSTMTHD" not activated

...

    Retcode 1024: error in DDL statement for "<table_name>" - repe
 
    Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is
    identical to the existing name "SAP<sid>.<table_name>~0" of type "INDEX". SQLSTATE=42710" in
       DDL statement for "<table_name>"
    --------------- DB-ROLLBACK() ---------------
    error in DDL, nametab for "DDDBSTMTHD" not activated

**************************************************************************

• SUM - DBCLONE  phase MAIN_SHDRUN/SUBMOD_FDC_RUN/SQLRUNTASK_RRC_TRIGGERS_FDC

Error in developer trace file (SAP work directory)
1EETQ008 Error message: DBSL error 99 (db code -150):
SQL0150N The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted. LINE NUMBER=7. 
1EETQ003 exit code: "12"
Table <tabname> is a virtual table for deferred table creation
Opening temporary connection for deferred table creation of table <tabname>
Materialisation of the table fails due to
SQL0601N The name of the object to be created is identical to the existing name "<SCHEMA>.<Object> ~0" of type "INDEX"

IBM DB2 for Linux, Unix, and Windows

MAIN_TRANSEXEC/PARMVNT_TRPRE, rename index, drop index, SQL0601N, identical to the existing name, type "INDEX", SQLSTATE=42710, not activated, MAIN_SHDRUN/SUBMOD_FDC_RUN/SQLRUNTASK_RRC_TRIGGERS_FDC , KBA , tbatg,sql0150n , run_rscpints_puttbrest_ , main_transexec/parmvnt_trpre; rename ind , main_shdcre/submod_shddbclone/dbclone , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem