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)
BMC AMI 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.BMC AMI 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/2022 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/2022 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/2022 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 the 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.