|
DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
IBM Optimization Service Center for z/OS is now generally available for free download from the DB2 for z/OS Web site! You can check it out here:
http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html
DB2 for z/OS
Optimization Service Center for DB2 for z/OS
IBM Optimization Service Center for DB2 for z/OS (OSC) is a workstation tool for monitoring and tuning the SQL statements that run on your DB2 for z/OS subsystem. You can use OSC to identify and analyze problem SQL statements and to perform tuning tasks:
Analyze statements and at the workload level - all SQL statements from a particular collection, plan, or package Learn what statistics are missing and automatically generate specialized RUNTSTAS control statements that go beyond RUNSTATS ALL jobs Quickly "snap the cache" to capture dynamic SQL statements and analyze them as a workload or drill into individual statements Capture runtime information, such as number of executions and CPU time, about statements, including static SQL statements Proactively monitor the health of your SQL workloads during normal processing, and receive problem alerts when a statement exceeds exception thresholds OSC also provides powerful tuning tools that enable the experienced DBA to drill into SQL statements and perform detailed analysis tasks:
Format and view SQL statements with statistics annotations and the statement as transformed by the DB2 optimizer View EXPLAIN information for individual SQL statements in a graphical format, making relationships between database objects and operations instantly clear Graphically create and deploy plan hints
Download Optimization Service Center for DB2 for z/OS
OSC is offered as part of the DB2 Accessories Suite for z/OS, product number 5655-R14.
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Development
DB2 Information Management Software
© Gernot Ruban