PH70300: INDEX RECOVERY IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

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:

  UO07028

Modules/Macros

• HRG#LBID HRG4COMM HRG4DLL  HRG4GRPF HRG4QCLO HRG4QGLO HRG4QGST
  HRG4QRHC HRG4QRRC HRG4QRSU HRG4QUTH HRG4SAXB HRG4SAXC HRG4SCNV
  HRG4SERV HRG4SGLO HRG4SOCK HRG4SRRC HRG4SRRD HRG4SRWR HRG4TYPS
  HRGBABAL HRGBABAQ HRGBABCK HRGBABDB HRGBABDT HRGBABIP HRGBABOB
  HRGBABOI HRGBABOP HRGBABPK HRGBABPL HRGBABRL HRGBABRO HRGBABRT
  HRGBABSC HRGBABSG HRGBABSN HRGBABSQ HRGBABTB HRGBABTP HRGBABTR
  HRGBABTS HRGBABUR HRGBABUT HRGBABVA HRGBACSA HRGBADMA HRGBADT@
  HRGBAICG HRGBALA  HRGBAMRR HRGBAOEN HRGBARPD HRGBASEI HRGBAUTL
  HRGBBADM HRGBBASL HRGBBBOS HRGBBCAI HRGBBCK  HRGBBCOS HRGBBCSL
  HRGBBDDM HRGBBDSL HRGBBDTM HRGBBDTS HRGBBERS HRGBBGOC HRGBBGRJ
  HRGBBGRP HRGBBGRS HRGBBIDM HRGBBIEN HRGBBIPM HRGBBIPS HRGBBISL
  HRGBBJOB HRGBBKSG HRGBBLRJ HRGBBOBM HRGBBOBS HRGBBOCN HRGBBOCR
  HRGBBODM HRGBBOPS HRGBBOSV HRGBBPCJ HRGBBPCO HRGBBPCV HRGBBPDM
  HRGBBPI  HRGBBPLM HRGBBPLN HRGBBPLS HRGBBPSL HRGBBQTA HRGBBQTJ
  HRGBBRA  HRGBBRDM HRGBBRDS HRGBBRMA HRGBBROM HRGBBROS HRGBBRPC
  HRGBBRSL HRGBBSAM HRGBBSAS HRGBBSDM HRGBBSGD HRGBBSSL HRGBBSYM
  HRGBBSYS HRGBBTDM HRGBBTPM HRGBBTPS HRGBBTRM HRGBBTRS HRGBBTSJ
  HRGBBTSL HRGBBTSM HRGBBTSS HRGBBUCD HRGBBUCI HRGBBUCL HRGBBUCO
  HRGBBUCR HRGBBUDC HRGBBUES HRGBBUGC HRGBBULA HRGBBULD HRGBBUPR
  HRGBBUPV HRGBBUQU HRGBBURB HRGBBURC HRGBBURD HRGBBURL HRGBBURP
  HRGBBURV HRGBBUSR HRGBBUSS HRGBBUTH HRGBBUTM HRGBBVDM HRGBBVDS
  HRGBBVRP HRGBBVSL HRGBCOAS HRGBCRAS HRGBDAMA HRGBDSF  HRGBDSUT
  HRGBDT@  HRGBEUSJ HRGBGINS HRGBGRAR HRGBGRCA HRGBGRDD HRGBGRDG
  HRGBGRDL HRGBGRGR HRGBGRGU HRGBGRMD HRGBGRML HRGBGRMR HRGBGRMT
  HRGBGRPL HRGBGRRI HRGBGRRR HRGBGRSF HRGBGRSR HRGBGUS  HRGBHDT@
  HRGBHHC  HRGBHHEC HRGBHLEE HRGBIDT@ HRGBIRES HRGBIRS  HRGBISDO
  HRGBJGBC HRGBJGCS HRGBJGDA HRGBJGDL HRGBJGGN HRGBJGID HRGBJGIM
  HRGBJGNT HRGBJGRD HRGBJGSB HRGBJGSD HRGBJGUF HRGBJGWD HRGBLAQ
  HRGBLDRG HRGBLDSG HRGBLEJ  HRGBLFS  HRGBLREG HRGBMDT@ HRGBMMIA
  HRGBMUM  HRGBMUTL HRGBOOMM HRGBOROD HRGBOSEP HRGBOSLG HRGBOSPQ
  HRGBOSR  HRGBOSSF HRGBOSTS HRGBOVCD HRGBOVCM HRGBOVCS HRGBOVSC
  HRGBOVSD HRGBOVSI HRGBOVSJ HRGBOVSO HRGBOVSR HRGBPCJ  HRGBPRFV
  HRGBRMOQ HRGBRMOS HRGBRMRS HRGBRROT HRGBRSH  HRGBRUTL HRGBSCTS
  HRGBSDT@ HRGBSGSL HRGBSLBS HRGBSLJ  HRGBSLRJ HRGBSOIV HRGBSUTL
  HRGBTSJ  HRGBTSJB HRGBUIPS HRGBUSGB HRGBUSGJ HRGBUTSI HRGBVCCR
  

Fix information

• Fixed component name

  DB2 REC EXPRT F

• Fixed component ID

  5698RET00

Applicable component levels

• R110 PSY UO07028

     UP26/03/06 P F603

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.