Filter
Top Products
6-16 SECTION 6: SYSTEM ADMINISTRATION
ALARM TRANSACTION CLEAN UP [alrmcln]
Each time an alarm is triggered, a record is created and stored in a separate file along with the
operator's alarm servicing response. This table is then available for reporting using the alarm
servicing report. Over time, the size of this table grows and takes up excessive space on the hard
disk. Cleanup this table when the PUBLIC.alrmtran table reaches 80% of the expected number
of rows. Monitor this table using Display Database Statistics [dbstats].
JOURNAL ARCHIVE [jourarch]
This function copies journal records to tape and then deletes them from the hard disk. The journal
archive program archives all journal information except for the current day. Archiving is performed
using the [jourarch] screen:
JOURNAL REPORTING [jourrprt]
This function reports all changes to the database. The report prints the column name and value
for each field of each record that has been entered. With updates, the report shows the record
before and after the change. Associated operator, and date and time are also reported. A sample
report follows:
04/02/96 De Quincy Laboratories Page 1
12:14 Audit Trail Report
Operator Table Date Time Operation Type
________________ ____________ ________ _____ __________________
jon cards 04/02/96 12:07 Add
upbzone: -1
ppbzone: -1
keyisalt: NULL
priv: N
SPECIAL JOURNAL REPORTING [josprprt]
This function produces a formatted history report of all database changes to the keyholders and
keyholder access assignment Information. Sample screens and reports follow: