Day-to-DayOperation
instructing the table administration program, rmstbladm, to remove old entries. Before
running rmstbladm, archive any data you want to keep as described in Section 9.4.4.
Remove old entries as follows:
#rmstbladm -c
rmstbladm clears out all entries that are older than a specifiedlifetime. The lifetime for
job data and the lifetime for statistical data are specified in the attributes table (see
Section 10.2.3).
Failureto clear old entries can causeproblems as describedat theend of this section.
See Section 9.4.3 for details about the accounting statistics table which also grows over
time.
Acron job can be set up to clearout the tables. In the following example,this task is
performedat 2 a.m. each weekday morning.
0 2 * * 1-5 /usr/bin/rmstbladm -c
Troubleshooting
If the tables are not cleared out on a regular basis, the database continues to grow until
the performance of RMS is affected. Indications that this is happening include the
following:
The database server,msqld, uses more memory.
The table join operations performed by rinfo take longer.
Queries acting on large tables may exceed normal user memory limits.
rmstbladm takes a long time to clear out old entries or may fail, although insert
operations succeed and the tables continue to grow.
The point at which memory limits are exceeded varies with the number of nodes in the
machine and the amountof memory on the rmshost node. Tocheck that the size of the
database is within operating limits, enter the following query:
$rmsquery; "select * from node_stats" > /tmp/stats.sql
If this fails, follow these steps to recover from theproblem:
1. Log into the rmshostnode as rootand stop thedatabase server,as follows:
#/sbin/init.d/msqld stop
MSQL: service stopped
9-8 Setting up RMS