analytics/configuration/schemas/logging/db2zOS/LS_dropTablespace_db2zOS.sql

-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

-- This script creates the tablespaces for
--  IBM DB2 for z/OS 
--
--  Modifications:
--
--  1) Changed IPFSCRIPT_DATABASE to the desired db name.
--  2) Replace IPFSCRIPT_TABLESPACE  with a name of the tablespace, allocated for base tables
--  3) Replace IPFSCRIPT_LS_ID with a unique audit database ID, no more than two character long, with literal first character 
------------------------------------------------------------------------
--*Removal of Tablespaces                                             --
------------------------------------------------------------------------
 DROP  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_TABLESPACE;
  
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL01;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL02;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL03;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL04;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL05;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL06;
 
 DROP TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL07;