analytics/configuration/schemas/content/db2zOS/dbUpgrade6_0006-to-6_0007_db2zOS.sql

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

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
alter table CMOBJPROPS67 add column COLLABDISCURI clob(4000);

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
CREATE AUXILIARY TABLE CMATB105
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML105
   STORES CMOBJPROPS67
   COLUMN COLLABDISCURI;
   
--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
CREATE  UNIQUE  INDEX CMIDX105 ON CMATB105 USING STOGROUP CMSCRIPT_STOGROUP;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
alter table CMOBJPROPS67 add column BRSMAXATTACHSIZE integer;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
alter table CMOBJPROPS67 add column DSMAXATTACHSIZE integer;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
alter table CMOBJPROPS67 add column RSMAXATTACHSIZE integer;

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
!RunCMScript CMUpgradeScript_capabilities_47.xml

--CMSCRIPT_UPGRADE_SKIP_COMMAND(6.000501,6.0006)
!RunCMScript CMUpgradeScript_configuration_update_32.xml