analytics/configuration/schemas/content/db2/dbUpgrade5_0012-to-5_0013_db2.sql

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

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).

CREATE TABLE CMOBJPROPS79 (
	CMID         	integer not null,
	PUBLISHED	decimal(1,0),
	SPEC		clob(1M),
	CONSTRAINT PK_CMOBJPROPS79 PRIMARY KEY (CMID)
)

insert into CMOBJPROPS79 (CMID) select CMID from CMOBJECTS where CLASSID = 142

!RunCMScript CMUpgradeScript_capabilities_41.xml

alter table CMOBJPROPS31 add column QSAUDITLVL smallint

alter table CMOBJPROPS48 add column QSDIAGENABLED decimal(1,0)

alter table CMOBJPROPS48 add column QSMETENABLED decimal(1,0)

alter table CMOBJPROPS48 add column QSQUERYEXECTR decimal(1,0)

alter table CMOBJPROPS48 add column QSPLANTRC decimal(1,0)

!RunCMScript CMUpgradeScript_configuration_update_26.xml