analytics/configuration/schemas/content/db2/dbUpgrade7_0028-to-7_0029_db2.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2015
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

alter table CMOBJECTS alter column CLASSID set data type integer

Call Sysproc.admin_cmd('reorg Table CMOBJECTS')


alter table CMCLASSES alter column CLASSID set data type integer

Call Sysproc.admin_cmd('reorg Table CMCLASSES')


alter table CMOBJPROPS25 alter column DEPLOYOBJCLASSID set data type integer

Call Sysproc.admin_cmd('reorg Table CMOBJPROPS25')


alter table CMSIZEINFO alter column CLASSID set data type integer

alter table CMSIZEINFO alter column TOTALFORCLASSID set data type integer

Call Sysproc.admin_cmd('reorg Table CMSIZEINFO')