Defining a filter in a log scan step
Before you begin
Ensure that you understand the concepts presented in Filter definitions.
To define a filter in a log scan step
- 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
- 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)
- 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 | | '-------------------------------------------------------------'
- 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
- 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
- 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
- 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.
Comments
Log in or register to comment.