Name Type MSSql Type Oracle Type DB2 Nullable Description
PMMD_Idnr int NUMBER(38,0) int false Identification of metrics definition
PMMD_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) false Metrics name
PMMD_Active smallint NUMBER(38,0) smallint true Metric active/inactive
PMMD_Interval int NUMBER(38,0) int false Interval metrics has to be measured in minutes
PMMD_ValuesDesc varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) true Metrics value description
PMMD_CompressType smallint NUMBER(38,0) smallint true Type of compressing. 1: sum, 2: avg
PMMD_Overall smallint NUMBER(38,0) 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