analytics/configuration/schemas/logging/db2/LS_dbUpgrade0_016-to-0_017_db2.sql

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

ALTER TABLE COGIPF_ACTION ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_ACTION')

ALTER TABLE COGIPF_USERLOGON ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_USERLOGON')

ALTER TABLE COGIPF_NATIVEQUERY ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_NATIVEQUERY')

ALTER TABLE COGIPF_RUNJOB ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_RUNJOB')

ALTER TABLE COGIPF_RUNJOBSTEP ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_RUNJOBSTEP')

ALTER TABLE COGIPF_RUNREPORT ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_RUNREPORT')

ALTER TABLE COGIPF_EDITQUERY ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_EDITQUERY')

ALTER TABLE COGIPF_VIEWREPORT ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_VIEWREPORT')

ALTER TABLE COGIPF_AGENTRUN ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_AGENTRUN')

ALTER TABLE COGIPF_AGENTBUILD ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_AGENTBUILD')

ALTER TABLE COGIPF_MIGRATION ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_MIGRATION')

ALTER TABLE COGIPF_THRESHOLD_VIOLATIONS ALTER COLUMN COGIPF_HOST_IPADDR SET DATA TYPE varchar(128)

Call Sysproc.admin_cmd('REORG table COGIPF_THRESHOLD_VIOLATIONS')