Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : OpenEdge tables
 

OpenEdge tables

The schema of OpenEdge tables is dependent upon many subsystems. The following table shows the schema of AppServer tables.
Figure 3. OpenEdge AppServer table relationships
The following table shows the schema of WebSpeed tables.
Figure 4. 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 9. 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 10. 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