 | 16 May 2007 Experience the combined power of DB2® Query Patroller and DB2 Performance Expert. To further improve data server performance, these complementary tools have been bundled together to form the Performance Optimization feature of DB2 9. The contents of this eKit will teach you how the DB2 9 Performance Optimization feature for DB2 Linux™, UNIX® and Windows® can help improve your performance, throughput, and response times.
Proactive management with the DB2 9 Performance Optimization feature
DB2 9, the latest IBM® data server, introduces the Performance Optimization feature. This feature comprises two important tools to collectively manage the performance of your database system; DB2 Performance Expert and DB2 Query Patroller are complementary tools that improve data server performance, response times, and throughput. While DB2 Query Patroller enables you to focus on queries (with the ability to hold, schedule, cancel, fix, and prioritize queries), DB2 Performance Expert allows you to focus on the overall DB2 system, operating system, and application performance, which can be monitored and analyzed over time.
DB2 Query Patroller is a powerful query management system that you can use to proactively and dynamically control the flow of queries against DB2 databases. DB2 Performance Expert is a monitor and analysis tool for DB2 system and application activity, and for DB2 Connect. It concurrently monitors the operating system resources, the CPU, input/output, and memory, while improving overall database responsiveness.
DB2 Query Patroller: Superior query management facilities
In this eKit, learn how DB2 Query Patroller:
- Allows you to define separate query classes to share system resources among all queries
- Automatically puts large queries on hold so that they can be canceled or scheduled to run during off-peak hours
- Allows administrators to prioritize queued queries based on business needs
- Gives you the option of tracking queries, cancelling runaway queriesm, and proactively control the flow of queries
DB2 Performance Expert: Offering a consistent view of your data servers
In this eKit, learn how DB2 Performance Expert:
- Automatically manages the alerts that monitor a landscape of DB2 instances
- Provides current, recent history, and historical data for automated analysis
- Provides hundreds of built-in reports that cover all aspects of DB2 operations
- Identifies resource shortages and exceptional conditions in DB2, both for current conditions and past history
The Performance Optimization eKit has been assembled to serve as a one-stop resource for you! Learn more about this brand-new feature from the IBM line of data servers. The eKit contains links to white papers, demos, videos and other educational material for developers, data architects and DBA's. See for yourself just how this feature can significantly improve the performance of your systems.
| | | |
