Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Monitoring OpenVMS and Oracle RDB 7.1

SOLVED
Go to solution
Gops_1
Regular Advisor

Monitoring OpenVMS and Oracle RDB 7.1

Hardware : Alpha GS320 and DS25
OS : OpenVMS 7.3.2
Oracle RDB : 7.1-411

I wish to monitor OpenVMS adn Oracle RDB using any opensource like nagios. Does anyone success on this. Please share any thing on monitoring OpenVMS and Oracle RDB.

Points 10 for all...

Thanks
Gee
12 REPLIES
Karl Rohwedder
Honored Contributor
Solution

Re: Monitoring OpenVMS and Oracle RDB 7.1

Googling leads e.g. to:

http://nrpevms.dbaalacarte.com/

which seesm to contain a How-to for a nagios daemon for OpenVMS.

regards Kalle
labadie_1
Honored Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

For monitoring VMS, you have Amds/Availability Manager among other tools, see
http://h71000.www7.hp.com/openvms/products/availman/index.html

For monitoring Rdb, you have
$ rmu/show stat 'base'

and the sda extension
$ ana/sys
rdb
which display

RDB Utility (V1.0-002) - Quick Help Information
-----------------------------------------------
RDB commands:

RDB SHOW ACTIVE_DB - displays database with lock activity

RDB SHOW PROCESS - displays Rdb lock information for a given
process
[/IDENTIFICATION=n]- process identified by its PID
[/INDEX=n] - process identified by its index
[/ADDRESS=n] - process identified by its PCB address
[/GRANTED] - displays only granted locks
[/WAITING] - displays only locks on the wait queue
(waiting I- and T-locks are ignored)
[/CONVERT] - displays only locks on the conversion que
ue
[/VALBLK] - decode and display lock value block infor
mation

RDB SHOW CONTENTION - monitors lock timeout queue for Rdb locks
stalling

Press RETURN for more.
Gops_1
Regular Advisor

Re: Monitoring OpenVMS and Oracle RDB 7.1

For monitoring Rdb, you have
$ rmu/show stat 'base'

and the sda extension
$ ana/sys
rdb
which display

RDB Utility (V1.0-002) - Quick Help Information
-----------------------------------------------
RDB commands:

RDB SHOW ACTIVE_DB - displays database with lock activity



Hey thanks for both... Points for you...

Is that the above you mentioned for monitoring Oracle RDB is a free tool. Can you give the exact tool. HAve you been success on this Oracle RDB monitoring ?

Have any one ?

Thanks
Gee
Andy Bustamante
Honored Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

T4 is a free package from HP. http://h71000.www7.hp.com/OpenVMS/products/t4/index.html Technically unsupported, it provides bundles available utilities and adds a few custom monitoring tools.

T4 is also a collection routine. I've written routines to collect data in T4 format, as have others on the forum.

The OpenVMS Technical Journal, http://h71000.www7.hp.com/openvms/journal/toc.html has articles available on T4.

Andy

If you don't have time to do it right, when will you have time to do it over? Reach me at first_name + "." + last_name at sysmanager net
Jean-François Piéronne
Trusted Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

There is a T4 collector for Rdb, latest 7.2 kit contains PERFT4_RDB Example Program.

You can find it on metalink.


JF
Thomas Ritter
Respected Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

We run RDB monitoring in detached mode and send exceptions to OPCOM. Then using an OPCOM monitor we can send message to support staff.

Here is an example how to monitor database stalls.

Here is an extract

$ RMU/SHOW STATISTIC/NOLOGICAL_AREA/ALARM='interval_to_test' -
/NOTIFY=OPER12/SCREEN="Stall Messages" 'database'.rdb

where interva_to_test = 180 seconds
Kumar_Sanjay
Regular Advisor

Re: Monitoring OpenVMS and Oracle RDB 7.1

Gope,

There is one Third Party Product you can use for monitoring... I am not sure wethere this is suitable to your environment.

But it's not free...

Unicenter Network and System Management
Database Monitoring Option for OpenVMS


Regards
Sanjay
Gops_1
Regular Advisor

Re: Monitoring OpenVMS and Oracle RDB 7.1

Hey thomas,
I will try your option. Can you share any documents on this RDB monitoring on your env.

To be very truthful am neither a OpenVMS nor a RDB fellow. I am just a NMS fellow working on Openview and some opensource tool.

So it would be helpful if you share your docs with me.

Thanks in advance...

Gee
Thomas Ritter
Respected Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

Gee, here is the complete procedure. Monitoring Database Stalls maybe the most important component. We set out limit at 180 seconds. At that point we should be in trouble.
You an also run the monitor interactively.
We use logical names for our database.

$ RMU/SHOW STATISTIC/TIME=20/ALARM=20/SCREEN="STALL MESSAGES" 'F$TRNLNM("data_base")

Enable OPCOM
$ repl/ena

+++

$!+
$!
$!
$!-
$ set noon !Handle with $status
$ nodename = f$edit(f$getsyi("nodename"),"trim")
$ this_process = "RDB$RMU&PROD"
$!
$! Stop Old Process
$!
$ ctx = ""
$ temp = f$context("process",ctx,"prcnam","''this_process'","EQL")
$ pid_to_kill = f$pid(ctx)
$ if pid_to_kill .nes. ""
$ then
$ Stop/id='pid_to_kill'
$ wait 00:00:05
$ endif
$ set proc/name="''this_process'"
$ repl/ter=opa0: "RDB_I_RMU Started on node ''nodename'"
$ Current_Interval = "20"
$!
$ x=0 !Count interactions
$has_db_logical_been_defined:
$ database = f$trnlnm("DATA_BASE","PROD") !Only if Wizard has been started.
$ if database .eqs. ""
$ then
$ x=x+1
$ repl/ter=opa0: "RDB_I_RMU ''nodename' (''x') waiting 5 minutes for DB logical to be defined."
$ wait 00:05
$ goto has_db_logical_been_defined
$ endif
$!
$ Start:
$ interval_name$logical = "RDB$RMU_''nodename'"
$ interval_to_test = f$trnlnm("''interval_name$logical'")
$ if interval_to_test .eqs. ""
$ then
$ interval_to_test = "''current_interval'"
$ def/system/exec RDB$RMU_'nodename' "''current_interval'"
$ endif
$ if "''interval_to_test'" .nes. "''current_interval'"
$ then
$ current_interval = "''interval_to_test'"
$ repl/ter=opa0: "RDB_I_RMU ''nodename' Interval set to ''Current_Interval' Seconds"
$ endif
$!
$! Set Stop Time
$!
$ time_to_end = f$cvtime("+00:10:00","absolute",)
$!
$ def sys$output nl:
$! Disable below RMU command wich has a time limit
$! RMU/SHOW STATISTIC/NOLOGICAL_AREA/ALARM='interval_to_test' -
$! /NOTIFY=OPER12/SCREEN="Stall Messages" 'database'.rdb/until="''time_to_end'"
$!
$! - Run RMU Stats for ever
$!
$ RMU/SHOW STATISTIC/NOLOGICAL_AREA/ALARM='interval_to_test' -
/NOTIFY=OPER12/SCREEN="Stall Messages" 'database'.rdb
$ deass sys$output
$ goto Start

---
Phil.Howell
Honored Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.1

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
Honored Contributor

Re: Monitoring OpenVMS and Oracle RDB 7.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
Regular Advisor

Re: Monitoring OpenVMS and Oracle RDB 7.1

Thanks for all answer...

gee