analytics/configuration/schemas/logging/db2/LS_dbUpgrade0_004-to-0_005_db2.sql

-- 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_EDITQUERY to COGIPF_EDITQUERY_OLD

create table  COGIPF_EDITQUERY (
	 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_TARGET_TYPE    		varchar (255),
	 COGIPF_QUERYPATH     		varchar (1024),
	 COGIPF_STATUS         		varchar (255),
	 COGIPF_ERRORDETAILS   		varchar (2000),
	 COGIPF_RUNTIME        		integer,
	 COGIPF_QUERYNAME     		varchar (512),
	 COGIPF_PACKAGE        		varchar (1024),
	 COGIPF_MODEL  			varchar (512)
)

insert into COGIPF_EDITQUERY select * from COGIPF_EDITQUERY_OLD

drop table COGIPF_EDITQUERY_OLD

rename COGIPF_RUNREPORT to COGIPF_RUNREPORT_OLD

create table  COGIPF_RUNREPORT (
	 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_TARGET_TYPE    		varchar (255),
	 COGIPF_REPORTPATH     		varchar (1024),
	 COGIPF_STATUS         		varchar (255),
	 COGIPF_ERRORDETAILS   		varchar (2000),
	 COGIPF_RUNTIME        		integer,
	 COGIPF_REPORTNAME     		varchar (512),
	 COGIPF_PACKAGE        		varchar (1024),
	 COGIPF_MODEL  			varchar (512)
)

insert into COGIPF_RUNREPORT select * from COGIPF_RUNREPORT_OLD

drop table COGIPF_RUNREPORT_OLD

rename COGIPF_VIEWREPORT to COGIPF_VIEWREPORT_OLD

create table  COGIPF_VIEWREPORT (
	 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_TARGET_TYPE    		varchar (255),
	 COGIPF_REPORTPATH     		varchar (1024),
	 COGIPF_STATUS         		varchar (255),
	 COGIPF_ERRORDETAILS   		varchar (2000),
	 COGIPF_REPORTNAME     		varchar (512),
	 COGIPF_PACKAGE        		varchar (1024),
	 COGIPF_MODEL  			varchar (512),
	 COGIPF_REPORTFORMAT   		varchar (255)
)

insert into COGIPF_VIEWREPORT select * from COGIPF_VIEWREPORT_OLD

drop table COGIPF_VIEWREPORT_OLD