analytics/configuration/schemas/content/db2/dbUpgrade5_0006-to-5_0007_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 AASAUDITLVL smallint

alter table CMOBJPROPS58 add column AASAFFINECONNECTIONS integer

alter table CMOBJPROPS58 add column AASEXECUTIONTIMELIMIT integer

alter table CMOBJPROPS58 add column AASMAXPROCESSES integer

alter table CMOBJPROPS67 add column AASNONAFFINECONNCTS integer

alter table CMOBJPROPS67 add column AASPEAKCONS integer

alter table CMOBJPROPS67 add column AASPEAKMAXPROCS integer

alter table CMOBJPROPS67 add column AASPEAKNONAFFINECONNCTS integer

!RunCMScript CMUpgradeScript_configuration_update_23.xml