The new Optimization Service Center for DB2 for z/OS

Hi folks,

do you already know IBM’s new OSC (Optimization Service Center)? It supersedes the old Visual Explain and … it’s still [highlight]free[/highlight].

IBM Optimization Service Center for DB2 for z/OS is a workstation tool for monitoring and tuning the SQL statements that run on DB2 9 for z/OS and DB2 for z/OS Version 8.

• Analyze statements and at the workload level – such as all SQL statements from a particular collection, plan, or package
• Learn about statistics that are missing, inaccurate, or out-of-date and automatically generate specialized RUNTSTAS control statements
• Capture dynamic SQL statements from a DB2 subsystem or data sharing group, and analyze them as a workload, or drill into individual statements for detailed analysis
• Capture runtime information, such as number of executions and CPU time, about statements
• Proactively monitor the health of DB2 9 for z/OS SQL workloads, and receive problem alerts when a statement exceeds exception thresholds
• Format and view SQL statements with statistics annotations and as transformed by the DB2 optimizer
• View EXPLAIN information for individual SQL statements in a graphical format that makes relationships between database objects and operations instantly clear
• Graphically create and deploy plan hints

Enabling a DB2 for z/OS subsystem for IBM Optimization Service Center for DB2 for z/OS: http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21358693. You should ask your system administrator for installation and assistence! But: You do not need to apply an SMP/E install. You may even install the DB2 z/OS components directly from your workstation using sysadm authorization.

More product information and download link, see http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27017059

Even if you don’t want to install the OSC, you should take at least a look on online help and documentation.

regards
Gernot