Products & Solutions
DB2 Index Management Solution
CDB’s DB2 Index Management Solution takes advantage of DB2 Real Time Statistics to perform just in time maintenance of DB2 Indexes with little to no manual intervention. Real time automation provides the flexibility to allow the user to make data maintenance decisions and design a data maintenance strategy for DB2 Indexes based on real and changing business needs, not based on limitations of existing tools. Index Analysis provides information to assist the user in efficient index creation.
Key Benefits
- Easy Restartability
- Flexible and Intelligent Automation to improve efficiency and productivity
- Elimination of all unnecessary Index Reorg runs greatly reducing data management costs
- Drastically reduced CPU and Elapsed Time delaying or eliminating the need for CPU upgrades
- Scalable to easily handle the growing limits of DB2 Indexes
- Online reorganization with true and full 100% availability to meet any availability requirements
- Leverages existing hardware infrastructure including offloading work to zIIPs
- Index Analysis to determine efficient Index design for application performance
Functionality
- Automated Index maintenance based on DB2 Real Time Statistics
- 100% available index reorganization with patented no-sort technology keeps applications running without interference
- Indexes are reorganized at rapid speeds so extremely large indexes may be processed with ease
- Online Rebuild of DB2 Indexes
- Online checking of the integrity of DB2 Indexes at dramatic high speeds
- Index Analysis to determine the most efficient indexes for application performance