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.

Adding a filter association to a log scan step

You can create a filter as a separate object, independent of a work ID, and then add filter associations to a work ID. You can further restrict transaction selection by adding additional filter associations to a log scan step.

To define an independent filter

You can create a filter as a separate object, independent of a work ID, and then add filter associations to a work ID. You can further restrict transaction selection by adding additional filter associations to a log scan step.

  1. From the Repository Options category on the Main Menu, select Create or Edit Filters.

    The product displays the Filter File Menu.

  2. Select New and press Enter.

    The product displays the Selectable Fields panel.

  3. Define a filter as explained in Step 3 through Step 6 of Defining a filter in a log scan step.
  4. When you finish specifying the filter criteria, press F3 to return to the Filter File Menu.
  5. Select Save As and press Enter.

    The product displays the Filter Name Entry panel:

     FILTERS ==================== Structured Filter Maintenance ===================
     C .-------------------------------------------------. _______ Scroll ===> HALF
       | FILE ============ Filter File Menu ============ |               SSID: DB2R
     F |   .-----------------------------------------------------------------------.
     D | F | SAVE AS ===================== Filter Name Entry ===================== |
       |   |                                                                       |
     T | S | Type in the information then press F3 to update the repository        |
       |   |                                                                       |
     A | A | Filter Name . . . . USER2.$$FILTER0001                                |
     _ |   | Description . . .                                                     |
     * |   |    ________________________________________________________________   |
       |   | Filter Security . . . W  (W=Read/Write, R=Read Only, N=No Access)     |
       |   |                                                                       |
       '-- |  F1=Help    F3=Exit   F12=Cancel                                      |
           '-----------------------------------------------------------------------'
  6. Provide the following information for the filter and press F3:
    • A new name (or accept the default name)

    • (optional) A description

    • Security level (or accept the default, Read/Write)

    Log Master displays the Filter File Menu with a message in the upper right corner indicating that the filter was saved under the name that you specified.

  7. Press F3 to return to the Main Menu, and then add the filter to a work ID, as described in To add a filter association to a work ID.

To add a filter association to a work ID

  1. Open the work ID that you want to edit, and access the Log Scan Options panel.

    For instructions, see Creating and managing work IDs.

  2. Select Specify Log Filter Associations and press Enter.

    Log Master displays the Maintain Filter Associations panel:

     ======================== Maintain Filter Associations ============ Line 1 of 2
     Command ===> ________________________________________________ Scroll ===> HALF
                                                                         SSID: DB2R
     Work ID . . : ABC.PAYROLL
     Description : USER2 01/18/2013 14:11:42 MIGRATE
                                                                                    
     Maintain the Current Selected Filters list OR
     Add to the list by typing a Filter Name (may be
     wildcarded) then pressing Enter:
                                                                                    
     Filter Name. . .  ___________________________
                                                                                    
     Current Selected Filters
     D=Delete from Selected List, I=Information, B=Browse
     ACT  FILTER NAME                  DESCRIPTION
     _    ABC.AUTHID                   AUTHID EQUAL TO DBA1.
     _    ABC.PAYROLL                  USER2 01/18/2013 14:11:42 MIGRATE
    ****************************** End Of List ******************************
  3. In the Filter Name field, type the name of the filter that you want to add to the Current Selected Filters list (or type a wildcard pattern) and press Enter.

    For more information about using wildcards, press F1 to access the online Help.

    The example shown in the following figure lists two filters. The description of filter ABC.AUTHID indicates its definition. Adding this filter to the ABC.PAYROLL work ID further restricts transaction selection within the associated time frame.

  4. Press F3 twice to return to the Work ID Maintenance panel.
    • The filter with the same name as the work ID was created through the Migrate Data Changes task dialog at the same time that the time frame and outputs were specified.

    • Filter ABC.AUTHID was created as an independent filter, and was added to the log scan step.

         ======================== Work ID Maintenance ============= Line 1 of 7
    Command ===> ________________________________________________ Scroll ===> HALF 
                                                                        SSID : DBAN 
    SSID : DBAN 
     Work ID . . : ABC.PAYROLL                                                      
     Description : ABC PAYROLL SUMMARY REPORT
     Updated Version:                                         
                                                                                    
     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      : 01/18/2013 12:00:00.000000
                     To        : Current
                     Ongoing Process
                     Filter(s) : ABC.AUTHID,ABC.PAYROLL
                     Output(s) : SUMMARY,SQL MIGRATE
                     Log Mark  : None
                     Repos Upd : None                                               
    ******************************** End Of List *********************************
  5. If you have multiple filters, as shown in previous figure, specify the Filter Relational Operator between filters as AND or OR:
    1. In the Work ID Batch Options field, type E and press Enter.
    2. In the Filter Relational Operator field, type A or O to select an operator, and then press F3 to return to the Work ID Maintenance panel.
  6. Press F3 to return to the Work ID File Menu.
  7. Save the work ID, or, to save it under a new name, select Save As.
Related topic


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

Comments