The schema of OpenEdge tables is dependent upon many subsystems. The following table shows the schema of AppServer tables.

Figure 1. OpenEdge AppServer table relationships


The following table shows the schema of WebSpeed tables.

Figure 2. OpenEdge WebSpeed table relationships


If you configure OpenEdge Management to monitor WebSpeed and/or AppServer resources, OpenEdge Management stores the data in the tables listed in the following table.

Table 1. 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

The following table describes each OpenEdge table including fields, data types, brief descriptions, and how data for each field is handled during data compaction. For more information about the filename prefix, see the Table prefix definitions table.

Table 2. 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, persistent, 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