| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- -- 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_AGENTRUN (
- COGIPF_HOST_IPADDR varchar (15),
- COGIPF_HOST_PORT integer,
- COGIPF_PROC_ID integer,
- COGIPF_LOCALTIMESTAMP timestamp,
- COGIPF_TIMEZONE_OFFSET integer,
- COGIPF_SESSIONID varchar (255),
- COGIPF_REQUESTID varchar (255) not null,
- COGIPF_STEPID varchar (255),
- COGIPF_SUBREQUESTID varchar (255),
- COGIPF_THREADID varchar (255),
- 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_STATUS varchar (255),
- COGIPF_ERRORDETAILS varchar (2000),
- COGIPF_AGENT_PATH varchar (1024),
- COGIPF_SCHEDULETIME integer,
- COGIPF_USER varchar (512),
- COGIPF_EMAIL varchar (512)
- )
- create table COGIPF_AGENTBUILD (
- COGIPF_HOST_IPADDR varchar (15),
- COGIPF_HOST_PORT integer,
- COGIPF_PROC_ID integer,
- COGIPF_LOCALTIMESTAMP timestamp,
- COGIPF_TIMEZONE_OFFSET integer,
- COGIPF_SESSIONID varchar (255),
- COGIPF_REQUESTID varchar (255) not null,
- COGIPF_STEPID varchar (255),
- COGIPF_SUBREQUESTID varchar (255),
- COGIPF_THREADID varchar (255),
- 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_STATUS varchar (255),
- COGIPF_ERRORDETAILS varchar (2000),
- COGIPF_AGENT_PATH varchar (1024),
- COGIPF_SCHEDULETIME integer,
- COGIPF_USER varchar (512),
- COGIPF_EMAIL varchar (512)
- )
|
