WORKLOAD AUTOMATION COMMUNITY
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new

Logging extended-auditing information to record updates to the database

8/9/2017

0 Comments

 
Picture
In addition to logging updates to the current plan and recording auditing information for the requested files, you can also choose to log updates to the databases and record information for the requested files. You activate this extended-auditing function by setting AMOUNT(EXTENDED) in the AUDIT initialization statement. 

The extended-auditing data is written to the EQQDBnn data sets, which are created by the EQQPCS14 sample. The extended-auditing records show the values that were set before and after the database was changed. Extended-auditing information can be requested only for the following files: AD, CAL, JV, OI, PER, RD, RG, and WS.

The Requirement
Logging much more information than currently.
Logging database objects before and after the changes.
Using new logs, to prevent overhead in JT that are also used in recovery process.


The Solution

A new set of JT-like sequential data sets to log database activities, named EQQDB* A new set of REPORTs to show the database objects before and after the change

How it Works

In case of object ADDED or DELETED, the record is logged in the EQQDB* data sets.
In case of
MODIFY, both the old and new records (BEFORE and AFTER) are logged in the EQQDB* data sets.

Setting Up

Run EQQJOBS to create the sample JCLs and set Extended Auditing to Y to activate the feature. Run the sample JCL EQQPCS14 to allocate the new EQQDB* data sets.
Address the new
DD EQQDB* in Controller STC and DP Batch.
In the AUDIT statement, set the AMOUNT keyword to EXTENDED

What the Reports Show

Who (the user for which the request was run).
How (Dialog, PIF, DWC), When (timestamp).
What (the list of fields modified with old and new value, or the record deleted or created) was
changed. 

Filtering Report
In the SYSIN, you can specify new PARMS to the EQQAUDIT program to filter log data:
  • DBX, DBR to specify the input files
  • K (KEY), S (SUMMARY) or F (FULL)
  • Record type (AD, WS, RD, RG, OI, JV, PER, CAL)
  • Object names (or keys)
  • Dates ​​
Picture
Report Example
Header and Common Section 
Picture
Operation Section 
Picture
Dependencies Section 
Picture
Conditions and Condition Dependencies Sections 
Picture
Special Resource, Extended Info, User Fields, Var. Duration/Deadline Sections 
Picture
Run Cycle Section 
Picture
Picture

​Annarita Carnevale
Technical Leader for Performance Testing
Workload Scheduler for z/OS

Annarita is currently technical leader for Performance Testing for IBM + HCL Workload Scheduler for z/OS. She has extensive experience in the IWS suite after several years covering various roles in development and test teams.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    March 2023
    February 2023
    January 2023
    December 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Analytics
    Azure
    Business Applications
    Cloud
    Data Storage
    DevOps
    Monitoring & Reporting

    RSS Feed

www.hcltechsw.com
About HCL Software 
HCL Software is a division of HCL Technologies (HCL) that operates its primary software business. It develops, markets, sells, and supports over 20 product families in the areas of DevSecOps, Automation, Digital Solutions, Data Management, Marketing and Commerce, and Mainframes. HCL Software has offices and labs around the world to serve thousands of customers. Its mission is to drive ultimate customer success with their IT investments through relentless innovation of its products. For more information, To know more  please visit www.hcltechsw.com.  Copyright © 2019 HCL Technologies Limited
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new