Software Directory
Our Network
Top Download Titles
|
|
|
|
DB2 Query Monitor for zOS
|
IBM DB2 Query Monitor gives you the ability to efficiently customize and tune your structured query language (SQL) workload and DB2 objects to ensure the effectiveness of your DB2 subsystems and improve overall performance. The tool offers you extensive choices so you can determine what monitoring information you will gather, and when.
DB2 Query Monitor lets you access alerts from a Java-based web browser that provides views of performance data. Enhanced integration capabilities let you launch Visual Explain, which shows the paths DB2 uses to run queries helping you select the most efficient path.
DB2 Query Monitor can also launch Tivoli OMEGAMON XE for DB2 Performance Expert in context and display threads in the active subsystem to save you navigation time. And you can invoke IBM DB2 SQL Performance Analyzer when youve discovered a problem SQL statement. Improvements in SQL processing let you store data in DB2 making it easier to do statistical analysis on data and create your own reports using tools like QMF and QMF for Windows.
User-defined settings trigger warnings when a threshold is crossed, helping avoid unnecessary repair costs. Trouble shooting costs can be reduced by a feature that finds the cause of delays in SQL queries in real time. Using DB2 Query Monitor, you can pinpoint activity important to your business, enabling you to spot potential problems and take steps to resolve these problems quickly.
|
|
|
|
