1778732 SQL0960C The maximum number of objects encountered in DBCLONE phase

[former_member542926]

Hi,

While doing the support pack upgrade in our EHP5 system, we got the below error.

Error:

3 ETGCLN START SRM_ATTR_MDL_CU -> SRM_ATTR_MDL_CU~ 20180922031444
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "SRM_ATTR_MDL_CU~" ("MANDT" SAPDB6CHAR(000003) DEFAULT '000' NOT NULL, "MDL_ID" SAPDB6CHAR(000032) DEFAULT ' ' NOT NULL) IN "NX1#POOL2D" INDEX IN "NX1#POOL2I" LONG IN "NX1#POOL2D" COMPRESS NO
1EETGCLN SQL0960C The maximum number of objects have been created in the table spaces with the following names or identifiers "NX1#POOL2D". SQLSTATE=57011
1EETGCLN SRM_ATTR_MDL_CU
1EETGCLN Error when cloning table structure

Per SAP note 177873, we are going with the below solution to run the report DB6CONV

Our question is what option we should choose in the DB6CONV program?

We are in the tablespace tab. what should we choose for

- The tablespace to be converted - "NX1#POOL2D" ?

- Use Target Tablespace = “NX1#POOL2D” ?

- Is there any other options we need to change or leaving the default options work?

Regards

[JPReyes]

Hi Senthil,

You can find your source and target tablespaces using "db2 list tablespaces", if you are doing a clone I presume your source and target <SID> are different so the source tablespace should be easily identifiable.

You can use DB6CONV to move them to the existing tablespace or a new one.

Check SAP note 1778732 - SQL0960C The maximum number of objects encountered in DBCLONE phase

Regards, JP