My Oracle Support Banner

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.

Purpose

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.

Or you would like to filter the log file for specific events.

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.

Scope

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 7.2.4.1 or higher. See ReadMe.htm in the kit for details.

For large log files, it may take a long time to convert the complete contents. Therefore, it is highly recommended to keep the RDMMONnn.LOG files small and to use RMU/Monitor Reopen_Log frequently.

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
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.