Monitoring OpenVMS and Oracle RDB 7.1

[Phil.Howell]

If you are using openview then you can install vms agents for monitoring.
These were originally called "insight manager" agents, then "openview" agents, then "HPsim" agents.
see this thread
http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1217488728405+28353475&threadId=1158035

Phil

[labadie_1]

Another option for Rdb monitoring, RMU/SHOW STATISTICS user defined events

1) define a symbol
$ db_alert :== @sys$login:db_alert
The file db_alert.com will contain
__________________________________
$ set verify
$ email$list == "DISK$FMS_DATA6:[MIS.MAIL]MIS_WHATSUP_DB.DIS"
$ create /nolog sys$scratch:dbr_logger.tmp
EOD
$ open /write dbr_logger sys$scratch:dbr_logger.tmp
$ if p8 .eqs. ""
$ then
$ write dbr_logger "''p1' ''p2' ''p3' ''p4' ''p5' ''p6' (triggered ''p7'
times)"
$ else
$ write dbr_logger "''p1' ''p2' ''p3' ''p4' ''p5' ''p6' (triggered ''p7'
times) area is ''p8'"
$ endif
$ close dbr_logger
$ mail sys$scratch:dbr_logger.tmp "@''email$list'" /subject="WhatsUpDB?
ALERT! - ''p2'"
$ delete /nolog sys$scratch:dbr_logger.tmp;*
$ exit
_________________________________


2) create a file rmu_events.cfg
_________________________________
EVENT_DESCRIPTION="ENABLE 'process_failures' MAX_CUR_TOTAL INITIAL 0 EVERY 1 LIMIT 0 INVOKE DB_ALERT";
_________________________________

3 Launch the command
$ rmu/show stat/config=rmu_events.cfg/noint 'base'

Then do twice something like
$ mc sql$
attach 'file base';
set transaction read write reserving 'table for protected write ;

The second attach will trigger a mail

From: SYSTEM
To: SYSTEM
CC:
Subj: WhatsUpDB? ALERT! - process_failures

13-MAR-2007 12:41:05.14 process_failures MAX_CUR_TOTAL 11.0 above 0.0 (triggered 1
================================================================================
SHOW LOCKS/MODE=BLOCKING Information
================================================================================

--------------------------------------------------------------------------------
Resource: logical area 193

ProcessID Process Name Lock ID System ID Requested Granted
--------- --------------- --------- --------- --------- -------
Waiting: 00000889 _TNA11:........ 08000EC2 00000000 PW NL
Blocker: 00000888 SYSTEM......... 0A0008B2 00000000 PW


MAIL>

[Gops_1]

Thanks for all answer...

gee