|
Business Challenge
DB2 for OS/390 requires large complex memory structures, commonly referred to as pools, to manage, modify, and access the data it maintains. Keeping these pools optimally configured so that DB2 applications can achieve high performance and deliver required service levels requires constant upkeep. Many IT shops have neither the time nor the expertise to tune pools optimally. Increasing and constantly changing workload requirements add to unpredictability and downtime which critically effect business reliability and competition.
Business Need
- Deliver maximum level of application performance to meet SLAs
- Minimize system costs associated with DB2
- Avoid system problems and downtime by automatically detecting and correcting system problems
- Maintain performance consistency with constantly adjusting application workloads
Our Solution
Pool Advisor for DB2 is the first solution with the built-in intelligence to tune DB2 pools proactively and automatically. Pool Advisor helps make the administrator's job easier by allowing them to focus on other critical duties. By ensuring that DB2 pools are optimally tuned continuously, DB2 applications will run more efficiently and quickly. As a result, DB2 performance can be maintained or improved in order to achieve the goal of 24x7 availability and improved response time. Pool Advisor for DB2 provides expert assistance in performance tuning and problem resolution.
Key Features & Benefits
- Makes recommendations regarding resource allocation, object configuration and DB2 parameter settings
- Manages all DB2 storage resource pools including buffer, RID, EDM and Sort pools
- Intelligently adjusts pool sizes to optimize performance while considering overall storage usage
- Provides immediate resizing of DB2 memory pools (either at the user's request or automatically)
- Reduces overhead associated with DB2 dynamic statement cache management
- Provides configuration analysis to ensure consistency and overall health of buffer pools without affecting DB2 performance
|
|
|
Brochure
|
-
BMC Educational Services
(pdf)
-
BMC Mainframe Solutions
(pdf)
-
BMC Database Management for DB2
(pdf)
-
DB2 UDB Family Reference Guide Book Version 8
(pdf)
-
2008 BMC Annual Report
(pdf)
-
BMC Software & IBM: Engaged In Your Success
(pdf)
-
DB2 9 for z/OS Reference Guide
(pdf)
|
|
Datasheet
|
-
Pool Advisor for DB2
(pdf)
-
BMC Pool Advisor Family for DB2 z/O
(pdf)
|
|
Success Story
|
-
3BEG improves system performance by implementing Pool Advisor
(pdf)
|
|
White Paper
|
-
Swing into Business Service Management - Seven Strategies
(pdf)
-
DB2 Version 9 - A Perspective
(pdf)
(htm)
|
|
|
|
|
| |
|
|
|
