> ### Archive tables

> You can archive data associated with database, OpenEdge, and system tables. You cannot archive data stored in configuration tables.

> This section identifies:

> - The database, OpenEdge, and system tables for which you can archive data. Table 3–13 identifies the database tables that you can archive, Table 3–14 identifies the system tables that you can archive, and Table 3–15 identifies the OpenEdge tables that you can archive.
> - Common archive-related fields that are generated for each table you archive.
> - An example of archive data generated for an archived table.

> Table 3–13 identifies and briefly describes each FathomTrendDatabase table that you can archive.

> Table 3–13: Archive FathomTrendDatabase tables
> Table name | Table contents | Description
> --- | --- | ---
> Ar_ActAPW | Information from the _ActAPW VST. | Archives APW activity data, such as the number of buffer reads and writes.
> Ar_ActBuf | Information from the _ActBuffer VST. | Archives buffer activity data, such as the number of marked and flushed buffers.
> Ar_ActIdx | Information from the _Index and _ActIndex VSTs. | Archives index data about overall performance.
> Ar_ActIOFile | Information from the _ActIOFile VST. | Archives I/O data about each database file, except for the `.lk` and `.lg` files.
> Ar_ActIOType | Information from the _ActIOType VST. | Archives database I/O data, such as the number of BI and AI blocks read.
> Ar_ActLock | Information from the _ActLock and _LockReq VSTs. | Archives lock activity data, such as the number of requests and the number of database locks.
> Ar_ActLog | Information from the _ActAILog and _ActBILog VSTs. | Archives activity data about before- and after-imaging.
> Ar_ActRec | Information from the _ActRecord and _ActSummary VSTs. | Archives performance data about record reads, writes, and updates.
> Ar_ActServ | Information from the _ActServer and _Server VSTs. | Archives server process data, such as bytes and records sent and received and the number of users.
> Ar_AreaStatus | Information from the _AreaStatus VST. | Archives data about each area's HWM, Free Chain, and RM Chain.
> Ar_ActSum | Information from the _ActSummary VST. | Archives database activity data, such as the number of records created and deleted.
> Ar_Checkpoint | Information from the _Checkpoint VST. | Archives data about checkpoint operations.
> Ar_IndexStat | Information from the _IndexStat and _Index VSTs. | Archives individual index data about reads and writes.

> Table 3–14 identifies and briefly describes each system table that you can archive.

> Table 3–14: Archive system tables
> Table name | Table contents | Description
> --- | --- | ---
> Ar_CPU | CPU data | Archives CPU data for the host system.
> Ar_Mem | Memory data | Archives Memory data for the host system.
> Ar_Dev | Disk Device data | Archives Disk Device data for the host system. The disk device is typically a local drive, but can also be an NFS-type drive.
> Ar_FileSys | File System data | Archives File System data for the host system.
> Ar_FileSize | File Size data | Archives File Size data for monitored files.

> Table 3–15 identifies and briefly describes each OpenEdge table that you can archive.

> Table 3–15: Archive OpenEdge tables
> Table name | Table contents | Description
> --- | --- | ---
> Ar_OE_ActASProc | AppServer data | Archives information about each procedure executed for the AppServer.
> Ar_OE_ActBrk | Broker data | Archives information about AppServer and WebSpeed broker activity requests.
> Ar_OE_ActServ | Server data | Archives information about AppServer and WebSpeed server and agent activity.
> Ar_OE_ActWSProc | WebSpeed data | Archives information about each procedure executed for WebSpeed.
> Ar_OE_AppService | Application data | Archives information about application services.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095