DB/IQ Package Management
DB/IQ Package Management (PackMan) is an advanced solution designed to optimise and streamline Db2 catalogue management. In DevOps environments where deployment cycles are getting faster and faster, Db2 packages accumulate over the course of versions and tests, cluttering the catalogue and impacting the performance of backups, reorganisations and SQL executions.
PackMan acts as an intelligent manager of the Db2 catalogue, identifying and removing obsolete or redundant packages. It provides proactive maintenance by reorganising metadata, thus guaranteeing faster access to data and optimisation of system resources.
The key features of DB/IQ PackMan:
- Clean up the Db2 catalogue by removing unnecessary packages, an essential step in implementing effective change management in a DevOps environment.
- Facilitate the work of DBAs by providing them with tools to generate tasks quickly and maintain a structured and efficient Db2 catalogue.
- Prevent -805/-818 errors by detecting inconsistencies between DBRMs, corresponding packages and load modules, thus guaranteeing the integrity of SQL executions.
- Secure deployments in production by identifying upstream any anomaly that could compromise the BIND process.
- Optimise EXPLAIN tables by keeping them to the bare minimum necessary for effective performance analysis.
- Reduce BIND times, thus improving the responsiveness of application deployments.
- Restore missing DBRMs by recreating DBRM members or libraries from the catalogue packages.
- Avoid unnecessary BINDs by comparing successive versions of DBRMs and only launching the operation if necessary.
