-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2007, 2012
-- 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 on z/OS.
--
--  Modifications:
--
--  1) Change COGMOBDB to the desired database name.
--  2) Change DB0AUSR to the desired storage group name.
--  3) Change BP32K with the name of the 8K buffer pool, allocated for regular objects.
--  4) Note: PRIQTY, SECQTY, DSSIZE, SEGSIZE, ERASE, 
--           GBPCACHE, FREEPAGE, PCTFREE, TRACKMOD, 
--           CCSID, COMPRESS, CLOSE are estimated values, your
--           requirements may differ.

------------------------------------------------------------------------
--*Tablespace CREATION DDL                                            --
------------------------------------------------------------------------
 CREATE  TABLESPACE  COGMOBTS IN COGMOBDB 
    USING STOGROUP DB0AUSR   PRIQTY 100000   SECQTY 100000 
    ERASE NO 
    FREEPAGE 0 PCTFREE 5
    TRACKMOD YES   
    COMPRESS NO   GBPCACHE CHANGED  
    SEGSIZE  4
    CCSID UNICODE 
    BUFFERPOOL BP32K  
    LOCKSIZE ANY           LOCKMAX SYSTEM 
    CLOSE NO
 /

 CREATE  LOB TABLESPACE  MOBTSL01  IN COGMOBDB  
    USING STOGROUP DB0AUSR   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL BP32K  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES
 /