Db2 for z/OS Application Design and Quality Assurance
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.

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.
Database Design
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.
SQL DML Coding Standards
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.
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?
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?
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?