CA DB2 tools for z/OS Post Install Create Required DB2 Objects job, ssid0001, goes into wait condition during REBUILD INDEX execution.

Document ID : KB000006186
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Resolution:

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.