CodeMatrix is designed to run completely unattended.
However from time to time you may need to see what is
going on internally. For example if someone issues a long
running command that locks a significant part of the
database you may wish to identify this fact and possible
stop the transaction and schedule at a more appropriate
time. CodeMatrix has an efficient database design and
locking strategy so this should rarely be the case.
CodeMatrix offers the following command line commands for
the administration of transactions.
transactions gives a list of all active transactions
at the server, the id of any transactions that are being
waited on and details of the client.
locks gives
the same information as
transactions, plus a list of locks held.
kill allows
an administrator to terminate a running transaction.
sessions
gives a list of active sessions.
|