Compaq SC RMS Server User Manual


 
rmstbladm(1)
NAME
rmstbladm – Database administration
SYNOPSIS
rmstbladm [-BcdDfhmuv] [-r file] [-t table] [machine]
OPTIONS
-B Dump the first five rows of each table to stdout as a sequence of SQL
statements. A specific table can be dumped if the -t option is used.
-c Clean out old entries from the node statistics (node_stats) table, the
resources table, the events table and the jobs table. (See
Chapter 10 (The RMS Database). rmstbladm uses the
data-lifetime and stats-lifetime attributes, specified in the
attributes table, to determine how many entries are to be removed.
The default is to keep statistics for 24 hours and job descriptions for
48 hours.
-d Dump the contents of the database to stdout as a sequence of SQL
statements. A specific table can be dumped if the -t option is used.
-D Dump the contents of the database to stdout as plain text. A specific
table can be dumped if the -t option is used.
-f Recreate the database from scratch. A specific table can be recreated
if the -t option is used.
-h Displays the list of options.
-m Displays the names of machines in the RMS databases managed by
the msqld server.
-u By default, rmstbladm checks the consistency of the database. If the
-u flag is specified, the database is updated to the current revision
level. A specific table can be updated if the -t option is used.
-v Specifies verbose operation.
-r file Restore database tables from the named file.
-t table Specifies a single table to be worked on.
5-44 RMS Commands