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

book

Article ID: 6186

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.

Environment

Release:
Component: GEN

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.