Database Housekeeping
Database Housekeeping Module
Our Database Housekeeping module is part of our comprehensive Mainframe Availability and Resilience Service (ZMARS). This module helps safeguard the stability and performance of your database environment by maintaining efficient CPU usage and ensuring reliable response times for critical operations.
What is Database Housekeeping?
Database Housekeeping involves reorganising database objects, collecting access path statistics, and optimising SQL performance through BIND/REBIND and PREPARE operations. These processes help maintain CPU efficiency and ensure good response times for critical transactions and batch processes.
WHY IT MATTERS
Frequent reorganisation and accurate statistics collection are essential for optimal database performance. Without regular maintenance, databases can suffer from access path instability, inefficient query performance, and increased CPU costs, leading to degraded performance of critical SQL operations.
Database Housekeeping involves several key activities essential for maintaining optimal database performance:
Reorganisation of Database Objects:
Frequent reorganisation of tablespaces and indexes is crucial for efficient CPU usage and maintaining good response times for SQL queries used in high-volume transactions and batch processes.
Access Path Statistics Collection:
Accurate and timely collection of access path statistics, either during reorganisation or through standalone RUNSTATS utilities, is vital for optimised access path selection for both static and dynamic SQL.
BIND/REBIND and PREPARE Operations:
These processes offer opportunities for more optimal access path selection, although they also come with the risk of access path regression, which can degrade CPU and elapsed time performance.
Addressing these issues is essential for maintaining database efficiency and preventing performance degradation.
How We Can Help
Our experienced consultants conduct a comprehensive technical study, reviewing your current REORG and RUNSTATS rules, and providing tailored recommendations to enhance your database performance.
We will:
Review the rules applied in determining the need for REORG and RUNSTATS, whether based on DSNACCOX settings or similar standards. Recommendations will be provided to upgrade existing rules and include new ones.
Advise on what metrics to collect and analyse to identify frequent triggers, helping to fine-tune physical database design and reduce the frequency of database object reorganisation.
Analyse and review the BIND and REBIND options recommend adjustments to enhance access path selection and stability.
Evaluate strategies and designs to exploit Db2 continuous delivery (APPLCOMPAT) for both local applications (CICS, IMS/TM, Batch) and distributed applications.
Database Backup and Recovery
Is your backup and recovery strategy tailored for optimised, safe local recovery in scenarios ranging from single object recovery to mass recovery after logical data corruption?
Software Maintenance
Do your software maintenance practices minimise the risks to service availability caused by software defects while still providing the functionality required by your business?
Db2 for z/OS Application Design and Quality Assurance
Do your real-time monitoring and historical performance reporting practices help you proactively identify and prevent service disruptions caused by performance and workload deviations from the normal?