SAP Knowledge Base Article - Preview

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


Read more...

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 , main_transexec/parmvnt_trpre; rename ind , tbatg,sql0150n , run_rscpints_puttbrest_ , 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 ONE Support launchpad (Login required).

Search for additional results

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