-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2010
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

CREATE TABLE COGIPF_THRESHOLD_VIOLATIONS (
	COGIPF_HOST_IPADDR    			varchar (15) NULL,
	COGIPF_HOST_PORT      			int NULL,
	COGIPF_PROC_ID        			int NULL,
	COGIPF_LOCALTIMESTAMP         		datetime NULL,
	COGIPF_TIMEZONE_OFFSET        		int NULL,
	COGIPF_COMPONENTID    			varchar (64) NULL,
	COGIPF_BUILDNUMBER    			int NULL,
	COGIPF_LOG_LEVEL  			int NULL,
	COGIPF_OPERATION			varchar (128) NULL,
	COGIPF_TARGET_TYPE    			varchar (255) NULL,
	COGIPF_TARGET_PATH     			nvarchar (1024) NULL,
	COGIPF_TARGET_NAME     			nvarchar (512) NULL,
	COGIPF_RESOURCE_TYPE 			varchar	(128) NULL,
	COGIPF_RESOURCE_PATH			nvarchar (512) NULL,
	COGIPF_METRIC_NAME			varchar	(255) NULL,
	COGIPF_METRIC_VALUE			varchar	(128) NULL,
	COGIPF_METRIC_HEALTH			varchar	(128) NULL,
	COGIPF_LOWER_AVG_THRSHLD		varchar	(128) NULL,
	COGIPF_LOWER_AVG_THRSHLD_EXCL		bit NULL,
	COGIPF_LOWER_POOR_THRSHLD		varchar	(128) NULL,
	COGIPF_LOWER_POOR_THRSHLD_EXCL		bit NULL,
	COGIPF_UPPER_AVG_THRSHLD		varchar	(128) NULL,
	COGIPF_UPPER_AVG_THRSHLD_EXCL		bit NULL,
	COGIPF_UPPER_POOR_THRSHLD		varchar	(128) NULL,
	COGIPF_UPPER_POOR_THRSHLD_EXCL		bit	NULL
)