PM00945: LOG APPLY PHASE OF OBJECT RECOVERY TAKES TOO LONG BECAUSE RECOVERUTILITY IS READING BACK TOO FAR IN THE LOG.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOG APPLY phase of object recovery takes too long because
  recover utility is reading back too far in the log.
  
   A possible error that can occur during the LOG APPLY phase is:
  DSNU547I !E81B DSNUCAIN - LOGONLY RECOVER CANNOT PROCEED BECAUSE
  THE STARTING RBA=X'000000000000' IN THE HEADER PAGE
  PGNO=X'00000000' FOR TABLESPACE RETRDB.RETRTS5 IS INVALID.
  
   PM00945 will resolve this issue as well as bring changes to
  REBUILD INDEX generation to speed rebuild index performance.
  ISPF portion of RE will generate index rebuilds cards for all
  the indexes in each TS in one set of rebuild index cards.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOG APPLY phase of object recovery      *
  *                      takes too long because recover utility  *
  *                      is reading back too far in the log.     *
  *                      A possible error that can occur during  *
  *                      the LOG APPLY phase is: DSNU547I        *
  *                      !E81B DSNUCAIN - LOGONLY RECOVER        *
  *                      CANNOT PROCEED BECAUSE THE STARTING     *
  *                      RBA=X'000000000000' IN THE HEADER       *
  *                      PAGE PGNO=X'00000000' FOR TABLESPACE    *
  *                      RETRDB.RETRTS5 IS INVALID.  PM00945     *
  *                      will resolve this issue as well as      *
  *                      bring changes to REBUILD INDEX          *
  *                      generation to speed rebuild index       *
  *                      performance. ISPF portion of RE will    *
  *                      generate index rebuilds cards for all   *
  *                      the indexes in each TS in one set of    *
  *                      rebuild index cards.                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK53031

Modules/Macros

• ARY$BULJ ARY@BCKP ARY@DOOD ARY@OREN ARY@ORSE
  ARY@SOFF ARYLEVEL ARYRBLDC H30R210J
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R210 PSY UK53031

     UP10/01/06 P F001

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.