Adding a filter association 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.
- From the Repository Options category on the Main Menu, select Create or Edit Filters.
The product displays the Filter File Menu.
- Select New and press Enter.
The product displays the Selectable Fields panel.
- Define a filter as explained in Step 3 through Step 6 of Defining a filter in a log scan step.
- When you finish specifying the filter criteria, press F3 to return to the Filter File Menu.
- 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 | '-----------------------------------------------------------------------' - 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.
- 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
- Open the work ID that you want to edit, and access the Log Scan Options panel.
For instructions, see Creating and managing work IDs.
- 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 ****************************** - 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.
- Press F3 twice to return to the Work ID Maintenance panel.
The following figure shows two filters for the ABC.PAYROLL work ID:
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 ********************************* - If you have multiple filters, as shown in previous figure, specify the Filter Relational Operator between filters as AND or OR:
- In the Work ID Batch Options field, type E and press Enter.
- 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.
- Press F3 to return to the Work ID File Menu.
- Save the work ID, or, to save it under a new name, select Save As.
Comments