analytics/configuration/schemas/content/db2/dbUpgrade4_0109-to-4_0111_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).


alter table CMOBJPROPS31 add column MDSAFFINECONNECTIONS integer

alter table CMOBJPROPS31 add column MDSNONAFFINECONNCTS integer

alter table CMOBJPROPS31 add column MDSPEAKCONS integer

alter table CMOBJPROPS31 add column MDSPEAKNONAFFINECONNCTS integer

alter table CMOBJPROPS31 add column MDSPEAKMAXPROCS integer

alter table CMOBJPROPS31 add column MDSMAXPROCESSES integer

alter table CMOBJPROPS31 add column MDSEXECUTIONTIMELIMIT integer

alter table CMOBJPROPS31 add column MDSQUEUELIMIT integer

alter table CMOBJPROPS31 add column MDINFOURI clob(4000)

!RunCMScript CMUpgradeScript_capabilities_37.xml

!RunCMScript CMUpgradeScript_configuration_update_19.xml