Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : Archive tables : Complete contents of an archived table
 

Complete contents of an archived table

The following table identifies the table contents of the Ar_ActIdx table (the archived version of the database table ActIdx), which stores index data about overall performance.
Table 18. Contents of the Ar_ActIdx table
Field name
Data type
Description
ActIdx_Create
Decimal
Number of index keys created
ActIdx_Delete
Decimal
Number of index keys deleted
ActIdx_Find
Decimal
Number of index keys requested
ActIdx_Free
Decimal
Number of index blocks placed on the free chain
ActIdx_Remove
Decimal
Number of deleted blocks removed at the end of a transaction
ActIdx_Splits
Decimal
Number of index block splits performed
ActIdx_User1
Character
User-definable field
Sample_ID
Integer
Identification number of the gathered sample
ActIdx_ArchiveType
Character
Identifies the field's archive type:
*H — Hourly
*D — Daily
*W — Weekly
ActIdx_Length
Integer
Number of seconds for the archive to take place
ActIdx_StartDate
Date
Start date for the row (this date will always be the same as the end date for hourly and daily)
ActIdx_StartTime
Integer
Start time for the row
ActIdx_EndDate
Date
End date for the row
ActIdx_EndTime
Integer
End time for the row
ActIdx_Transactions
Integer
Number of transactions committed
ActIdx_RecordCount
Integer
Number of records in this archived file
Resrc_ID
Integer
The Resource ID of the database for this site
Site_ID
Character
The Site_ID for the database