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.

Example 3: Reporting on log records for dropped objects

For this example, assume that the auditor for your company wants to examine the updates to a table that you dropped two weeks ago. You do not want to recover the table, so you use Log Master to retrieve the old table structure definition.

Because you know the time frame when the table was dropped, you decide to use Log Master to scan the log and update the Repository’s Old Objects Table with the old table structure definition.

To create a filter and report for old objects that are no longer in the Db2 catalog

  1. Create a filter that controls selection of the object structure definition.

    For this example, the filter must select the old version of the ACCOUNT table, and name the filter BMC.OLDTABLE. For instructions, see Adding a filter association to a log scan step.

  2. Create a new work ID.

    For instructions, see Creating and accessing a work ID.

  3. Specify a log scan step for the work ID with the following specifications:
    1. Associate the filter that you created with the work ID.

      For instructions, see Adding a filter association to a log scan step.

      The following figure shown an example of the Maintain Filter Associations panel for this example.

                                 Maintain Filter Associations             Line 1 of 1
       Command ===> ________________________________________________ Scroll ===> HALF
                                                                          SSID : DB2R
       Work ID . . : NCH.$$WORKID0001
       Description : NCH 2009-11-18 14.06.16
       
       Maintain the Current Selected Filters list OR
       Add to the list by typing a Filter Name (may be
       wildcarded).  Then press Enter.
       
       Filter Name . . . ___________________________
       
       Filters Like : BMC.*
       Current Selected Filters
         D=Delete from Selected List  I=Information  B=Browse
       ACT  FILTER NAME                  DESCRIPTION
       _    BMC.OLDTABLE                 SELECT THE OLD ACCOUNTING TABLE
      ****************************** End Of List *******************************
    2. Define the time frame start and end points for the log scan step by date.

      For this example, you know that the old table was dropped on September 16, between 9:00 and 10:00 in the morning. For instructions, see Defining a time frame.

    3. Specify an Audit report and a Detail report as output, using the standard default versions of the reports.

      For instructions, see Reports from the log scan.

  4. Press F3 until you return to the Work ID Maintenance panel.
  5. In the Work ID Batch Options field, type E and press Enter.
  6. On the Work ID Run Time Options panel, type O (Overtime) in the Execution Mode field, and then press F3 until you return to the Work ID File Menu.
  7. Save the work ID and generate JCL for batch submittal.

    For instructions, see Creating a batch job from a work ID.

Related topic

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

Comments