Tracking transaction on Interval Control
Article ID: 189952
Updated On:
Products
SYSVIEW Performance Management
NXBRIDGE - SYSVIEW/ENDEVOR
Issue/Introduction
We have a need to track transactions which are on the ICE chain and restart the transactions if they fail.
We had situation where Transactions on ICE fail when DB2 crashed and they had to be manually restarted to put them back to ICE chain.
We would like to know if SYSVIEW monitor can be used to monitor a tran that has not run for a certain interval, is not actively scheduled in the ICE chain, and later take an action to start it so no manual intervention is required.
Environment
Release : 16.0
Component : SYSVIEW
Resolution
Metric TSUMELAP and threshold definition option OPS/MVS event notification will achieve what you're asking
TSUMELAP is the elapsed time since SYSVIEW had last seen the transaction run.
The example threshold definition below will be triggered if it 3 minutes had passed since transaction CATR in region SYSVC690 was last run.
When the threshold is triggered, event CAGSVY0001 is sent to OPS/MVS. You can handle the event from the OPS/MVS side to start the transaction or any other logic decisions you need to make based on the monitoring data provided by SYSVIEW.
+-Update and press the F3 key to save -------- Enter "?" in field for help ---+
| Variable Jobname Resource1 Resource2 |
| TSUMELAP SYSVC690 CATR____ ________ |
| |
| |
| Description Transaction summary - Elapsed time______ |
| Attributes----------------- Notification---------- Event Capture--------- |
| Rule Type UPPER___ WTO Message YES Trigger Level NONE____ |
| Type TRANSUMM Log Message YES Interval 00:15:00 |
| Trigger Level STATUS__ SMF Record YES Event Member *_______ |
| Problem Limit 00:03:00 |
| Warning Limit 00:00:00 OPS/MVS--------------- GSS Intelligent Module |
| Warning Pct 80_ Notify YES_ Run NO_ |
| Duration 2__ Event ID CAGSVY0001 IMOD *_______________ |
| Alert Priority 0__ |
| Disabled NO_ SNMP Trap------------- Transaction Cancel---- |
| Schedule------------------- Send NO_ Cancel Action NONE |
| Sun Mon Tue Wed Thu Fri Sat Group List *_______ Cancel Limit |
| SUN MON TUE WED THU FRI SAT |
| Begin Time 00:00:00________ |
| End Time 23:59:59________ |
+- F1 Help F3 Save F12 Cancel ----------------------------------------------+
TSUMELAP is the elapsed time since SYSVIEW had last seen the transaction run.
The example threshold definition below will be triggered if it 3 minutes had passed since transaction CATR in region SYSVC690 was last run.
When the threshold is triggered, event CAGSVY0001 is sent to OPS/MVS. You can handle the event from the OPS/MVS side to start the transaction or any other logic decisions you need to make based on the monitoring data provided by SYSVIEW.
+-Update and press the F3 key to save -------- Enter "?" in field for help ---+
| Variable Jobname Resource1 Resource2 |
| TSUMELAP SYSVC690 CATR____ ________ |
| |
| |
| Description Transaction summary - Elapsed time______ |
| Attributes----------------- Notification---------- Event Capture--------- |
| Rule Type UPPER___ WTO Message YES Trigger Level NONE____ |
| Type TRANSUMM Log Message YES Interval 00:15:00 |
| Trigger Level STATUS__ SMF Record YES Event Member *_______ |
| Problem Limit 00:03:00 |
| Warning Limit 00:00:00 OPS/MVS--------------- GSS Intelligent Module |
| Warning Pct 80_ Notify YES_ Run NO_ |
| Duration 2__ Event ID CAGSVY0001 IMOD *_______________ |
| Alert Priority 0__ |
| Disabled NO_ SNMP Trap------------- Transaction Cancel---- |
| Schedule------------------- Send NO_ Cancel Action NONE |
| Sun Mon Tue Wed Thu Fri Sat Group List *_______ Cancel Limit |
| SUN MON TUE WED THU FRI SAT |
| Begin Time 00:00:00________ |
| End Time 23:59:59________ |
+- F1 Help F3 Save F12 Cancel ----------------------------------------------+
Feedback
Yes
No
Powered by
