The CA DB2 tools for z/OS Create Required DB2 Objects Post Install job, ssid0001, enters into a hang / wait condition during a DB2 REBUILD INDEX execution. This occurs in step EXECRBP2. The job had to be cancelled. The ssid0001 job was restarted but the same hang / wait condition was encountered.
ALTER INDEX PTI.RAIX_IX_1105
ADD COLUMN ( RAIX_TIMESTAMP_D ASC )
;
.CALL UTIL RECOVER PARM(ssid)
.ALLOC UNIT(SYSDA) FI(SYSIN) NEW SPACE(1,4) CYL +
RECFM(F,B) LRECL(80) BLKSIZE(0)
.ALLOC UNIT(SYSDA) FI(SYSPRINT) NEW SPACE(4,100) CYL +
RECFM(V,B,A) LRECL(125) BLKSIZE(6254)
.DATA
REBUILD INDEX (PTI.RAIX_IX_1105)
SORTDEVT SYSALLDA
.ENDDATA
Index PTI.RAIX_IX_1105 is defined on table PTI.RAIX_STATS_1105.
The underlying VSAM dataset for table PTI.RAIX_STATS_1105 was migrated. Once the underlying VSAM dataset for the tablespace was restored the ssid0001 Create Required DB2 Objects job completed successfully.