analytics/configuration/schemas/content/db2zOS/dbUpgrade6_0016-to-6_0017_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.

alter table CMOBJPROPS67 add column QSADDJVMARG	varchar (2048)

alter table CMOBJPROPS67 add column QSINITJVMHEAP	integer

alter table CMOBJPROPS67 add column QSMANCUBESTRT	decimal(1, 0)

alter table CMOBJPROPS67 add column QSMAXJVMHEAP	integer

alter table CMOBJPROPS67 add column QSROLAPCUBECONF	blob(1M)

alter table CMOBJPROPS67 add column	QSROLAPCADMINCT	integer

CREATE AUXILIARY TABLE CMATB108
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML108
   STORES CMOBJPROPS67
   COLUMN QSROLAPCUBECONF
   
CREATE  UNIQUE  INDEX CMIDX108 ON CMATB108 USING STOGROUP CMSCRIPT_STOGROUP

!RunCMScript CMUpgradeScript_configuration_update_35.xml