Db2 Tools for z/OS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Db2 Log Analysis Tool – Integration with OMEGAMON Data Provider (ODP)

By Xingyan Jiang posted Wed May 28, 2025 05:31 PM

  

Db2 Log Analysis Tool provides comprehensive log-based solutions on reporting, auditing, recovery and replication. Now there is an additional way of presenting and analyzing the log data in analytics dashboards. This blog looks at a new feature of streaming log summary data to OMEGAMON Data Provider by Log Analysis Tool 3.6 with PTF PH64626. 

Log Analysis Tool Summary report shows the number of INSERTs, UPDATEs, and DELETEs per Db2 table (accumulated at the tablespace and database level as well) during the specified time period. Below is the summary batch report:

Sample summary report 

Now the new optionSend data to ODP’ is available in the classic General Report panel. Enable this option allows summary report data to be streamed into the ODP pipeline. 

A screenshot of a computer

AI-generated content may be incorrect., Picture 

The following step specifies the ODP Data Broker information (Broker name, Store name, load library), and optionally sets the threshold time to group the data into certain time periods (e.g., every 30 minutes) 

A screen shot of a black screen

AI-generated content may be incorrect., Picture 

Broker name and the Store name will depend on the type of server when Configuring OMEGAMON Data Broker. Data Broker receives data from Log Analysis Tool and stores data in data store, then forwards the data to Sink (OMEGAMON Data Connect). Data Connect transforms data to be sent via JSON to analytics servers like Elastic, Splunk, Kafka, and more. For further OMEGAMON Data Provider information, see here. 

A blue rectangular sign with white text

AI-generated content may be incorrect., Picture 

 

To get started quickly, Elastic Kibana dashboards are available on GitHub, you can download it as a starting point and develop your own dashboards. Here are some samples:  

A graph with different colored squares

AI-generated content may be incorrect., Picture 

Summary of Insert/Update/Delete activity by Db2 Subsystem  

By tracking data changes on Db2 subsystem level, you can easily compare data modification activities across different Db2 subsystems. It could also help with proactive planning on the log file sizing, archiving/checkpoint frequency, OUTBUFF setting... for the heavy data changing Db2, to prevent potential log performance issues. 

 

A graph of a graph

AI-generated content may be incorrect., Picture 

Summary of Insert/Update/Delete activity by database  

 

A graph with different colored lines

AI-generated content may be incorrect., Picture 

Summary of Insert/Update/Delete activity by object  

By viewing data change activity on object level, it is useful for showing how often sensitive objects are updated. If abnormal quantity is shown compared to usual, then you can take a Detail report or use Audit mode to find out the root cause of the unexpected changes.  

You can also identify changes over time to see which objects are "hot" (frequently modified), that may require a REORG. When scheduling the REORG utility or other maintenance tasks, you may want to choose a common quiet time window with less activities happening by gaining insight from the dashboards, to minimize the impact while saving costs.

Tip: For constant streaming to ODP, use Db2 Log Analysis Tool Continuous mode, and schedule the job at regular intervals to keep feeding data, to get continuous dashboards.

#Db2Toolsforz/OS

#Db2forz/OS

#OMEGAMON

#ODP

0 comments
54 views

Permalink