> ### OpenEdge tables

> The schema of OpenEdge tables is dependent upon many subsystems. Figure 3–3 shows the schema of AppServer tables.

> Figure 3–3: OpenEdge AppServer table relationships

> Figure 3–4 shows the schema of WebSpeed tables.

> Figure 3–4: OpenEdge WebSpeed table relationships

> If you configure Fathom to monitor WebSpeed and/or AppServer resources, Fathom stores the data in the tables listed in Table 3–8.

> Table 3–8: OpenEdge tables
> Table name | Table contents | Description
> --- | --- | ---
> ActASProc | AppServer Data | Contains information about each procedure executed for the AppServer.
> ActBrk | Broker Data | Contains information about AppServer and WebSpeed broker activity requests.
> ActSrv | Server Data | Contains information about OpenEdge broker server activity.
> ActWSProc | WebSpeed Data | Contains information about each procedure executed for WebSpeed.
> APPService | Application Data | Contains information about application services.

> Table 3–9 details each OpenEdge table including fields, data types, brief descriptions, and how data for each field is handled during data compaction.

> For more information on the filename prefix, see Table 3–1.

> Table 3–9: OpenEdge table details
> Filename | Field name | Data type | Description | Compaction status
> --- | --- | --- | --- | ---
> OE_ActASProc | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> OE_ActASProc | ActBrk_PID | Decimal | Identification number of the broker process. | Save
> OE_ActASProc | ActBrk_UUID | Character | Broker UUID for the broker process. | Save
> OE_ActASProc | ActASProc_Name | Character | Name of the procedure. | Save
> OE_ActASProc | ActASProc_Calls | Decimal | Number of times the procedure has been called. | Sum
> OE_ActASProc | ActASProc_TotTime | Decimal | Cumulative time the procedure has run. | Sum
> OE_ActASProc | ActASProc_MaxTime | Decimal | Longest amount of time that the procedure has run. | Average
> OE_ActASProc | ActASProc_Parent | Character | Name of the parent procedure. | Save
> OE_ActASProc | ActASProc_ProcType | Character | Type of procedure: internal, persistant, or user-defined. | Save
> OE_ActASProc | ActASProc_SuccessCount | Decimal | Number of times the procedure completed with a success condition. | Sum
> OE_ActASProc | ActASProc_ErrorCount | Decimal | Number of times the procedure completed with an error condition. | Sum
> OE_ActASProc | ActASProc_QuitCount | Decimal | Number of times the procedure completed with a quit condition. | Sum
> OE_ActASProc | ActASProc_StopCount | Decimal | Number of times the procedure completed with a stop condition. | Sum
> OE_ActASProc | ActASProc_DebugCount | Decimal | Number of times the procedure completed with a debug condition. | Sum
> OE_ActBrk | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> OE_ActBrk | ActBrk_PID | Decimal | Process identification number of the broker process. | Save
> OE_ActBrk | ActBrk_UUID | Character | UUID of the broker process. | Save
> OE_ActBrk | ActBrk_Name | Character | Name of the broker. | Save
> OE_ActBrk | ActBrk_ReqRec | Decimal | Number of requests received by the broker. | Sum
> OE_ActBrk | ActBrk_ReqComp | Decimal | Number of requests completed by the broker. | Sum
> OE_ActBrk | ActBrk_ReqQueued | Decimal | Number of broker requests queued. | Sum
> OE_ActBrk | ActBrk_ReqRejected | Decimal | Number of requests rejected by the broker. | Sum
> OE_ActBrk | ActBrk_CurrClients | Decimal | Current client count for the broker. | Average
> OE_ActBrk | ActBrk_TotClients | Decimal | Total number of clients that have connected to the broker. | Sum
> OE_ActBrk | ActBrk_CurrServers | Integer | Current number of servers. | Average
> OE_ActBrk | ActBrk_Mode | Character | Mode of the broker and servers: stateless, state-aware, state-reset, or state free. | Save
> OE_ActBrk | ActBrk_CurrQueue | Integer | Current number of queued requests. | Average
> OE_ActSrv | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> OE_ActSrv | ActBrk_PID | Decimal | Process identification number of the broker process. | Save
> OE_ActSrv | ActBrk_UUID | Character | UUID of the broker process. | Save
> OE_ActSrv | ActSrv_PID | Decimal | Process identification number of the server process. | Save
> OE_ActSrv | ActSrv_Status | Character | Current status of the server. | Save
> OE_ActSrv | ActSrv_IdleCount | Decimal | Number of times an agent has become idle. | Sum
> OE_ActSrv | ActSrv_IdleTime | Decimal | Amount of time an agent has spent idle. | Sum
> OE_ActSrv | ActSrv_BusyCount | Decimal | Number of times an agent has had a status of busy. | Sum
> OE_ActSrv | ActSrv_BusyTime | Decimal | Amount of time an agent has had a busy status. | Sum
> OE_ActSrv | ActSrv_LockedCount | Decimal | Number of times an agent has had a status of locked. | Sum
> OE_ActSrv | ActSrv_LockedTime | Decimal | Amount of time an agent has had a status of locked. | Sum
> OE_ActWSProc | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> OE_ActWSProc | ActBrk_PID | Decimal | Process identification number of the broker process. | Save
> OE_ActWSProc | ActBrk_UUID | Character | UUID of the broker process. | Save
> OE_ActWSProc | ActWSProc_Name | Character | Name of the procedure. | Save
> OE_ActWSProc | ActWSProc_Calls | Decimal | Number of times the procedure has been called. | Sum
> OE_ActWSProc | ActWSProc_TotTime | Decimal | Amount of time the process has run. | Sum
> OE_ActWSProc | ActWSProc_MaxTime | Decimal | Longest amount of time the procedure has run. | Average
> OE_ActWSProc | ActWSProc_Parent | Character | Parent procedure. | Save
> OE_ActWSProc | ActWSProc_ProcType | Character | Procedure type: internal, persistent, or user-defined. | Save
> OE_APPService | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> OE_APPService | APPS_ServiceName | Character | Application service name. | Save
> OE_APPService | ActBrk_UUID | Character | UUID of the broker process. | Save

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