Accessing event monitor data in regular tables
You can use SQL to directly access event monitor data that is written to regular relational tables.
Before you begin
- Create and activate the event monitor
- Enable data collection if required for the type of event monitor that you are using and the type of data that you want to collect
- Run the workload or applications for which you want to collect monitoring data
Optionally, depending on how you are using the event monitor data, deactivate data collection before you start examining the event data. If the event monitor remains active, it continues to write data to the output tables. Therefore, the results from one query might differ from the results that you obtain by running the same query later on.
About this task
Procedure
To retrieve information from the tables that are produced by an event monitor that writes to tables:
Results
STMT PARTICIPANT_NO APPL_NAME LOCK_WAIT_VAL
------------------------- -------------- ---------- --------------------
select * from staff 2 db2bp 0
select * from staff 1 db2bp 1000
LOCK_MODE_REQUESTED PARTICIPANT_TYPE
-------------------- ----------------
0 OWNER
1 REQUESTER
2 record(s) selected.