Articles & Content

Archives

Continuous Monitoring of Dynamic Queries (A03)

Topic: 2011 NA

Subtopic: DB2 for z/OS



DATE: 2011-5-3 (03:15 PM - 04:15 PM)
SPEAKERS: Thomas Baumann (Swiss Mobiliar )

This presentation covers both technical details of Continuous Query Monitoring (CQM) for dynamic queries running on DB2 z/OS and the role CQM can play within an organization as an automated feedback mechanism for management to ensure that dynamic queries are processed appropriately and controls have been operating as designed. The DBA can utilize this information to set business rules or tests, using analytics to identify performance gaps or unusual transactions that may suggest control failures.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Defining key performance indicators for dynamic query processing

Tools and techniques to capture dynamic queries on DB2 z/OS

Identification and classification of query exceptions

Understand differences between real-time monitoring and continuous monitoring

Enhance database risk and control oversight capability through early detection and monitoring



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.