2509073 - DB6: SQL0601N error during upgrade phase MAIN_TRANSEXEC/PARMVNT_TRPRE

Symptom

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

Environment

IBM DB2 for Linux, Unix, and Windows

Keywords

MAIN_TRANSEXEC/PARMVNT_TRPRE, rename index, drop index, SQL0601N, identical to the existing name, type "INDEX", SQLSTATE=42710, not activated , 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

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.