Articles & Content


Auditor's Guide to DB2 (E02)

Topic: 2010 NA

Subtopic: DB2 for z/OS

DATE: 2010-5-11 (01:45 PM - 02:45 PM)
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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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