Skip to Content
0
Former Member
May 31, 2015 at 10:25 AM

EHP7 Upgrade Issue (960-SQL0960C) in DB2 - Preprocessing

232 Views

Hi All,

We been working in the EHP7 Upgrade in our landscape from EHP5 enviornment in HP Unix / DB2 (10.5). Things are fine so far and we were able to come till Preprocessing Phase (Even completed ACT_UPG Phase).

However I am getting the issue when this been running in PreProcessing phase (PARMVNT_SHD). The error states the below - Just highlighted it for our easier reference.

--------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_FUNCT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_HIERT

Solution which I referred from SAP note : 1019242

  1. Rename the relevant data and index tablespace.

    For example:
    db2 rename tablespace PSAPPOOLD to PSAPPOOL2D
    db2 rename tablespace PSAPPOOLI to PSAPPOOL2I

  2. Create a new tablespace with the old name, the same page size, and the same node group. You can do this using the DBA Cockpit.

    For example: Example of DB2 syntax for automatic storage tablespaces:

    db2 " create tablespace PSAPPOOLD in nodegroup SAPNODEGRP_SID extentsize 2 prefetchsize automatic dropped table recovery off "
    db2 " create tablespace PSAPPOOLI in nodegroup SAPNODEGRP_SID extentsize 2 prefetchsize automatic dropped table recovery off "

    The data and index tablespace must be created in the same DB2 node group.
  3. Assign access rights for the new table spaces.

    For example:

    db2 "grant use of tablespace PSAPPOOLD to public"
    db2 "grant use of tablespace PSAPPOOLI to public"

    The SAP Dictionary now automatically creates new tables in the new tablespaces with the old names.

As per the logs / solution - This is the exact note for our problem. But I do have a concern as my upgrade is running at the momen (Stopped at the moment because of this issue)t and will that cause a problem in the systems as I am renaming the tablespace in the middle of upgrade?


Wondering that Changing the name of existing tablesapce, will the db know the tablespace name is changed and old objects exist there? Because I dont want to lose the effort which we have done for the last couple of weeks for the upgrade just because of this change.

Whole logs for your - Copied from Parmvnt.ELG

--------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRCATT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCDRCNFFLD "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRCNFFLD" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCDRCNFFLDT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRCNFFLDT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCDRCNFT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRCNFT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCDRFLDS "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRFLDS" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCDRFLDST "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCDRFLDST" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCELEMPRC "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCELEMPRC" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPARAMS "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPARAMS" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRC "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRC" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRCSTP "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRCSTP" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRCSTPT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRCSTPT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRCT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRCT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRDCTX "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRDCTX" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPRDCTXT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPRDCTXT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCPROC "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCPROC" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCQ_CATT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCQ_CATT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCRANKINGT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCRANKINGT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCREADINEST "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCREADINEST" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCREASONCRT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCREASONCRT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCREASONDLT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCREASONDLT" not activated

3 ETP000 DEFAULT '00' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCRECPRD "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCRECPRD" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMCRECPRDT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMCRECPRDT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_ACC_TYPT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_ACC_TYPT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_CONTTYT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_CONTTYT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_DEGREE_T "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_DEGREE_T" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_EDUFLD_T "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_EDUFLD_T" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_EDUTYP_T "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_EDUTYP_T" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_FUNCT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_FUNCT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_HIERT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_HIERT" not activated

3 ETP000 DEFAULT ' ' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_INDUT "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_INDUT" not activated

3 ETP000 DEFAULT '00000000' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
2EETP345 ated in the table spaces with the following names or identifiers "MEP#POOLD". SQLSTATE=57
2EETP345 011" in DDL statement for "T77TMC_PRC_TML "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:36:21: error in DDL, nametab for "T77TMC_PRC_TML" not activated

3 ETP000 DEFAULT '00000000' NOT NULL)
3 ETP000 IN "MEP#POOLD"
3 ETP000 INDEX IN "MEP#POOLI"
3 ETP000 LONG IN "MEP#POOLD"
3 ETP000
2EETP345 10:36:21: Retcode 1: SQL-error "-960-SQL0960C The maximum number of objects have been cre
... [skipped 18199 following error lines]
1 ETP111 exit code : "8"

Your inputs will help me to proceed further.