-- 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),
	COGIPF_HOST_PORT      			integer,
	COGIPF_PROC_ID        			integer,
	COGIPF_LOCALTIMESTAMP         		timestamp,
	COGIPF_TIMEZONE_OFFSET        		integer,
	COGIPF_COMPONENTID    			varchar (64),
	COGIPF_BUILDNUMBER    			integer,
	COGIPF_LOG_LEVEL  			integer,
	COGIPF_OPERATION			varchar (128),
	COGIPF_TARGET_TYPE    			varchar (255),
	COGIPF_TARGET_PATH     			varchar (1024),
	COGIPF_TARGET_NAME     			varchar (512),
	COGIPF_RESOURCE_TYPE 			varchar	(128),
	COGIPF_RESOURCE_PATH			varchar	(512),
	COGIPF_METRIC_NAME			varchar	(255),
	COGIPF_METRIC_VALUE			varchar	(128),
	COGIPF_METRIC_HEALTH			varchar	(128),
	COGIPF_LOWER_AVG_THRSHLD		varchar	(128),
	COGIPF_LOWER_AVG_THRSHLD_EXCL		decimal(1,0),	
	COGIPF_LOWER_POOR_THRSHLD		varchar	(128),
	COGIPF_LOWER_POOR_THRSHLD_EXCL		decimal(1,0),	
	COGIPF_UPPER_AVG_THRSHLD		varchar	(128),
	COGIPF_UPPER_AVG_THRSHLD_EXCL		decimal(1,0),	
	COGIPF_UPPER_POOR_THRSHLD		varchar	(128),
	COGIPF_UPPER_POOR_THRSHLD_EXCL		decimal(1,0)	
)