rmstbladm(1)
DESCRIPTION
The command rmstbladm is used to administer the RMS database. It creates the tables
and their default entries. It can be used to back up individual tables (or the whole
database) to a text file, to restore tables from file or to force the recreation of tables.
Unless a specific machine is specified, rmstbladm operates on the database of the host
machine.
When installing or upgrading a system, rmstbladm is used to check the consistency of
the database, to changethe structure of the tables and to add default entries. Once the
system is installed and working correctly, the database should be backed up using
rmstbladm with the -d option. The backup should be kept safely so that the database
can be restored later should this prove necessary.
Certain tables in the RMS database (the resources,jobs,events,acctstats and
node_stats tables in particular) grow over time and as each job is run. Toremove old
entries from the database, use rmstbladm with the -c option. Note that this does not
remove entries from the accounting statistics table. Theseshould beremoved once the
accounting data has been processed. (See Section 9.4.5).
Access to rmstbladm options that update the database is restricted to administrative
users.
EXAMPLES
Tobackup the contents of the RMS database or a selected table to a text file as a
sequence of SQL statements:
$rmstbladm -d > backup_full.sql
$rmstbladm -d -t nodes > backup_nodes.sql
Toupdate the database oninstalling anew version of RMS:
$rmstbladm -u
RMS Commands 5-45