Complete contents of an archived table

Table 3–17 identifies the table contents of the Ar_ActIdx (the archived version of the database table ActIdx), which stores index data about overall performance.

Table 3–17: 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 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.


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