analytics/configuration/schemas/content/db2zOS/dbCleanRows_db2zOS.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2019
--
-- 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 CMSYSPROPS;

delete from CMCAPACITY;

delete from CMDBTEST;

delete from CMCRYPTOKEYS;

delete from CMCAKEYS;

delete from CMCAPROPS;

delete from CMOBJECTS;

delete from CMOBJNAMES;
		
delete from CMDATA;

delete from CMOBJPROPS1;

delete from CMOBJPROPS2;

delete from CMOBJPROPS3;

delete from CMOBJPROPS4;

delete from CMOBJPROPS5;

delete from CMOBJPROPS6;

delete from CMOBJPROPS7;

delete from CMOBJPROPS9;

delete from CMOBJPROPS10;

delete from CMOBJPROPS11;

delete from CMOBJPROPS13;

delete from CMOBJPROPS14;

delete from CMOBJPROPS15;

delete from CMOBJPROPS16;

delete from CMOBJPROPS17;

delete from CMOBJPROPS18;

delete from CMOBJPROPS20;

delete from CMOBJPROPS23;

delete from CMOBJPROPS24;

delete from CMOBJPROPS25;

delete from CMOBJPROPS26;

delete from CMOBJPROPS27;

delete from CMOBJPROPS28;

delete from CMOBJPROPS30;

delete from CMOBJPROPS31;

delete from CMOBJPROPS32;

delete from CMOBJPROPS33;

delete from CMOBJPROPS34;

delete from CMOBJPROPS35;

delete from CMOBJPROPS36;

delete from CMOBJPROPS37;

delete from CMOBJPROPS38;

delete from CMOBJPROPS39;

delete from CMOBJPROPS40;

delete from CMOBJPROPS41;

delete from CMOBJPROPS42;

delete from CMOBJPROPS43;

delete from CMOBJPROPS44;

delete from CMOBJPROPS45;

delete from CMOBJPROPS46;

delete from CMOBJPROPS47;

delete from CMOBJPROPS48;

delete from CMOBJPROPS49;

delete from CMOBJPROPS50;

delete from CMOBJPROPS51;

delete from CMOBJPROPS52;

delete from CMOBJPROPS53;

delete from CMOBJPROPS54;

delete from CMOBJPROPS55;

delete from CMOBJPROPS56;

delete from CMOBJPROPS57;

delete from CMOBJPROPS58;

delete from CMOBJPROPS59;

delete from CMOBJPROPS60;

delete from CMOBJPROPS61;

delete from CMOBJPROPS62;

delete from CMOBJPROPS63;

delete from CMOBJPROPS64;

delete from CMOBJPROPS65;

delete from CMOBJPROPS66;

delete from CMOBJPROPS67;

delete from CMOBJPROPS68;

delete from CMOBJPROPS69;

delete from CMOBJPROPS70;

delete from CMOBJPROPS71;

delete from CMOBJPROPS72;

delete from CMOBJPROPS73;

delete from CMOBJPROPS74;

delete from CMOBJPROPS75;

delete from CMOBJPROPS76;

delete from CMOBJPROPS77;

delete from CMOBJPROPS78;

delete from CMOBJPROPS79;

delete from CMOBJPROPS80;

delete from CMOBJPROPS81;

delete from CMOBJPROPS82;

delete from CMOBJPROPS83;

delete from CMOBJPROPS84;

delete from CMOBJPROPS85;

delete from CMOBJPROPS86;

delete from CMOBJPROPS87;

delete from CMOBJPROPS88;

delete from CMOBJPROPS89;

delete from CMOBJPROPS90;

delete from CMOBJPROPS91;

delete from CMOBJPROPS92;

delete from CMOBJPROPS93;

delete from CMPOLICIES;

delete from CMVIEWED;

delete from CMDELETEDSCHEDULES;

delete from CMPROPERTIES;

delete from CMCLASSES;

delete from CMLOCALES;

delete from CMGUIDS;

delete from CMREFNOORD1;

delete from CMREFNOORD2;

delete from CMREFORD1;

delete from CMREFORD2;

delete from CMSTOREIDS;

delete from CMDATAUPGRADE;

delete from CMNOTIFICATIONTABLE;

delete from CMSIZEINFO;

delete from CMSPLIT;

delete from CMARCHIVESTATUS;

delete from CMARCHIVEQUEUE;

delete from CMDELETEQUEUE;

delete from CMQUEUELOCK;

delete from CMTENANTID;

delete from CMINDEXQUEUE;

delete from CMTAGS;

commit;