3.3

4 Database Management
54
This searches the log file for the word failed. If there are no errors involving queue
corruption, such as <queue> scan failed , <queue> read error, or unable to open
<queue>, the prompt will simply be returned. If there are any error messages related to
queue corruption, call Avid for assistance.
If you want to review the entire log, you can use the doc command to place a copy in a
queue you specify. For instance, replacing the previous example, the sequence of
commands (shown in bold) may appear similar to the following:
n
You must use 24-hour military time.
NRCS-A# at 11:10
/exc/dblines . |/exc/doc-ptu people.sysadmin.notes
<Ctrl+D>
job 1001340600.a at Sat Jul 10 11:10:00 2010
NRCS-A#
In the example, the system would execute the dblines command at 11:10, and then place
the output in PEOPLE.SYSADMIN.NOTES. As indicated by the pound sign (#) in the
prompt, you must be in superuser mode to execute the commands.
Cleaning the Database
Over the course of a month, the iNEWS database may develop minor errors in its
structure—the overall organization in which individual stories are arranged. These errors are
the result of normal database cycles in which old material is removed and new information is
added.
These errors grow and begin to damage the database if you do not remove them. The
database cleanup procedure identifies errors so you can repair them before they become
harmful.
n
Unless you are instructed to perform this procedure more often, do a database cleanup once
a month.
Cleaning Your Database Offline
The database cleanup procedure using the dbvisit command requires you to briefly take your
system offline, preventing users from logging in.
The day before performing the monthly database cleanup offline, do the following:
1. Select the master computer (typically server A).
2. Type
dbserver 16000000 to empty the Dead queue.