These are the programs which the database maintainer can use to manage
the database. The database owner should also read the section on
tsql to manage users. The index maintainer program
chkind is one way to keep the Metamorph indexes on a table up
to date. If the data changes sporadically thru the day you can use
this to maintain an up to date index. If you tend to have batch
changes in the data it is usually best to force an update of the index
at the end of the batch.
ltest allows you to monitor the state of the locks on the
database. It can help show if one process is holding locks for a long
period of time, or if there is a great deal of lock contention. If
you are seeing considerable lock contention you should consider either
re-structuring the application, reduce other loads on the machine, or
acquire a more powerful machine.
rmlocks is used in the cases where programs have quit without
cleaning up locks, or a deadlock situation has occurred. Texis can resolve
most of these situations by itself, although sometimes using
can be required.
rmlocks will not remove any locks currently in use
so it is safe to run at any time.
kdbfchk checks and repairs database files. It can be used to
verify the integrity of tables and recover from some file corruption
timport is a general purpose data importer. A synopsis of how to
use it is given here, and a more complete explanation of the schema format
and usage is given in Chapter here.