Defining a filter in a log scan step

To define a filter in a log scan step

1. In the BMC AMI Log Master for Db2 Main Menu, select an option from 0 through 7.Depending on the option that you choose, you might be prompted to choose whether you want a Backout Integrity report in addition to the generated SQL. Enter Y or N and press Enter to continue.

   Log Master displays a task dialog panel for the action that you selected:

     Select an Option. Then press Enter.                                            
                                                                                  
    Options . . . . . . _  1. Specify Log Filter Criteria                          
                           2. Specify Time Frame and/or Input Source               
                           3. Define Report and File Outputs                       
                           4. Define Log Mark                                      
                           5. Specify Run Time Options                             
                                                                                  
                           9. Work ID Options, JCL Generation

2. Select 1. Specify Log Filter Criteria and press Enter.Log Master displays the Selectable Fields panel, as displayed in the following figure. For information about the options on the Selectable Fields panel, including special considerations, press F1 to access the online Help.

                              Selectable Fields                        
                                                                                  
   Select Catalog Search or a field type then press Enter.                     
                                                                                  
   Field . . . 10                                                             
    0. Catalog Search       12. PSID                      24. Synonym Name
    1. Unit of Recovery ID  13. OBID                      25. Object Set Name
    2. Correlation ID       14. Column Name               26. Command
    3. Plan Name            15. Catalog Activity          27. Status
    4. Authorization ID     16. Catalog Object            28. Utility
    5. Connection ID        17. DS Member Name            29. Sysplan
    6. Connection Type      18. DS Member Id              30. Syspackage
    7. Update Type          19. Subsystem Name            31. Syspackage Location    
    8. Database Name        20. LUW Network Id            32. Syspackage Collid
    9. Tablespace Name      21. LUW Name                  33. Syspackage Name
    10. Table Name          22. LUW Unique Value          34. Syspackage Version
    11. DBID                23. Alias Name
   
   For Column Name please specify the following information:                  
      Table Owner  . . _______________________                                
      Table Name . . . ______________________________________                 
      Column Name  . . ______________________________________                 
      Filter Image . . _ (A=After, B=Before, Blank = Both)

3. Select an option and press Enter.Log Master displays the Conditional Operators panel:

    FILTERS ==================== Structured Filter Maintenance ===================
    C .----------------------------------------------------------------. ===> HALF
      | ===================== Selectable Fields =====================  | SID: DB2R
    W |   .-------------------------------------------------------------.
    D | S | =================== Conditional Operators ================= |
      |   |                                                             |
    T | F | Selectable Field . . : Table Name                           |
      |   |                                                             |
    A |   | Select the Operator. Then press Enter.                      |
   ** |   |                                                             | ********
      |   | Operator . . . 1  1. Equal                   8. Not Like    |
      |   |                   2. Not Equal               9. In          |
      |   |                   3. Greater Than           10. Not In      |
      |   |                   4. Greater Than or Equal   *  NULL        |
      | F |                   5. Less Than               *  Not NULL    |
      |   |                   6. Less Than or Equal      *  Changed     |
      |   |                   7. Like                    *  Not Changed |
      |   |                                                             |
      |   |  F1=Help    F12=Cancel                                      |
      |   '-------------------------------------------------------------'

4. Select an operator and press Enter.Log Master displays a value entry panel that depends on the field that you selected. This example defines a table name as the selectable field, so Log Master displays the Table Name Value panel:.

                                     Table Name Value                
                                                         
              Operator . . . : Equal                                 
                                                         
              Enter table owner and name below. If either field      
              contains non-alphanumeric or national characters,      
              enclose it in quotation marks. Press F3 when finished.
                                                         
              Owner  . . . . . DB2DBA                                
              Table Name . . . LOCATIONTABLE                        
                                                         
              F1=Help F3=Exit F4=Zoom F12=Cancel

5. Type a value and press F3.Log Master displays the Structured Filter Maintenance panel, as displayed in the following figure. The filter in the example selects log records by table name.

    FILTERS ==================== Structured Filter Maintenance ======= Line 1 of 3
    Command ===> ________________________________________________ Scroll ===> HALF
                                                                        SSID: DB2R
    Work ID . . : USER2.$$WORKID0004
    Description : USER2 01/18/2013 14:55:03 MIGRATE
    Updated Version:V11.01.00
                                                                                  
    Type one or more action codes then press Enter:
      I=Insert, D=Delete, E=Edit, O=Logical OR
    ACT       SELECTABLE FIELD    OPERATOR  VALUE
    _         TABLE NAME          =         DB2DBA.LOCATIONTABLE
6. To insert, delete, or edit predicates, type the appropriate action code in the ACT column and press Enter.For more information about the available action codes, press F1 to access the online Help, or see Action-codes-in-the-Log-Master-online-interface
7. When you finish specifying the filter criteria, press F3 to return to the task dialog.

Where to go from here

For additional tasks associated with creating a log scan step, see Defining-a-log-scan-step.