analytics/configuration/schemas/logging/db2zOS/LS_dbUpgrade102_002-to-102_003_db2zOS.sql

-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2013, 2014
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

alter table COGIPF_PARAMETER add COGIPF_LOCALTIMESTAMP timestamp with default NULL;

alter table COGIPF_PARAMETER add COGIPF_SESSIONID varchar (255) default '';

alter table COGIPF_PARAMETER add COGIPF_SUBREQUESTID varchar (255) default '';

alter table COGIPF_PARAMETER add COGIPF_PARAMETER_VALUE_BLOB clob(1G) with default NULL;

CREATE AUXILIARY TABLE IPFAUXTB06
   IN IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL07
   STORES COGIPF_PARAMETER
   COLUMN COGIPF_PARAMETER_VALUE_BLOB;
 
CREATE  UNIQUE  INDEX IPFAUXIX06 ON IPFAUXTB06 USING STOGROUP IPFSCRIPT_STOGROUP;