Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : Table and field name definitions
 

Table and field name definitions

The naming of tables and fields in the OpenEdge Management database follows certain conventions. Each table and field name consists of a prefix and a suffix, separated by an underscore. The prefix indicates which resource the table or field is related to. The suffix indicates the name of the data and might contain a subsection. The suffix cannot be more than 15 characters long. The following table describes each prefix.
Table 2. Table prefix definitions
Prefix
Table or field contents
Description
Cf_
Configuration data
Tables or fields that store configuration information for such OpenEdge Management functions as schedules, resource identification, and alert definitions. See Configuration tables for more information.
Sys_
System data
Tables or fields that store raw data collected from samplings of such resources as CPU, disk, and memory. See System tables for more information.
Db_
Database data
Tables or fields that store data gathered from OpenEdge® databases. Sample data includes I/O, user statistics, and memory management. See Compaction details for configuration tables and Database analysis tables for more information.
OE_
OpenEdge Server data
Tables or fields that store data gathered from WebSpeed® and AppServer.
Note: OpenEdge Management supports management of the WebSpeed® Transaction Server product. Throughout this guide, WebSpeed Transaction Server and WebSpeed are used interchangeably.
Ar_
Archive data
Tables or fields that store data gathered from OpenEdge databases for archiving purposes. Sample data includes all fields and data associated with a given table and archive-specific fields. Data stored in system and database tables can be archived; data stored in configuration tables cannot be archived. See the Archive tables for more information.
Net_
Network data
Table or fields that store data gathered from TCP, UDP, ICMP, or HTTP resources.