Articles & Content


Auditor's Guide to DB2 (B06)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010

DATE: 2010-11-9 (14:15 - 15:15)
SPEAKERS: Thomas Baumann (Swiss Mobiliar)

The goal of this presentation is to provide guidelines and procedures for auditors and DBAs to conduct database audits to DB2. Control practices based on risk analysis will be presented, and more than 15 test procedures will be discussed, ready to be implemented in any shop. These tests are performed by check scripts, catalog queries, log analysis, and queries to application's data; they produce valuable results to assure and enhance database availability, confidentiality, data integrity and efficiency. Some examples include estimation of recovery elapsed times, reports on unused indexes, triggered actions circumvented by utilities, anomalies detected in database structures, etc. The queries and scripts are developped and tested for DB2 z/OS, but can be adapted easily to other platforms and database management systems.

EXP. LEVEL: Beginner,Intermediate,Advanced


Apply 15+ queries, procedures and scripts to evaluate a broad range of database controls

Interpret the result of the efficiency checks presented to identify opportunities to query performance enhancements, and efficient and effective use of new release’s features

Differentiate the database administrator's and the auditor's roles and responsibilities in performing and evaluating database controls.

Use this presentation as a guideline to perform a database risk self assessment (or an audit for the auditors)

Recognize your DB2 objects and resources from a different perspective

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.