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