Filter
Top Products
ReadiVoice Administration & Maintenance Guide
148 Proprietary & Confidential
Logging Database Activity with the Database Monitoring Script
Your ReadiVoice installation includes a Perl script,
dbMon.pl
, that logs
Informix database information (such as number of active sessions and amount
of memory used per session) into a file that can be used later for analysis.
If your system seems to be slowed by SQL queries that are taking inordinately
long, it may be helpful to run this script and provide the resulting log file to
your Polycom Global Services representative.
The
dbMon.pl
script:
• Resides in the
/rahome/database/scripts
directory.
• Must be run by root.
• Should normally be run in the background.
The script creates a log file named
YYYYMMDDhhmmssdbMon.log
, where
YYYYMMDDhhmmss
is the system date and time (using a 4-digit year and 24-hour
time) when the script is run. For example, if you run
dbMon.pl
on August 14th,
2002, at 2:22:37 PM, it creates a log file named
20020814142237dbMon.log
.
The log files are written to the
/rahome/database/scripts/archives/
directory.
Running the
dbMon.pl
Script
The syntax for running the
dbMon.pl
script is:
dbMon [-r n &]
To use the runtime option (
-r
), replace
n
with the number of minutes you want
the script to run. If you omit this option, the script runs for the default duration
of 5 minutes. Use
&
to make it a background process.
For example, enter
dbMon.pl –r 20 &
at the command prompt to run the
script in the background for 20 minutes.
Contents of
dbMon.pl
Log File
The
dbMon.pl
script writes data to the log file at one-second and ten-second
intervals.
Logged every second:
Active SQL statements: This section shows the session IDs and the statement
types (
SELECT
,
UPDATE
,
INSERT
or
UPDATE STAT
) of the SQL statements that are
currently running.
Caution!
Use this script only if you are trained and knowledgeable in working with Solaris,
Informix, and the ReadiVoice system.