Solution
|
Interface type
|
Services
|
Comments
|
IBM Db2 Administration Foundation
|
REST
|
Run SQL
Reverse-engineer DDL for single object
Discovery
Catalog navigation
Db2 commands
BIND/REBIND/FREE
And much more
|
No charge product with support being available for a fee.
Strategic platform for administrative functions.
Also has Zowe based UI.
|
IBM Db2 DevOps Experience
|
REST
|
DevOps-related DBaaS functions: provisioning, deployment, DDL-as-code managed in git, DDL quality checks, developer self-service with DBA oversight and controls, and much more
|
License required.
Also has Zowe based UI.
|
IBM SQL Tuning Service
|
REST
|
Visual Explain
RUNSTATS advisor
Capture query environment
Format Query
Maintain explain tables
|
Part of Db2 Accessories Suite (no charge).
It can be integrated with IBM Db2 Administration Foundation
|
Zowe CLI
(Db2 plugin)
|
CLI
|
Run SQL
Call SP
Export data
|
Requires Db2 Connect license
|
Db2 CLP and Db2 CLPPLUS
|
CLI
|
Run SQL
Call SP
Export/import data and many other features
|
Included with certain IBM Data Server Drivers
Requires Db2 Connect license.
A trimmed down version of the Db2 CLP runs in USS. It does not require a Db2 Connect license.
|
IBM Db2 for z/OS
|
Stored procedures
|
Db2, DSN, MVS commands
Run Db2 utilities
Maintain explain tables
And many more
|
Part of the Db2 for z/OS engine.
Can be wrapped into a REST service using the native REST support in Db2 for z/OS (see next row)
|
IBM Db2 for z/OS
|
REST
|
Run SQL
Call stored procedure
|
Part of the Db2 for z/OS engine.
Requires defining a REST service before usage.
|
Legacy tools
|
JCL
|
Submit JCLs using z/OSMF REST APIs, Zowe CLI, IBM Z Open Automation Utilities
|
Roll your own solution using existing tooling with batch interfaces like Db2 Object Comparison Tool, Db2 Cloning Tool, and many more.
|
Ansible
|
ansible.builtin.command
|
Ansible module that provides the ability to run commands in USS to invoke CLP
|
Requires Python on z/OS, and Db2 CLP running in USS
|
ibm_zos_core.zos_mvs_raw
|
Ansible module that provides the ability to invoke z/OS programs directly
|
Requires Python and ZOAU on z/OS.
Run a z/OS program
|
ibm_zos_core.zos_job_submit
|
Ansible module that provides the ability to submit JCL
|
Requires Python and ZOAU on z/OS.
Submit JCL
|
ansible.builtin.uri
|
Ansible module that provides the ability to invoke REST requests to run SQL
Call stored procedure
|
Requires use of Ansible URI module, and defining a REST service before usage.
|
REST
|
Published sample Db2 Collection of Playbooks invoking IBM Db2 DevOps Experience APIs
|
Requires IBM Db2 DevOps Experience
Ansible-Db2-collection
|
UrbanCode Deploy
|
REST
|
Published sample plugin for CI/CD pipeline
|
Requires IBM Db2 DevOps Experience
UCD-DOE plugin
|