| 1234567891011121314151617181920212223242526272829303132 |
- -- 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
- )
|
