|
IBM Optimization Service Center for DB2 for z/OS (IBM OSC) is a workstation tool for monitoring and tuning the SQL statements that run on your DB2 9 for z/OS and DB2 for z/OS Version 8 subsystems and data sharing groups. IBM OSC provides a subset of the full suite of powerful features that are available in IBM DB2 Optimization Expert for z/OS. Learn more. The most recent fix pack for IBM OSC includes support for DB2 for z/OS Version 8 subsystems (compatibility and new-function modes), support for DB2 data sharing environments, and an improved user-experience. You can use IBM OSC to identify and analyze problem SQL statements and to perform many tuning tasks:
- 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 which gather more complete statistics than RUNSTATS ALL jobs
- Quickly "snap the cache" to 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, including static SQL statements from across a data sharing group
- Proactively monitor the health of your DB2 9 for z/OS SQL workloads during normal processing, and receive problem alerts when a statement exceeds exception thresholds
IBM 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
IBM OSC is offered as part of the DB2 Accessories Suite for z/OS, product number 5655-R14.
DB2 for z/OS System Requirements Ensure that your DB2 for z/OS system meets the prequisites for using Optimization Service Center for DB2 for z/OS Subsystem Prerequisites for Using Optimization Service Center with DB2 for z/OS Hardware Requirements Ensure that your workstation meets the following hardware requirements:
- 500 MB of space on your hard disk drive
- 1 GB of memory
- A Pentium® IV processor equivalent or above
Software Requirements Ensure that you have the following software installed on your workstation:
- One of the following Microsoft® Windows® operating systems: Windows 2000, Windows XP, Windows 2003, Windows Vista (with additional requirements)
- DB2 Connect - Application Server, Enterprise, Personal, or Unlimited Edition, Version 8 or later.
- An IP network connection to a DB2 9 for z/OS or DB2 for z/OS Version 8 subsystem.
Recommendation: Do not use a dial-up connection. Use a broadband network connection.
DB2 Optimization Expert for z/OS
Take SQL workload tuning to the next level with access path, index, and query advisors for SQL statements and workloads. OMEGAMON XE for DB2 Performance Expert OMEGAMON XE for DB2 Performance Monitor DB2 Query Monitor
| 
