BSDS maintenance
Db2 automatically updates the BSDS with records of log events.
However, you may want to modify the BSDS when you:
- Add more active logs
- Copy active logs to newly allocated data sets
- Move log data sets to other devices
- Discard obsolete archive log data sets
- Create or cancel conditional restart control records
- Add or change a distributed data facility communication record
- Update the checkpoint queue
- Change or add passwords for access to the Db2 catalog and directory
- Change the system VSAM catalog name
- Change the highest written or off-loaded RBA
- Change or add passwords for access to the archive log data set
See the IBM Db2 Administration documentation for more detailed information about changing the BSDS log inventory.
You can use BMC AMI Recovery Manager to generate JCL for Change Log Inventory jobs as follows:
Modify active log records
This option allows you to delete an existing active log data set or specify a new active log to replace one that received an I/O error.
You can validate the modification requests before generating the JCL. You can also accumulate the requests before generating the JCL so that all requests are included in the same JCL. The accumulate feature allows you to combine delete and add actions in the same JCL.
Modify archive log records
This option allows you to delete an existing archive log data set or specify a new archive log data set.
As with the active logs, you can validate the modification requests before generating the JCL, and you can accumulate the requests before generating the JCL.
Modify checkpoint records
This option allows you to update the checkpoint queue with the checkpoint records for the starting RBA and ending RBA.
Modify conditional restart control records
This option allows you to either create a new conditional restart control record (CRCR) to control the next restart of DB2 or to cancel the current active CRCR.
Modify system data set password
This option allows you to specify passwords for the DSNDB01 database (the DB2 directory) and for the DSNDB06 database (the DB2 catalog).
Modify system VSAM catalog name
This option allows you to change the VSAM catalog name in the BSDS.
Modify distributed data facility record
This option allows you to add or change a distributed data facility (DDF) record or remove a DDF password.
Modify highest written or off-loaded RBA
This option allows you to update the highest log RBA in the active log data set or to modify the highest off-loaded RBA in the archive log data set.
Modify archive log data set password
This option allows you to delete password protection for archives that are created after an archive operation. It also allows you to provide a password for all archives that are created after an archive operation.
Print the log map via the Db2 DSNJU004 utility
This options allows you to print the log map in order to determine the BSDS maintenance that must be performed.
Use the procedure described in Creating-JCL-to-make-changes-to-the-BSDS-log-inventory to generate JCL to perform BSDS maintenance.