Articles & Content


Workloads, Monitors, Advisors: V9 OSC Experiences (C13)

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.