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