Skip to content
Infrastructure Services / Z Mainframe Availability and Resiliency Service (ZMARS) / Db2 for z/OS Application Design and Quality Assurance

Db2 for z/OS Application Design and Quality Assurance

Achieve service availability by implementing enforceable database and application design standards to prevent inefficiencies and outages.

Db2 for z/OS Application Design and Quality Assurance Module

The Db2 for z/OS Application Design and Quality Assurance ZMARS module focusses on your application design and quality assurance practices.

This is to understand what SQL DML and DDL standards are defined, how they are enforced, and what quality gates are in place, not only to ensure that database schema changes and new/changed applications to standards but also to ensure that they don’t cause performance problems, service availability issues, or outages when they are promoted to production.

The Triton study team will produce an easily consumable report with prioritised findings and recommendations that, if implemented, will help ensure that database schema changes and application changes do not impact service availability and resilience.

Application Design and Quality Assurance Db2 ZMARS

Why It Matters

Inefficient database design and badly behaved applications are one of the major causes of service availability issues. It is vital to have well-designed, enforceable database design and application design standards in place to protect the production system, avoid compromising service availability and guard against service outages.

Well-documented and enforceable DDL standards supported by automated processes are an essential tool to help application development teams and DBAs design and maintain database schemas in line with organisational performance and availability requirements.

 

As with DDL, well-documented and enforceable SQL DML standards can help ensure that badly-behaved applications are identified and corrected before being implemented in production. Where possible, this should be supported by an automated or semi-automated process validating conformance to the standards with a rules-based approach that identifies, for example, certain types of access path known to perform poorly.

Why Triton?

Our ZMARS study will be led by John Campbell, IBM Alumni, retired IBM Distinguished Engineer and previous leader of the Db2 for z/OS SWAT team. John has worked with Db2 for z/OS for over 40 years and has extensive experience in systems, database, and application design.

Triton’s ZMARS consultants are specialists with extensive technical expertise, dedicated to collaborating with C-level teams. Each of our ZMARS consultants brings over 30 years of experience with Db2.

The ZMARS Modular Approach
Our Application Design and Quality Assurance module is only one part of a wider suite of Mainframe Availability and Resilience (ZMARS) modules. Want to see what else ZMARS offers? Visit our ZMARS service page for a full list of modules.
Read more

Db2 for z/OS Automation

Does your automation solution capture relevant Db2 exception messages and trigger automated action, to support your day-to-day operations and add an extra layer of robustness to your strategy for resilience and availability?

Read more

ZPARMS

Do your ZPARMS conform to recommended best practice, are they in line with your availability and resilience policies, and are key ZPARMS specified consistently across the data sharing group?

Read more

System and Application Performance Monitoring

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?