My Oracle Support Banner

RDBPROD: DCL Script for notifying the idle/hung OpenVMS process (Doc ID 2421158.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Rdb Server on OpenVMS - Version 2.3 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
HP OpenVMS VAX

Goal

To monitor an OpenVMS process and trigger an email notification if it is idle or hung for some time. 

Reason: There are some situations where a process goes idle for a period of time then fails and it is difficult to reproduce the scenario. With the below script, a notification is sent for the hung scenario. The DBA or system administrator can then examine the process to try to determine if it is being blocked by another process or is running. RMU/SHOW STATISTICS -> Stall Messages could be executed at that time.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.