Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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

Was this page helpful? Yes No Submitting... Thank you

Comments