Articles & Content
Topic: 2008 NA
Subtopic: DB2 for z/OS
DATE: 2008-05-22 (08:00 AM - 09:00 AM)
SPEAKERS: Terry Berman (DST Systems Inc.)
Optimization Service Center augments VE query tuning with a whole new set of features targeted at your "workloads": entire groups of SQL, dynamic AND static. Real-world performance data is provided by the V9 built-in "profile monitor", controlled by OSC. Workload Statistics Advisor provides statistics recommendations for best optimization overall. This presentation concentrates on OSC’s capabilities (not its GUI), based on extensive V9 OSC user experience.
EXP. LEVEL: Intermediate
OSC architecture -- PC (Eclipse framework) and DB2 server (enablement, tables)
Workloads -- dynamic/static, monitored, captured, catalog, other sources
The V9 Profile Monitor -- types, sources, granules, limits, PC/DB2 shared operations
Workload Statistics Advisor experiences
Recommendations for best use of OSC in your environment
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.