COGIPF_THRESHOLD_VIOLATIONS Table

Stores information about threshold violations for system metrics.

For more information, see System Performance Metrics.

Table 1. COGIPF_THRESHOLD_VIOLATIONS table columns, descriptions, and data types

Column name

Description

Data type

COGIPF_HOST_IPADDR

The host IP address where the log message is generated

VARCHAR (128)

COGIPF_HOST_PORT

The host port number

INTEGER

COGIPF_PROC_ID

The process ID assigned by the operating system

INTEGER

COGIPF_LOCALTIMESTAMP

The local date and time when the log message was generated

TIMESTAMP

COGIPF_TIMEZONE OFFSET

The time zone, offset from GMT

INTEGER

COGIPF_COMPONENTID

The alphanumeric identification of the component

VARCHAR (64)

COGIPF_BUILDNUMBER

The alphanumeric identification of the build

INTEGER

COGIPF_LOG_LEVEL

The logging level. Should always be 1 to ensure that threshold violation information is available.

INTEGER

COGIPF_OPERATION

A threshold for the metric has been crossed

VARCHAR (128)

COGIPF_TARGET_TYPE

The target type

VARCHAR (255)

COGIPF_TARGETNAME

The target name

VARCHAR (512)

COGIPF_TARGET_PATH

The target path of the dispatcher that conatins the threshold manager

VARCHAR (1024)

COGIPF_RESOURCE_TYPE

The resource type that exceeds the threshold

VARCHAR (128)

COGIPF_RESOURCE_PATH

The path of the resource that exceeded the threshold value

VARCHAR (512)

COGIPF_METRIC_NAME

The name of the metric

VARCHAR (255)

COGIPF_METRIC_VALUE

The value of the metric

VARCHAR (128)

COGIPF_METRIC_HEALTH

The status of the metric: good, average, or poor

VARCHAR (128)

COGIPF_LOWER_AVG_THRSHLD

The lower average threshold setting.

If COGIPF_LOWER_AVG_THRSHLD_XCL is 1, the metric score is average when the metric is less than this threshold setting. The metric score is good when the metric is greater than or equal than this value.

If COGIPF_LOWER_AVG_THRSHLD_XCL is 0 (zero), the metric score is average when the metric is less than or equal to this value. The metric score is good when the metric is greater than this value.

VARCHAR (128)

COGIPF_LOWER_AVG_THRSHLD_EXCL

The flag that indicates if the threshold setting in COGIPF_LOWER_AVG_THRSHLD is included when determining the metric score.

If it is 0, the threshold setting is included when the metric score is determined. If it is 1, the threshold setting is not included when the metric score is determined.

DECIMAL (1,0)

COGIPF_LOWER_POOR_THRSHLD

The lower poor threshold setting.

If COGIPF_LOWER_POOR_THRSHLD_XCL is 1, the metric score is poor when the metric is less than this threshold setting.

If COGIPF_LOWER_POOR_THRSHLD_XCL is 0 (zero), the metric score is poor when the metric is less than or equal to this value.

VARCHAR (128)

COGIPF_LOWER_POOR_THRSHLD_EXCL

The flag that indicates if the threshold setting in COGIPF_LOWER_POOR_THRSHLD is included when determining the metric score.

If it is 0, the threshold setting is included when the metric score is determined. If it is 1, the threshold setting is not included when the metric score is determined.

DECIMAL (1,0)

COGIPF_UPPER_AVG_THRSHLD

The upper average threshold setting

If COGIPF_UPPER_AVG_THRSHLD_XCL is 1, the metric score is poor when the metric is less than this threshold setting.

If COGIPF_UPPER_AVG_THRSHLD_XCL is 0 (zero), the metric score is average when the metric is greater than or equal to this value. The metric score is good when the metric is less than or equal to this value.

VARCHAR (128)

COGIPF_UPPER_AVG_THRSHLD_EXCL

The flag that indicates if the threshold setting in COGIPF_UPPER_AVG_THRSHLD is included when determining the metric score.

If it is 0, the threshold setting is included when the metric score is determined. If it is 1, the threshold setting is not included when the metric score is determined.

DECIMAL (1,0)

COGIPF_UPPER_POOR_THRSHLD

The upper poor threshold setting.

If COGIPF_UPPER_POOR_THRSHLD_XCL is 1, the metric score is poor when the metric is less than this threshold setting.

If COGIPF_UPPER_POOR_THRSHLD_XCL is 0 (zero), the metric score is poor when the metric is greater than or equal to this value.

VARCHAR (128)

COGIPF_UPPER_POOR_THRSHLD_EXCL

The flag that indicates if the threshold setting in COGIPF_UPPER_POOR_THRSHLD is included when determining the metric score.

If it is 0, the threshold setting is included when the metric score is determined. If it is 1, the threshold setting is not included when the metric score is determined.

DECIMAL (1,0)