PM70181: PERFORMANCE ENHANCEMENT FOR THE RECOVER WITH BACKOUT YES UTILITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RECOVER with BACKOUT YES utility needs improved performance
  during the LOGUNDO phase.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users of RECOVER BACKOUT YES         *
  *                 Utility.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: PERFORMANCE ENHANCEMENT FOR THE RECOVER *
  *                      WITH BACKOUT YES UTILITY.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Today, LOG UNDO phase of the RECOVER utility with BACKOUT YES,
  periodically commits the data changes. This commit was intended
  to restart the utility, in case of log apply failure during UNDO
  phase. However, today, restart of the RECOVER BACKOUT YES is not
  supported. i.e. if RECOVER BACKOUT YES fails in any phase, it
  must be restarted from the beginning. Therefore, periodic commit
  serves no purpose. The cost of periodic commit is high since it
  involves forcing out data changes to DASD. This write I/Os are
  expensive. This APAR will avoid performing periodic commits
  during LOG UNDO phase which may significantly improve the
  performance of UNDO phase.
  

Problem conclusion

• DB2 logic of RECOVER utility with BACKOUT YES option is modified
  to improve the performance of LOG UNDO phase which in turns
  improves the over all performance of RECOVER BACKOUT YES
  utility.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK81719

Modules/Macros

• DSNIUNDO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK81719

     UP12/09/26 P F209

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.