Operating System - OpenVMS
1748061 Members
5418 Online
108758 Solutions
New Discussion юеВ

Re: 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 12
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

---