Automate Report Generation with SYSVIEW for Db2, Prometheus, & Grafana

Teams that support Db2, consisting of System Programmers, Database Administrators, and other mainframe subject matter experts, often struggle with manual, time-consuming processes like monitoring performance and generating reports. Traditionally, if you want Db2 performance data, you could find this data in SYSVIEW for Db2 through a 3270 terminal. However, that can make it hard to interpret and share the data. Alternatively, you can export the data into a spreadsheet, but this manual process often involves multiple steps:

1. Run SQL Commands.
2. Export to CSV.
3. Import to Excel for formatting and pivot charts.
4. Manually distribute the resulting reports.

Labor-intensive processes consume the time and resources of highly skilled personnel, limit their analysis capabilities, and only provide static reports with limited insights and delayed problem detection. Consequently, teams are often overwhelmed by data and operate reactively, lacking actionable insights to prevent issues.

SYSVIEW for Db2 provides integration with Prometheus through the Database Management Solutions for Db2 (DBM) Data Service REST API endpoint with the option to use API Mediation Layer, and finally display dashboards in Grafana.

1. Install and configure Prometheus to scrape and store the SYSVIEW for Db2 data.
2. Prometheus scrapes the SYSVIEW for Db2 data using the DBM Data Service REST API endpoint.
3. Install and configure Grafana to integrate with Prometheus.
4. Visualize data from Prometheus using Grafana and one of our 12 sample dashboards.
5. Modify the sample Grafana dashboards or build your own visualizations, charts, and required dashboards to perform effective analysis.
6. Onboard the Zowe-conformant DBM Data Service REST API to the Zowe API Mediation Layer to secure communication to Prometheus.