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 , 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.