Space announcements


This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Overtime mode overview

The overtime mode feature of the Log Master for DB2 product enables you to examine DB2 objects over a period of time, regardless of whether the objects have been dropped. Overtime mode enables Log Master to resolve the conflict between the following points:
  • To read DB2 log records, Log Master needs information about the structure of any DB2 objects that are referenced in the log records. Log Master normally gets this information from the DB2 catalog.

  • When a DB2 object is dropped, DB2 deletes all references to the object from the DB2 catalog. When an object is dropped and re-created, Log Master cannot use information in the DB2 catalog because the structure of the object might have changed, particularly the internal DB2 object identifiers such as DBIDs, PSIDs, or OBIDs.

Log Master refers to dropped DB2 objects (or DB2 objects that have been dropped and re-created) as old objects. Overtime mode enables Log Master to process log records related to old objects, and obtain structure definitions of old objects from sources other than the DB2 catalog.

To use overtime mode, you must accomplish the following basic tasks:

  • Obtain the structure definitions of the old objects

  • Use the structure definitions to read log records about the old objects

To specify overtime mode, use one of the following method s:

  • Execution Mode field on the Work ID Run Time Options panel

  • EXECUTION MODE keyword of the OPTION statement in batch syntax

  • EXECMODE installation option

This section contains the following topics:

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