RDBPROD: Tool to Analyze Rdb Monitor (RDMMON) log file
(Doc ID 1620664.1)
Last updated on JULY 28, 2016
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
The procedure stores each entry of RDMMON log (which consists of several lines) as one row in an Rdb database. It also links each ATTACH entry with the corresponding DETACH entry. SQL can then be used to create reports to analyze usage and operation of the database.
RDMMONnn.LOG is a simple text file, with each entry consisting of several lines. Therefore, it is difficult to select information for specific events, key words or terms. The OpenVMS SEARCH command is available, however SEARCH cannot treat a block of lines as one item.
In many cases you want to see an extract of the RDMMON log file (or files if more than one node is involved), filtered by various key words or terms.
- all the messages for a single database
- a specific time interval
- and others
Or you would like to filter the log file for specific events.
- attaches (with duration)
- abnormal terminations
- creation and duration of recovery processes
- ABS invokes
- and others
This would all be possible if the entries from the RDMMON log file were available in an Rdb database, where each record represents one complete entry from the RDMMON log file.
This tool converts and loads the RDMMON log file(s) into an Rdb database and provides several sample report procedures.
This tool can be applied to all versions of RDMMONnn.LOG files. However in older versions some messages had less information, so some reports will return less information than for Rdb 7.2 or later.
The Rdb version used for conversion should be Rdb 18.104.22.168 or higher. See ReadMe.htm in the kit for details.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document