analytics/configuration/schemas/content/db2/dbUpgrade2_0017-to-2_0018_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 CMOBJPROPS11 drop constraint PK_CMOBJPROPS11

rename CMOBJPROPS11 to CMOBJPROPS11_OLD

create table CMOBJPROPS11 (
	CMID			integer not null ,
	CONNECTSTR		varchar (2048),
	ISOLEVEL		smallint,
	QUALIFIER		smallint,
	REPLACEMENT		varchar (512),
	STATUSID		smallint,
	SEQUENCING		smallint,
	CAPACITY		float,
	FORMAT			smallint,
	OLOCALEID		smallint,
	SERVERGROUP		varchar (512),
	LASTPAGE		varchar (512),
	RUNASOWNER		decimal(1,0),
	CANBURST		decimal(1,0),
	EVENTID			varchar(45),
	OWNEREVENTID		varchar(45),
	SCHEDTRIGNAME	varchar(255),
	LOADBALMODE		smallint,
	ALLOWNOTIFICATION	decimal(1,0),
	CONSTRAINT PK_CMOBJPROPS11 PRIMARY KEY (CMID) 
)

insert into CMOBJPROPS11(CMID,CONNECTSTR,ISOLEVEL,QUALIFIER,REPLACEMENT,STATUSID,SEQUENCING,
	CAPACITY,FORMAT,OLOCALEID,SERVERGROUP,LASTPAGE,RUNASOWNER,CANBURST,EVENTID,
	OWNEREVENTID,SCHEDTRIGNAME,LOADBALMODE,ALLOWNOTIFICATION) 
    select CMID,CONNECTSTR,ISOLEVEL,QUALIFIER,REPLACEMENT,STATUSID,SEQUENCING,
	CAPACITY,FORMAT,OLOCALEID,SERVERGROUP,LASTPAGE,RUNASOWNER,CANBURST,EVENTID,
	OWNEREVENTID,SCHEDTRIGNAME,LOADBALMODE,ALLOWNOTIFICATION from CMOBJPROPS11_OLD

drop table CMOBJPROPS11_OLD