- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Monitoring OpenVMS and Oracle RDB 7.1
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 01:40 AM
тАО07-30-2008 01:40 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 02:19 AM
тАО07-30-2008 02:19 AM
Solutionhttp://nrpevms.dbaalacarte.com/
which seesm to contain a How-to for a nagios daemon for OpenVMS.
regards Kalle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 02:39 AM
тАО07-30-2008 02:39 AM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 08:04 AM
тАО07-30-2008 08:04 AM
Re: Monitoring OpenVMS and Oracle RDB 7.1
$ 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 08:28 AM
тАО07-30-2008 08:28 AM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 11:28 AM
тАО07-30-2008 11:28 AM
Re: Monitoring OpenVMS and Oracle RDB 7.1
You can find it on metalink.
JF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 05:23 PM
тАО07-30-2008 05:23 PM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 07:17 PM
тАО07-30-2008 07:17 PM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 09:36 PM
тАО07-30-2008 09:36 PM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 09:54 PM
тАО07-30-2008 09:54 PM
Re: Monitoring OpenVMS and Oracle RDB 7.1
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
---