The SQLCODE=-660 in ssid0001 after fallback from DB2V10(NFM) to DB2V10(CM8)..

Document ID : KB000123513
Last Modified Date : 22/12/2018
Show Technical Document Details
Issue:
I upgraded our DB2 from DB2 V10(CM8) to DB2 V10(NFM) in our test system. And I performed Post-Install processing for the IDB2 V15.0 after upgrading the DB2 to V10(NFM) and all processing were completed normally without a problem. After that, I did fallback the DB2 from V10(NFM) to V10(CM8) and performed again the Post-Install processing after fallbacking the DB2 to V10(CM8). However, ssid0001 job failed with the SQLCODE=-660. here is the job output error message on the index.
CREATE INDEX PTI.PTGL500_RESTART2X1 ON PTI.PTGL500_RESTART2
( GLR2_KEY ASC
, GLR2_UTILITY_ID ASC
)
PARTITIONED
USING STOGROUP PTSG
PRIQTY 500
SECQTY 500
ERASE NO
FREEPAGE 10
PCTFREE 25
CLUSTER
BUFFERPOOL BP0
CLOSE NO
;
DSNT408I SQLCODE = -660, ERROR: INDEX PTGL500_RESTART2X1 CANNOT BE
CREATED OR ALTERED ON PARTITIONED TABLE SPACE PTG500T2 BECAUSE
KEY LIMITS ARE NOT SPECIFIED

How should I do to solve this problem?
Environment:
CA-DB2 TOOLS R15.0, R15.0, DB2V10(CM8), DB2V10, V10, CM8 
Cause:
In CA-DB2 r15.0, an appropriate PARTITIONED INDEX statement could not be generated when the DB2 fallback was done from V10(NFM) to V10(CM8).
 
Resolution:
Please do the following to avoid this problem.

1.
Modify the "CREATE INDEX PTI.PTGL500_RESTART2X1" statement in the ssidDDLU with the following.

CREATE
TYPE 2
INDEX PTI.PTGL500_RESTART2X1
ON PTI.PTGL500_RESTART2
( GLR2_KEY ASC
, GLR2_UTILITY_ID ASC
)
USING STOGROUP DCDTEST
PRIQTY 500
SECQTY 500
ERASE NO
FREEPAGE 10
PCTFREE 25
CLUSTER
( PART 1 VALUES ( 1 , '999999999999999999' )
, PART 2 VALUES ( 2 , '999999999999999999' )
, PART 3 VALUES ( 3 , '999999999999999999' )
, PART 4 VALUES ( 4 , '999999999999999999' )
, PART 5 VALUES ( 5 , '999999999999999999' )
, PART 6 VALUES ( 6 , '999999999999999999' )
, PART 7 VALUES ( 7 , '999999999999999999' )
, PART 8 VALUES ( 8 , '999999999999999999' )
, PART 9 VALUES ( 9 , '999999999999999999' )
, PART 10 VALUES ( 10 , '999999999999999999' )
, PART 11 VALUES ( 11 , '999999999999999999' )
, PART 12 VALUES ( 12 , '999999999999999999' )
)
BUFFERPOOL BP0
CLOSE NO
;

2.
Rerun the ssid0001 job with ".RESTART SYNC".

*(As the premise, RO48520, RO48521, RO48522 and RO48523 must be applied.)