Product overview
BMC AMI DevOps for Db2 brings modern DevOps practices to the mainframe by enabling automated, secure, and auditable deployment of Db2 schema changes. It is especially valuable for enterprises modernizing their mainframe development processes and aligning with DevOps and Agile methodologies.
You can use BMC AMI DevOps for Db2 to accomplish the following tasks:
- Automate the deployment of Db2 schema changes across environments
- Reduce risk by validating changes before they reach production
- Accelerate delivery by integrating database changes into CI/CD pipelines
- Ensure compliance with full audit trails
- Eliminate silos between developers and DBAs by enabling collaboration through shared tools and workflows
Capabilities in z/OSMF
BMC AMI DevOps for Db2 provides the following capabilities across the IBM z/OS Management Facility (z/OSMF) framework:
Capability | Description |
|---|---|
Authentication | You can use authentication to connect securely to target mainframe servers in one or more environments. The product prompts you for information, such as your IBM Resource Access Control Facility (RACF) credentials, certificate credentials for Universal Connector, and the server host name or IP address. |
File transfer | You can use the product to transfer files between the automation server and the mainframe. |
Schema change migration | You can choose the type of schema comparison that you want to perform. Based on your input, the product performs a comparison, generates a set of change requests for a subsystem, and builds a JCL to run those change requests. |
Impact evaluation | You can use the product to evaluate the schema change migration results and send the impact report to the deployment tool. With this report, you can assess the impact of implementing the requested change. |
JCL execution | You can submit a JCL stream to the mainframe via a data set member on the mainframe, file on the deployment server, or adhoc JCL input directly in the step. |
Schema Standards | You can analyze the schema with schema rules defined for your environment. Based on the type of schema input, Schema Standards evaluates the schema and reports violations when the schema doesn't adhere to a rule. The violations are displayed in BMC AMI Command Center for Db2 and the Schema Standards report. (BMC.DB2.SPE2510) You can use Schema Standards rules against an Impact Report using a Work ID. For more information, see Schema Standards Impact Report using Work ID. |
Benefits
BMC AMI DevOps for Db2 has the following benefits:
- Application development teams can deploy changes at the required speed without abandoning the safeguards that the DBA teams require to ensure the reliability and capability of Db2 applications.
- You can automate the deployment of database changes while ensuring application performance.
- (BMC.DB2.SPE2304) You can use the YAML file and Jenkins user interface to configure and manage database application changes on the mainframe.
- You can save a significant amount of time when reviewing, approving, or maintaining mainframe business applications based on Db2.
- You can review the impact and accountability of your project, pipeline, or workflow that contains multiple changes before implementing your schema changes.
- (BMC.DB2.SPE2304) You can use the integrated CI/CD tools to implement your preferred degree of approval oversight when migrating schema changes across the z/OS environment.
- (BMC.DB2.SPE2310) You can establish consistent schema standards applicable to your environment and analyze the schema to ensure compliance with them.
User roles
| Role | Responsibilities |
| Application developer | Create and submit Db2 schema changes and perform schema validation as part of application development |
| Db2 DBA | Review, approve, and manage database changes across environments |
| DevOps engineer | Integrate the product into CI/CD pipelines and automate deployments |
| System programmer | Configure access, monitor usage, and ensure system availability |
| Compliance officer | Review audit logs and ensure compliance with regulatory standards. |
For more information, see Roles and permissions.
Key integrations
You can integrate BMC AMI DevOps for Db2 with the following BMC products:
- BMC AMI Change Manager for Db2 — For advanced change management and impact analysis
- BMC AMI Command Center for Db2 — To managing schema standards and schema violations
- You can also integrate the product with third-party CI/CD tools, such as Jenkins, Azure DevOps, GitHub Actions, and GitLab CI/CD, for pipeline automation
Interfaces and components
BMC AMI DevOps for Db2 combines an intuitive user interface with powerful back-end components to automate and manage Db2 schema changes across environments.
The following table summarizes the key tools and systems that support deployment, validation, and governance.
| Tool or system | Type | Description |
| CI/CD web console | Interface | Manages Db2 changes and schema validation, configuring environments, and monitoring deployments via Jenkins, Azure DevOps, GitHub Actions, or GitLab CI/CD for automated deployments |
| Command-line interface (CLI) | Interface | Scripts and automates in CI/CD pipelines, and supports packaging and deployment |
| REST APIs | Interface | Enables integration with third-party systems, and provides endpoints for managing deployments |
| Mainframe integration layer | Component | Runs Db2 schema changes via z/OSMF |
| Change management engine | Component | Manages versioning, rollback logic, and deployment orchestration |
| Audit and compliance module | Component | Logs user actions and deployment history, and supports ITIL, SOX, and governance standards |
)))
)))