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


--CMSCRIPT_UPGRADE_SKIP_COMMAND(3.006801,4.0001)
create table CMOBJPROPS48 (
	CMID	integer not null,
	constraint PK_CMOBJPROPS48 primary key (CMID)
)

alter table CMOBJPROPS48 add column ASCONNECTIONS integer

alter table CMOBJPROPS48 add column CMSCONNECTIONS integer

alter table CMOBJPROPS48 add column DDSCONNECTIONS integer

alter table CMOBJPROPS48 add column DISCONNECTIONS integer

alter table CMOBJPROPS48 add column DSCONNECTIONS integer

alter table CMOBJPROPS48 add column IDSCONNECTIONS integer

alter table CMOBJPROPS48 add column ISSCONNECTIONS integer

alter table CMOBJPROPS48 add column IUSCONNECTIONS integer

alter table CMOBJPROPS48 add column JSCONNECTIONS integer

alter table CMOBJPROPS48 add column MBSCONNECTIONS integer

alter table CMOBJPROPS48 add column MMSCONNECTIONS integer

alter table CMOBJPROPS48 add column PACSCONNECTIONS integer

alter table CMOBJPROPS48 add column PRSCONNECTIONS integer

alter table CMOBJPROPS48 add column PTSCONNECTIONS integer

alter table CMOBJPROPS48 add column BRSCHHOTSPOTLIMIT integer

alter table CMOBJPROPS48 add column RSCHHOTSPOTLIMIT integer

--CMSCRIPT_UPGRADE_SKIP_COMMAND(3.006801,4.0001)
insert into CMOBJPROPS48(CMID) select CMID from CMOBJECTS where CLASSID in (4,34,14)

insert into CMOBJPROPS48(CMID) select CMID from CMOBJECTS where CLASSID in (83,47,155,84,88,99,164,165,166,177,170,171,172,176,65,25)

!RunCMScript CMUpgradeScript_configuration_update_8.xml