analytics/configuration/schemas/content/db2zOS/dbUpgrade7_6003-to-7_6004_db2zOS.sql

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

ALTER TABLE CMOBJPROPS85 ADD column BIVARS clob(50M);

CREATE AUXILIARY TABLE CMATB142
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML142
   STORES CMOBJPROPS85
   COLUMN BIVARS;

CREATE UNIQUE INDEX CMIDX142 ON CMATB142 USING STOGROUP CMSCRIPT_STOGROUP;

ALTER TABLE CMOBJPROPS85 ADD column EMBEDDING clob(50M);

CREATE AUXILIARY TABLE CMATB143
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML143
   STORES CMOBJPROPS85
   COLUMN EMBEDDING;

CREATE UNIQUE INDEX CMIDX143 ON CMATB143 USING STOGROUP CMSCRIPT_STOGROUP;

ALTER TABLE CMOBJPROPS85 ADD column STATUS clob(50M);

CREATE AUXILIARY TABLE CMATB144
   IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML144
   STORES CMOBJPROPS85
   COLUMN STATUS;

CREATE UNIQUE INDEX CMIDX144 ON CMATB144 USING STOGROUP CMSCRIPT_STOGROUP;