Cross Platform DB2 for z/OS & LUW

Auditor's Guide to DB2 (B06) 

Nov 09, 2010 02:00 PM

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

pdf file
EU10B06.pdf   435 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.