Example 3: Auditing specific column data

For this example, assume that the manager of the credit card division of the bank where you work wants a daily report that verifies all changes to credit limits that set the limit to a value greater than $25,000.00.

You must produce a daily report on all column changes that meet a certain requirement, and generate the report on the day following the day that the changes were actually entered.

The overall process for this task is as follows:

Define a filter.
You set up a filter to select records based on the content of the LIMIT column. You need to select all records where the value of LIMIT is greater than 25,000 and the value of LIMIT has been changed.
Set the time frame.
You define the time frame to look at all transactions for the previous day.
Change the default ordering of the Audit report.
To make the Audit report (which is produced by default) more meaningful, you sort the report so that it groups all changes made by each person who entered information into the credit information table.
Run the auditing job.
You can run this job, with changes to the time frame, every day after midnight to produce a report of the previous day’s changes. As a result, you can provide the report to the manager of the credit card division each morning.

To audit data changes to a specific value

Complete the following series of panels:

On this panel	Take this action	Notes
Main Menu	Select Create Audit Report and press Enter.	None
Create Audit Report	Select Specify Log Filter Criteria and press Enter.	This step creates the filter to define search criteria. For filter values, see Filter to select credit limit. For instructions, see Defining a filter in a log scan step.
Selectable Fields	Use the Structured or Free Form filter interface to define search criteria. Define a filter that selects records where the credit limit column, LIMIT, has changed and is greater than the value 25000. Press F3 until you return to the Create Audit Report panel.
Create Audit Report	Select Specify Time Frame and/or Input Source and press Enter.	This step specifies the time frame for the log scan, as shown in Example time frame selecting data for one day. For instructions, see Defining a time frame.
Time Frame Specification	Set the time frame start and end points to look at transactions for a given day. Press F3 until you return to the Create Audit Report panel.
Create Audit Report	Select Define Report and File Outputs and press Enter.	Log Master displays an Audit report request by default. This step changes the default ordering of the report to sort by unit of recovery and authorization ID.
Report and File Outputs	Type E in the ACT column.
Report Output	In the Order By fields, type 1 and 3. Press F3 until you return to the Create Audit Report panel.
Create Audit Report	Select Work ID Options, JCL Generation and press Enter.	This step saves the work ID and generates the JCL. For an example, see Creating a batch job from a work ID.
Work ID File Menu	Select Save As. Select Generate JCL for batch submittal.

Filter to select credit limit

 FILTERS ==================== Structured Filter Maintenance ======= Line 1 of 2
 Command ===> ________________________________________________ Scroll ===> HALF
                                                                     SSID: DB2R
 Work ID . . : ABC.CREDITLIMIT
 Description : REPORT CHANGES TO CREDIT LIMITS WHERE THE LIMIT IS .GT. 3000
 Updated Version:V11.01.00

 Type one or more action codes. Then press Enter.
     C=Catalog Search  I=Insert  D=Delete  E=Edit  O=Logical OR                   
ACT       SELECTABLE FIELD    OPERATOR  VALUE
 _         LIMIT               CHANGED
 _    AND  LIMIT               > 25000
********************************* End Of List *********************************

Example time frame selecting data for one day

                           Time Frame Specification               SSID : DB2R
                                                                             
Start of Log Scan . . . : 2013-01-18 00.00.00.000000
End of Log Scan . . . . : 2013-01-18 24.00.00.000000
Log File Source . . . . : Subsystem BSDS                                 
                                                                             
Select an Option. Then press Enter.                                          
                                                                             
Options . . .   _ 1. Define Start Point                                      
                  2. Modify End Point                                        
                  3. Reset Time Frame using Log File Selections              
                                                                             
Ongoing Process. . . . . . . .  Y           (Y=Yes, N=No)                   
Rerun/Reprocess Options:                                                    
     Rerun Run Number. . . . .              (Run Sequence Number or LASTRUN)
  OR From Start of Run Number.              (Run Sequence Number or LASTRUN)
Reset/Purge Options:                                                        
     Generate New Handle ID. .  N           (Y=Yes, N=No)                   
  OR Reset Handle ID . . . . .  N           (Y=Yes, N=No)                   
     Purge . . . . . . . . . .  N           (Y=Yes, N=No)                   
 F1=Help    F3=Exit   F12=Cancel

Related topic

Examples of auditing changes

Example 3: Auditing specific column data

To audit data changes to a specific value

Comments