-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2013
-- 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

Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')

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

Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')

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

Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')

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

Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')