JR62800: DMSHOWLOGDEPENDENCY RETURNS INCORRECT LRI VALUE RESULTING IN NO DEPENDENT LOG FILES BEING FOUND FOR DB2 LUW 10.5.9 AND LATER.

APAR status

• Closed as program error.

Error description

• dmshowlogdependency returns incorrect LRI value resulting in no
  dependent log files being found for Db2 LUW 10.5.9 and later.
  

Local fix

• Change the first byte of the LRI string from '02' to '01':
  
  $
  db2flsn -db sample 0200000000000018E5000000000004D71A
  Given LSN
  is in log file S0000004.LOG
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using CDC 11.4.0.3-5569 *
  * or older for Db2 as a source engine, with Db2 v10.5.9 or     *
  * newer.                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The Db2 LRI type changed in Db2 v10.5.9.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5570 or newer for Db2.               *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5570 or newer for Db2 resolves the
  issue.
  

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:

Fix information

• Fixed component name

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels