Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Archiver Execution Status Database Items 3-148
Archiver Execution Status Database Items 3
Overview 3
The Archiver Execution Status database item descriptions apply
specifically to items in the
arch_stat
table. The table contains status
information on recent archiver executions, and displays status and the
next run scheduled. The indexes are ACD and ARCH_TYPE. Because
the data contained in the
arch_stat
table are administrative, the table
is not dependent on ECS releases.
Archiver
Execution Status
Database Items
3
The following table describes the data items in the CMS Archiver
Execution Status database table.
Database Item Description
Data
Type
Column
Type
Length
ACD (index) The ACD number for which data
was collected.
A smallint 2 bytes
ARCH_TYPE
(index)
The type of archiver executions
being run.
Values are: 1 = interval, 2 = daily,
3 = weekly, 4 = monthly.
A char(20) 20 byte
ASCII text
string
LAST_TIME The last time the archiver
execution was run.
A char(20) 20 byte
ASCII text
string