Example 1: Updating the Repository on an ongoing basis
For this example, assume that you have a test environment in which you plan to drop and re-create a table on an ongoing basis. You populate this table with data each time that you re-create the table for performance testing.
Occasionally, you might need to re-create a previous version of the table to allow you to run reports, or create SQL. To do this, use Log Master to create an ongoing log scan that will update the Repository every time the table’s definition changes. Log Master makes an entry into the Repository for each version of the table definition.
The information stored in the Repository enables Log Master to scan the log for records associated with a particular version of the table definition. To run this job, use the overtime execution mode.
Use the following procedure to perform these tasks.
To update the Repository on an ongoing basis
- Create a work ID and add a log scan step.For instructions, see Creating-and-managing-work-IDs and Adding-a-log-scan-step-to-a-work-ID.
Define the log scan filter, time frame, and make it an ongoing process using the values shown in the following figure as Work ID Maintenance panel.
WORKID Work ID Maintenance Line 1 of 7
Command ===> ________________________________________________ Scroll ===> HALF
SSID : DB2R
Work ID . . : NCH.$$WORKID0001
Description : NCH 2013-01-18 11.28.11
Updated Version: V11.01.00
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 : 2013-01-18 11.31.59.000000
To : Current
Ongoing Process
Filter(s) : NCH.BMC001FILTER
Output(s) : None
ReposUpd : Yes
******************************** End Of List *********************************For instructions, see Defining-a-log-scan-step.
Specify the log scan parameters and then press F3 until you return to the Work ID Maintenance panel.
Maintain Filter Associations
C .---------------------------------------------------------------. ===> HALF
| Log Scan Options | SID : DB2R
W | .--------------------------------------------------------------.
D | O | Log Scan Parameters |
| | |
M | | Process DB2 Catalog Records . . . Y (Y=Yes, N=No) |
| | Process DB2 Directory Records . . N (Y=Yes, N=No) |
| | Sort Option . . . . . . . . . . . _ (E=Edit) |
| | Specify REDO Recovery Point . . . _ (E=Edit, D=Delete) |
w | | |
.-- | Update Repository Parameters |
Curre | |
D=D | Update Repository Tables . . . . N (Y=Yes, N=No) |
ACT | |
_ | Include Dictionary . . . . . . N (Y=Yes, N=No, O=Only) |
****** | Include Syscopy. . . . . . . . N (Y=Yes, N=No, O=Only) |
| Specify Start Point. . . . . _ (E=Edit, D=Delete) |
| |
| DB2 Catalog . . . . . . . . . N (Y=Yes, N=No) |
| DB2 Log . . . . . . . . . . . Y (Y=Yes, N=No) |
| |
| F1=Help F3=Exit F12=Cancel |
'--------------------------------------------------------------'- On the Work ID Maintenance panel, type E in the Work ID Batch Options field and press Enter.
- On the Work ID Run Time Options panel, type O (Overtime) in the Execution Mode field and press F3 until you return to the Work ID File Menu.
- Save the work ID and generate JCL for batch submittal.For instructions, see Creating-a-batch-job-from-a-work-ID.
Related topic