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