analytics/configuration/schemas/content/db2zOS/dropTablespace_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).


--This script creates the tablespaces for
--  IBM DB2 for z/OS 
--
--  Modifications:
--
--  1) Replace CMSCRIPT_DATABASE  to the desired database name.
--  2) Replace CMSCRIPT_CS_ID with a unique content store ID, no more than two character long, with literal first character 
--  3) Replace CMSCRIPT_TABLESPACE  with a name of the tablespace, allocated for base tables
------------------------------------------------------------------------
--*Removal of Tablespaces                                             --
------------------------------------------------------------------------
 DROP  TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCMSCRIPT_TABLESPACE;
  
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML001;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML002;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML003;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML004;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML005;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML006;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML007;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML008;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML009;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML010;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML011;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML012;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML013;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML014;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML015;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML016;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML017;
     
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML018;     

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML019;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML020;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML021;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML022;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML023;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML024;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML025;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML026;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML027;
     
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML028;     

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML029;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML030;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML031;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML032;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML033;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML034;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML035;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML036;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML037;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML038;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML039;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML040;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML041;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML042;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML043;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML044;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML045;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML046;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML047;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML048;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML049;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML050;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML051;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML052;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML053;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML054;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML055;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML056;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML057;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML058;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML059;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML060;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML061;
     
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML062;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML063;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML064;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML065;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML066;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML067;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML068;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML069;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML070;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML071;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML072;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML073;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML074;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML075;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML076;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML077;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML078;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML079;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML080;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML081;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML082;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML083;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML084;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML085;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML086;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML087;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML088;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML089;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML090;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML091;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML092;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML093;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML094;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML095;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML096;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML097;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML098;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML099;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML100;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML102;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML103;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML104;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML105;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML106;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML107;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML108;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML109;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML110;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML111;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML112;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML113;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML114;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML115;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML116;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML117;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML118;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML119;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML120;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML121;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML122;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML123;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML124;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML125;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML126;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML127;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML128;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML129;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML130;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML131;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML132;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML133;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML134;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML135;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML136;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML137;

 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML138;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML139;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML140;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML141;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML142;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML143;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML144;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML145;
 
 DROP TABLESPACE  CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML146;
 
 commit;