Archive Catalog table

archId

IDType

This field is the Archive table identifier.

dbName

sysnameType

This field is the name of the database that the tableName belongs to.

tableName

sysnameType

This field is the name of the table that has had its data archived and logged to the catalog table.

archLabel

labelType

This field is the label of the media for this archive.

archDevice

devnameType

This field is the name of the Archive device.

archFile

filenameType

This field is the name of the archived data file.

archTime

GMTtime

This field shows the time that the Archive was created (Greenwich Mean Time [GMT]).

archOffset

GMToffset

This field shows the local time zone that was in effect when archTime was created.

startTime

GMTtime

This field is the start time of the data archive.

endTime

GMTtime

This field is the end time of the data archive.

dataOffset

GMToffset

This field shows the offset for the startTime and endTime.

verNum

IDType

This field is the version number of the Archive. The version number is assigned to the Archive file name (archFile), which is composed of <system ><server> <db> <table> <dd><Mmm> <YYYY>.archive_<VersionNumber>. Version number starts at 0 and increments for each rearchive occurrence for the table's data within the same time frame.

currentVer

boolType

This field indicates whether the Archive is the most current version.

schemaVer

IDType

This field specifies the schema version used to archive the data.