DB/IQ Package Management

Declutter Your Db2® Catalog to Improve Application Performance

In today’s high-paced mobile landscape where customers expect non-stop availability of applications, DevOps initiatives put pressure on development teams to roll out high-quality software with fast turnarounds and more frequent release cycles. In the sprint to build, test and deploy to tight deadlines and with countless changes being processed by the minute, overwhelmed teams don’t have the bandwidth to consider the enormous build-up of packages inundating the Db2 Catalog – until that is, the bottlenecks, system delays and outages occur.

DB/IQ Package Management (PackMan) helps manage the DevOps chaos by identifying redundant packages, removing them and reorganizing the Db2 Catalog. The result is a cleaner Db2 Catalog that is streamlined for more reliable application performance.

DB/IQ Package Management for Db2 (PackMan) can help clean and declutter your Db2 Catalog in multiple areas of the SQL programming life cycle.

With DB/IQ PackMan, you can:

  • Clean up the Db2 Catalog by discarding non-required packages. An absolute must, when implementing Change Management Systems within the DevOps method
  • Prompt DBAs to easily build jobs and keep a clean and efficient Db2 Catalog
  • Avoid all potential -805/-818 problems by determining inconsistencies between DBRMs, associated packages and load modules
  • Make migration to production systems secure by determining any inconsistencies, before the BIND process takes place
  • Maintain EXPLAIN tables down to the required minimum.
  • Improve BIND times
  • Recreate DBRM members or libraries from Catalog packages
  • Prevent unnecessary BINDs by comparing a new DBRM with its predecessor version.

Story 1

Major Insurance Company trusts DB/IQ PackMan to improve Db2 performance and control mainframe budget consumption.

Story 2

Global IT service provider uses DB/IQ PackMan to clean up their Db2 Catalog, resulting in less time to execute backups and REORGs and improved end-user experience.

Have PackMan declutter your Db2 Catalog


DB/IQ PackMan


DevOps is Here,
with Its Eyes
on the Mainframe


Package Management
to Streamline DevOps
on Your Mainframe


You may also be interested in

SQL Code
Quality Assurance
on IBM z/OS


Mainframers Working
From Home, and How
to Embrace the Trend


DB/IQ Suite
Modules and