analytics/configuration/schemas/content/sqlserver/dbUpgrade5_0005-to-5_0006_mssqlserver.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 GSAUDITLVL tinyint null

alter table CMOBJPROPS58 add GSAFFINECONNECTIONS int null

alter table CMOBJPROPS58 add GSEXECUTIONTIMELIMIT int null

alter table CMOBJPROPS58 add GSMAXPROCESSES int null

alter table CMOBJPROPS58 add GSNONAFFINECONNCTS int null

alter table CMOBJPROPS58 add GSPEAKMAXPROCESSES int null

alter table CMOBJPROPS58 add GSPEAKNONAFFINECONNCTS int null

alter table CMOBJPROPS58 add GSQUEUELIMIT int null

alter table CMOBJPROPS58 add GSPEAKCONS int null

!RunCMScript CMUpgradeScript_configuration_update_22.xml