analytics/configuration/schemas/content/db2/ResetConfiguration1_1_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).


delete from CMOBJPROPS1 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS2 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS3 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS4 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS5 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS6 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS7 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS8 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS9 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS10 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS11 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS12 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS13 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS14 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS15 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS16 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS17 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS18 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS19 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS20 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS21 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS22 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS23 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS24 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS25 where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMPOLICIES where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMGUIDS where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJNAMES where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJECTS where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

update CMCAPACITY set PATH='' where USAGE=4;