Skip to Content

Default language.

Example 1: Updating the Repository on an ongoing basis

For this example, assume that you have a test environment in which you plan to drop and re-create a table on an ongoing basis. You populate this table with data each time that you re-create the table for performance testing.

Related topic

Overtime-mode-examples

Occasionally, you might need to re-create a previous version of the table to allow you to run reports, or create SQL. To do this, use BMC AMI Log Master to create an ongoing log scan that will update the Repository every time the table’s definition changes. BMC AMI Log Master makes an entry into the Repository for each version of the table definition.

The information stored in the Repository enables 

BMC AMI Log Master

 to scan the log for records associated with a particular version of the table definition. To run this job, use the overtime execution mode.

Use the following procedure to perform these tasks.

To update the Repository on an ongoing basis

  1. Create a work ID and add a log scan step.For instructions, see Creating-and-managing-work-IDs and Adding-a-log-scan-step-to-a-work-ID.

  2. Define the log scan filter, time frame, and make it an ongoing process using the values shown in the following figure as Work ID Maintenance panel.

     WORKID                           Work ID Maintenance               Line 1 of 7
     Command ===> ________________________________________________ Scroll ===> HALF
                                                                        SSID : DB2R
     Work ID . . : NCH.$$WORKID0001                                                 
     Description : NCH 2022-01-18 11.28.11
     Updated Version: V13.01.00                                         
                                                                                   
     Work ID Batch Options  . . _  (E=Edit)                                         
                                                                                   
     Type an action code. Then press Enter.                                         
       I=Insert  D=Delete  E=Edit                                                   
     ACT  STEP TYPE  DESCRIPTION                                                    
     _    Log Scan   Inputs    : DB2 Subsystem BSDS                                 
                     From      : 2022-01-18 11.31.59.000000                         
                     To        : Current                                            
                     Ongoing Process                                                
                     Filter(s) : NCH.BMC001FILTER                                   
                     Output(s) : None                                               
                     ReposUpd  : Yes                                                
    ******************************** End Of List *********************************

    For instructions, see Defining-a-log-scan-step.

  3. Specify the log scan parameters and then press F3 until you return to the Work ID Maintenance panel.

                              Maintain Filter Associations                          
     C .---------------------------------------------------------------.  ===> HALF
       |                        Log Scan Options                       | SID : DB2R
     W |   .--------------------------------------------------------------.         
     D | O |                      Log Scan Parameters                     |         
       |   |                                                              |         
     M |   | Process DB2 Catalog Records . . . Y (Y=Yes, N=No)            |         
       |   | Process DB2 Directory Records . . N (Y=Yes, N=No)            |         
       |   | Sort Option . . . . . . . . . . . _ (E=Edit)                 |         
       |   | Specify REDO Recovery Point . . . _ (E=Edit, D=Delete)       |         
     w |   |                                                           |                                                                   
       .-- |            Update Repository Parameters                      |         
     Curre |                                                              |         
       D=D | Update Repository Tables  . . . . N (Y=Yes, N=No)            |         
     ACT   |                                                              |         
    _      |    Include Dictionary . . . . . . N (Y=Yes, N=No, O=Only)    |         
    ****** |    Include Syscopy. . . . . . . . N (Y=Yes, N=No, O=Only)    |         
           |      Specify Start Point. . . . . _ (E=Edit, D=Delete)       |         
           |                                                              |         
           |    DB2 Catalog  . . . . . . . . . N (Y=Yes, N=No)            |       
           |    DB2 Log . .  . . . . . . . . . Y (Y=Yes, N=No)            |
           |                                                              |
           | F1=Help F3=Exit F12=Cancel                                   |         
           '--------------------------------------------------------------'
  4. On the Work ID Maintenance panel, type E in the Work ID Batch Options field and press Enter.
  5. On the Work ID Run Time Options panel, type O (Overtime) in the Execution Mode field and press F3 until you return to the Work ID File Menu.
  6. Save the work ID and generate JCL for batch submittal.For instructions, see Creating-a-batch-job-from-a-work-ID.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Log Master for Db2 13.1