PH69742: INDEX RECOVERY IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The order of objects in the RECOVER step is changed to reduce
  the likelihood of indexes being placed in a Check Pending state
  after the RECOVER utility. Indexes are now positioned after
  their parent table spaces and remain in the same RECOVER
  statement as their parent table spaces. As a result, the total
  number of objects in a single RECOVER step may exceed the value
  of the "Limit of objects per step" option. Additionally, the
  CHECK INDEX utility is now generated only for indexes that will
  be placed in a Check Pending state after the RECOVER utility.
  This reduces the number of unnecessary CHECK INDEX calls.
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: Index recovery improvements             *
  ****************************************************************
  The order of objects in the RECOVER step is changed to reduce
  the likelihood of indexes being placed in a Check Pending state
  after the RECOVER utility. Indexes are now positioned after
  their parent table spaces and remain in the same RECOVER
  statement as their parent table spaces. As a result, the total
  number of objects in a single RECOVER step may exceed the value
  of the "Limit of objects per step" option. Additionally, the
  CHECK INDEX utility is now generated only for indexes that will
  be placed in a Check Pending state after the RECOVER utility.
  This reduces the number of unnecessary CHECK INDEX calls.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO06627

Modules/Macros

• ARY#LBID ARY4COMM ARY4DLL  ARY4GRPF ARY4QCLO ARY4QGLO ARY4QGST
  ARY4QRHC ARY4QRRC ARY4QRSU ARY4QUTH ARY4SAXB ARY4SAXC ARY4SCNV
  ARY4SERV ARY4SGLO ARY4SOCK ARY4SRRC ARY4SRRD ARY4SRWR ARY4TYPS
  ARYBABAL ARYBABAQ ARYBABCK ARYBABDB ARYBABDT ARYBABIP ARYBABOB
  ARYBABOI ARYBABOP ARYBABPK ARYBABPL ARYBABRL ARYBABRO ARYBABRT
  ARYBABSC ARYBABSG ARYBABSN ARYBABSQ ARYBABTB ARYBABTP ARYBABTR
  ARYBABTS ARYBABUR ARYBABUT ARYBABVA ARYBACSA ARYBADMA ARYBADT@
  ARYBAICG ARYBALA  ARYBAMRR ARYBAOEN ARYBARPD ARYBASEI ARYBAUTL
  ARYBBADM ARYBBASL ARYBBBOS ARYBBCAI ARYBBCK  ARYBBCOS ARYBBCSL
  ARYBBDDM ARYBBDSL ARYBBDTM ARYBBDTS ARYBBERS ARYBBGOC ARYBBGRJ
  ARYBBGRP ARYBBGRS ARYBBIDM ARYBBIEN ARYBBIPM ARYBBIPS ARYBBISL
  ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR
  ARYBBODM ARYBBOPS ARYBBOSV ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPDM
  ARYBBPI  ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPSL ARYBBQTA ARYBBQTJ
  ARYBBRA  ARYBBRDM ARYBBRDS ARYBBRMA ARYBBROM ARYBBROS ARYBBRPC
  ARYBBRSL ARYBBSAM ARYBBSAS ARYBBSDM ARYBBSGD ARYBBSSL ARYBBSYM
  ARYBBSYS ARYBBTDM ARYBBTPM ARYBBTPS ARYBBTRM ARYBBTRS ARYBBTSJ
  ARYBBTSL ARYBBTSM ARYBBTSS ARYBBUCD ARYBBUCI ARYBBUCL ARYBBUCO
  ARYBBUCR ARYBBUDC ARYBBUES ARYBBUGC ARYBBULA ARYBBULD ARYBBUPR
  ARYBBUPV ARYBBUQU ARYBBURB ARYBBURC ARYBBURD ARYBBURL ARYBBURP
  ARYBBURV ARYBBUSR ARYBBUSS ARYBBUTH ARYBBUTM ARYBBVDM ARYBBVDS
  ARYBBVRP ARYBBVSL ARYBCOAS ARYBCRAS ARYBDAMA ARYBDSF  ARYBDSUT
  ARYBDT@  ARYBEUSJ ARYBGINS ARYBGRAR ARYBGRCA ARYBGRDD ARYBGRDG
  ARYBGRDL ARYBGRGR ARYBGRGU ARYBGRMD ARYBGRML ARYBGRMR ARYBGRMT
  ARYBGRPL ARYBGRRI ARYBGRRR ARYBGRSF ARYBGRSR ARYBGUS  ARYBHDT@
  ARYBHHC  ARYBHHEC ARYBHLEE ARYBIDT@ ARYBIRES ARYBIRS  ARYBISDO
  ARYBJGBC ARYBJGCS ARYBJGDA ARYBJGDL ARYBJGGN ARYBJGID ARYBJGIM
  ARYBJGNT ARYBJGRD ARYBJGSB ARYBJGSD ARYBJGUF ARYBJGWD ARYBLAQ
  ARYBLDRG ARYBLDSG ARYBLEJ  ARYBLFS  ARYBLREG ARYBMDT@ ARYBMMIA
  ARYBMUM  ARYBMUTL ARYBOOMM ARYBOROD ARYBOSEP ARYBOSLG ARYBOSPQ
  ARYBOSR  ARYBOSSF ARYBOSTS ARYBOVCD ARYBOVCM ARYBOVCS ARYBOVSC
  ARYBOVSD ARYBOVSI ARYBOVSJ ARYBOVSO ARYBOVSR ARYBPCJ  ARYBPRFV
  ARYBRMOQ ARYBRMOS ARYBRMRS ARYBRROT ARYBRSH  ARYBRUTL ARYBSCTS
  ARYBSDT@ ARYBSGSL ARYBSLBS ARYBSLJ  ARYBSLRJ ARYBSOIV ARYBSUTL
  ARYBTSJ  ARYBTSJB ARYBUIPS ARYBUSGB ARYBUSGJ ARYBUTSI ARYBVCCR
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UO06627

     UP26/01/31 P F601  

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.