Recommendations for changing the BSDS log inventory

You do not need to take special steps to keep the BSDS updated with records of logging events. Db2 does that automatically.

However, you might want to change the BSDS if you:

  • Add more active log data sets.
  • Copy active log data sets to newly allocated data sets, as when providing larger active log allocations.
  • Move log data sets to other devices.
  • Recover a damaged BSDS.
  • Discard outdated archive log data sets.
  • Create or cancel control records for conditional restart.
  • Add or change the DDF communication record.

You can change the BSDS by running the Db2 batch change log inventory (DSNJU003) utility. You can only run this utility when Db2 is inactive.

You can copy an active log data set using the access method services IDCAMS REPRO statement. The copy can be performed when only Db2 is down, because Db2 allocates the active log data sets as exclusive (DISP=OLD) at Db2 startup.