PM82586: IMPROVE THE "TO SEQUENCE-END" VALUE IN MESSAGES DSNI043I AND DSNI044I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If the TO RBA or TO LRSN (sequence-end) value is unknown (ZEROS)
  at the time when an LPL/GRECP recovery is initiated, then
  LPL/GRECP recovery logic replaces the ZEROS with all FOXES
  (X'FFFFFFFFFFFF').  This could potentially elongate the
  LPL/GRECP recovery time.  Instead of replacing the sequence-end
  value with X'FFFFFFFFFFFF', it should replace it with the actual
  End-Of-the-Log value at the time of LPL/GRECP recovery.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Provide more accurate "TO sequence-end" *
  *                      value in msgDSNI043I and msgDSNI044I.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Currently, if the RBA or LRSN is unknown, at the time when
  LPL/GRECP recovery is initiated, msgDSNI043I and msgDSNI044I
  will display all foxes X'FF' in the "TO RBA" or "TO LRSN" field.
  This high value may elongate the recovery time.  The end-of-log
  RBA/LRSN is preferable to all foxes.
  
  Related investigation showed that there were some cases when LPL
  pages were added for a DB2 object that experienced an I/O error,
  which may not be during DB2 restart.  In these cases, the LPL
  page was added but the ending RBA or LRSN value was not updated.
  

Problem conclusion

• The code has been changed to display the end-of-log RBA/LRSN for
  DSNI043I and DSNI044I, if the RBA/LRSN is unknown, when
  LPL/GRECP recovery starts.
  
  In addition, the code has been changed to update the ending RBA
  or LRSN in cases where LPL pages are added during non-DB2
  restart.
  

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:

  UI12095 UI12096 UI12097

Modules/Macros

• DSNICLST DSNIDBMG DSNISREC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI12095

     UP13/11/16 P F311

• RB10 PSY UI12096

     UP13/11/16 P F311

• R910 PSY UI12097

     UP13/11/16 P F311

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.