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 Back Up and Recovery
This Database Backup and Recovery module provides robust backup and recovery capabilities tailored specifically for your Db2 for z/OS databases running on the z/OS platform.
Disaster Recovery
The Disaster Recovery module evaluates and enhances your disaster recovery capabilities to ensure your organisation can respond effectively and promptly to major outages during which you can no longer conduct business from your primary production site.
ZMARS
The Z Mainframe Availability and Resiliency Service (ZMARS) comprises of various modules designed to enhance your Db2 server’s resilience, continuous application service availability, recovery speed, and system performance.