Community
IBM Community Home
AIOps & Management
Business Analytics
Business Automation
Cloud Pak for Data
Data Science
DataOps
Hybrid Data Management
IBM Japan
IBM Z & LinuxONE
Integration
Internet of Things
Power Systems
Public Cloud
Network Automation
Security
Storage
Supply Chain
Watson Apps
WebSphere & DevOps
Log in
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Hybrid Data Management
Topic groups
HDM Global
Data Server Manager
Database Conversion Workbench
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Data Management Console
Db2 Early Access Program
Db2 Event Store
Db2 DevOps Experience Sponsor User Program Community
Db2 for z/OS
Db2 Tools for z/OS
Db2 Warehouse (On Premises and Cloud)
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Hybrid Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Hybrid Data Management Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
IBM Hybrid Data Management Community
Connect with Db2, Informix, open source, and other data experts to gain value from your data, share insights, and solve problems.
Join / Log in
Skip main navigation (Press Enter).
Toggle navigation
Content types
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
Date range
on this day
between these dates
Posted by
User Groups
User Group Tag Test
IBM Db2 Data Management Console
DB2
Data and AI on IBM Z
Db2
View Only
Group Home
Discussion
797
Library
15
Blogs
22
Events
0
Members
313
Back to Blog List
Enabling Event Monitoring for Responsiveness and Statement History
By
Peter KOHLMANN
posted
Thu May 30, 2019 10:36 AM
Options Dropdown
0
Recommend
There are two ways that the console collects monitoring database from the Db2 engine. One method records key performance in memory metrics every few minutes and stores them in the console history database. The other method uses event monitors. Event monitors create a record in a table in the monitored database every time an event occurs. So for example, every five minutes we can check a metric to see how many statements have run since the last time we checked. However if we want a detailed record of what happened each time one of those statement ran we need to use an event monitor. That history is initially stored in your monitored database and then transferred to your console history database.
You may have noticed that the responsiveness "widget" on the database monitoring summary page isn't working when you first connected to your database. That "widget" requires an event monitor. While the console can create the event monitors the console, there needs to be a space allocated to store the event records. While we could have done that for you, many users want and need complete control over any changes to their database. So instead of just creating the objects automatically, we have provided explicit instructions that you can follow in the
Db2 Data Management Console Knowledge Center
.
1 comment
106 views
Permalink
Comments
Miodrag Labudovic
Fri January 24, 2020 05:42 AM
Hi,
To collect individual executions data, I run the script which created and
run procedure successfully. But, this widget is not working. I have no idea why it is not working.
Best regards,
Miodrag
Hybrid Data Management
Topic groups
HDM Global
Data Server Manager
Database Conversion Workbench
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Data Management Console
Db2 Early Access Program
Db2 Event Store
Db2 DevOps Experience Sponsor User Program Community
Db2 for z/OS
Db2 Tools for z/OS
Db2 Warehouse (On Premises and Cloud)
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Hybrid Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Hybrid Data Management Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
Copyright © 2020 IBM Data Science Community. All rights reserved.
Powered by Higher Logic