Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
PMMD_Idnr int NUMBER(38,0) int int false Identification of metrics definition
PMMD_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Metrics name
PMMD_Active smallint NUMBER(38,0) smallint smallint true 0: inactive, 1: active, when feature activated, 2: always active
PMMD_Interval int NUMBER(38,0) int int false Interval metrics has to be measured in minutes
PMMD_ValuesDesc varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Metrics value description
PMMD_CompressType smallint NUMBER(38,0) smallint smallint true Type of compressing. 1: sum, 2: avg
PMMD_Overall smallint NUMBER(38,0) smallint smallint true 1: overall metric, 0: specific worker process metric

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_PMMD PMMD_Idnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File