Getting SYSOBD information

Log Master reconstructs log records of interest according to their version when they were logged.

When Log Master encounters a log record that reflects a version of a Db2 object that differs from the version of that object in the catalog, Log Master tries to retrieve the information about the definition of a previous version (SYSOBD information) from available sources.

Log Master first attempts to get SYSOBD information from the database description (DBD) and the table space. A LOAD REPLACE or a reorganization makes every row on the table the current version, making the SYSOBD information no longer necessary for Db2, and therefore, the information is not saved on the table space.

Log Master also processes SYSOBD pages that it finds in the log during the initial scan. After the initial scan, if Log Master still needs SYSOBD information, it attempts to get that information from available image copies. Log Master documents such an attempt by issuing the following message:

BMC097017I IMAGE COPY ACCESS IS FOR SYSOBD INFORMATION

If Log Master does not find the information on the available image copies, it then scans the area of the alter in the log for the SYSOBD pages.


Was this page helpful? Yes No Submitting... Thank you

Comments