Articles & Content
Topic: 2010 NA
Subtopic: DB2 for z/OS
DATE: 2010-5-12 (08:30 AM - 09:30 AM)
SPEAKERS: Paul Walters (Sallie Mae)
Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that indentify problems prior to impacting a production environment.
EXP. LEVEL: Beginner
Managing Change - Types of Changes: - DB2 Changes - ZPARMS - Statistics - Application Changes
Data to Review: 1. Plan tables a. PLAN_TABLE b. DSN_STATEMENT_TABLE c. DSN_FILTER_TABLE d. DSN_DETCOST_TABLE e. DSN_PREDICATE_TABLE 2. Objects a. Object information and creation b. Object placement in buffer pools 3. Statistics a. DB2 Statistics b. Real Time Statistics 4. SQL statements and source code 5. Key indicators a. Plan Selection Indicators b. DB2 statistics and Real Time Statistics c. Package Execution Statistics
System Changes: 1. Impacts to Access Path Selection 2. Identification 3. Managing rebinds during upgrades
Application Changes: 1. New Packages 2. New Objects 3. Changed Objects 4. Changed Packages
Best Practices: 1. Explain(YES) 2. Regular review 3. Know your application
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.