analytics/configuration/schemas/content/db2zOS/dbUpgrade7_0003-to-7_0004_db2zOS.sql

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

ALTER TABLE CMOBJPROPS31 ADD column IDVIZAUDITLVL smallint

ALTER TABLE CMOBJPROPS31 ADD column REPOSAUDITLVL smallint

ALTER TABLE CMOBJPROPS31 ADD column SACAMAUDITLVL smallint

INSERT INTO CMOBJPROPS31(CMID) select CMID from CMOBJECTS WHERE CLASSID in (240)

ALTER TABLE CMOBJPROPS48 ADD column RMDSCONS  integer

ALTER TABLE CMOBJPROPS48 ADD column RMDSPEAKCONS integer

ALTER TABLE CMOBJPROPS48 ADD column QSVERBGCLOGLIMIT integer

ALTER TABLE CMOBJPROPS48 ADD column QSMDQUERYSIZELIMIT integer

ALTER TABLE CMOBJPROPS48 ADD column QSGENCOMINNATSQL decimal(1, 0)

ALTER TABLE CMOBJPROPS48 ADD column QSDISVERBGCLOG decimal(1, 0)

ALTER TABLE CMOBJPROPS48 ADD column QSINITNURSESIZE integer

ALTER TABLE CMOBJPROPS48 ADD column QSNURSESIZELIMIT integer

ALTER TABLE CMOBJPROPS48 ADD column QSGCPOLICY smallint

ALTER TABLE CMOBJPROPS23 ADD column QSRMEMCACHEROOT varchar(255)

INSERT INTO CMOBJPROPS23(CMID) select CMID from CMOBJECTS where CLASSID=227

DELETE FROM CMREFNOORD1 where PROPID=54

!RunCMScript CMUpgradeScript_configuration_update_38.xml