--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: JSM
--    
--    (c) Copyright IBM Corp. 2003, 2011.
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    
-- This script drops the tablespaces for
--  IBM DB2 for z/OS 
--
--  Modifications:
--
--  1) Change NCCOG to the desired database name. 
------------------------------------------------------------------------
--*Removal of Tablespaces                                             --
------------------------------------------------------------------------

DROP  TABLESPACE NCCOG.NCLOBJMS;

DROP  TABLESPACE NCCOG.NCLOBJOB;

DROP  TABLESPACE NCCOG.NCLOBHIS;

DROP  TABLESPACE NCCOG.NCLOBQUE;

DROP  TABLESPACE NCCOG.NCDEFTS1;

DROP  TABLESPACE NCCOG.NCDEFTS2;

DROP  TABLESPACE NCCOG.NCTBLSTA;

DROP  TABLESPACE NCCOG.NCTBLJMS;

DROP  TABLESPACE NCCOG.NCTBLJOB;

DROP  TABLESPACE NCCOG.NCTBLMET;

DROP  TABLESPACE NCCOG.NCTBLSCH;

DROP  TABLESPACE NCCOG.NCTBLTSK;

DROP  TABLESPACE NCCOG.NCTBLOVE;

DROP  TABLESPACE NCCOG.NCTBLANC;

DROP  TABLESPACE NCCOG.NCTBLHIS;

DROP  TABLESPACE NCCOG.NCTBLQUE;

DROP  TABLESPACE NCCOG.NCTBLTSE;