analytics/configuration/schemas/content/db2/dbUpgrade4_0051-to-4_0052_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 CMOBJPROPS58 add DMSAFFINECONNECTIONS integer

alter table CMOBJPROPS58 add DMSEXECUTIONTIMELIMIT integer

alter table CMOBJPROPS58 add DMSMAXPROCESSES integer

alter table CMOBJPROPS58 add DMSNONAFFINECONNCTS integer

alter table CMOBJPROPS58 add DMSPEAKMAXPROCESSES integer

alter table CMOBJPROPS58 add DMSPEAKNONAFFINECONNCTS integer

alter table CMOBJPROPS58 add DMSQUEUELIMIT integer

update CMOBJPROPS67 set DMSPEAKCONS=NULL

INSERT INTO CMOBJPROPS58(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID IN (186)

!RunCMScript CMUpgradeScript_configuration_update_16.xml