Articles & Content

Archives

A11 - Automating Access Path Management in DB2 for z/OS

Topic: DB2 for z/OS

Subtopic: 2014



Most DBAs today do not have the time or bandwith to effectively monitor, manage, and maintain application access paths. DB2 has been introducing automatic facilities such as Real-Time statistics to help make application performance, and maintenance management more “hands off”. DB2 V10 introduced several new features focused particularly on managing statistics, access paths, and to assist in managing application performance.
This presentation will discuss real-time statistics and the new maintenance features added in V10 such as autonomic statistics, and statistics profiles. It will also cover application optimization features such as plan management policies, statement level optimization, and the new production modeling capability.

Key topics covered include:
• Real-Time Statistics
• Performance Profiles
• Maintenance for Performance
• Reorganization
• RUNSTATS
• Autonomic Statistics
• Managing Access Paths
• Plan Management Policies
• Rebind EXPLAIN(ONLY)
• Statement Level Optimization
• Production Modeling



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.