PH44830: DATABASE RECOVERY FACILITY IS RUNNING SLOW WITH DB RECOVERY FOR SHISAM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During recovery of a large SHISAM DB, the DRF job ran much
  longer than expected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IMS Recovery Solution Pack for z/OS      *
  *                 Version 2 Release 1 ( FMID=HAHM210 )         *
  *                 IMS Database Recovery Facility users.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: During recovery of a large SHISAM       *
  *                      DB, the DRF job ran much longer         *
  *                      than expected.                          *
  ****************************************************************
  * RECOMMENDATION: INSTALL CORRECTIVE SERVICE FOR APAR/PTF      *
  ****************************************************************
  In the case of SHISAM and HISAM, if Image Copy (IC) is retrieved
  after DELETE of all records in the DB, the number of IC records
  becomes 0. If the DB is recovered using an IC with a record
  count of 0, the recovered DBDS will remain in the DEL/DEF state
  of the VSAM KSDS. And in this case, IMS cannot OPNEN the DB
  after recovery.
  Considering this situation, DRF performs an initialization
  process (PUT & DELETE of Dummy Record) to VSAM KSDS before
  recovering DB so that DB can be opened from IMS after recovery
  process even if IC record is 0.
  However, VSAM KSDS is no longer in "Create or Load" mode after
  this initialization process is performed, and the performance of
  the subsequent record PUT process deteriorates due to VSAM
  specifications. If the size of the DB to be recovered is large,
  the performance degradation becomes more pronounced.
  

Problem conclusion

• FRXIVCN0 is changed to move the initialization process of VSAM
  KSDS to after the DB recovery process, so that the
  initialization process is performed only when no single record
  has been written to the DB.
  

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:

  UI79950

Modules/Macros

• FRXIVCN0
  

Fix information

• Fixed component name

  IMS RCVR SOLUTN

• Fixed component ID

  5655V8600

Applicable component levels

• R210 PSY UI79950

     UP22/04/01 P F203

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.