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

rename COGIPF_ACTION to COGIPF_ACTION_OLD

create table COGIPF_ACTION (
	 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 (255),
	 COGIPF_TARGET_TYPE    		varchar (255),
	 COGIPF_TARGET_PATH    		varchar (1024),
	 COGIPF_STATUS         		varchar (255),
	 COGIPF_ERRORDETAILS   		varchar (2000)
)

insert into COGIPF_ACTION select * from COGIPF_ACTION_OLD

drop table COGIPF_ACTION_OLD
