analytics/configuration/schemas/delivery/zosdb2/NC_TABLESPACES.sql

--
--    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 creates the tablespaces for
--  IBM DB2 for z/OS for the JSM tables
--
--  Modifications:
--
--  1) Change NCCOG  to the desired database name.
--  2) Change DSN8G810 to the desired storage group name.
--  3) Change BP32K to the desired buffer pool name.
--  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 LOB TABLESPACE NCLOBJMS
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE LOB TABLESPACE NCLOBJOB
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE LOB TABLESPACE NCLOBHIS
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE LOB TABLESPACE NCLOBQUE
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE NCDEFTS1
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCDEFTS2
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX SYSTEM
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLSTA
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX SYSTEM
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLJMS
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLJOB
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLMET
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLSCH
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLTSK
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLOVE
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLANC
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLHIS
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLQUE
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;

CREATE TABLESPACE NCTBLTSE
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 1600
        SECQTY 1024
    ERASE NO
    DEFINE YES
    FREEPAGE 0 PCTFREE 5
    TRACKMOD NO
    GBPCACHE CHANGED
    BUFFERPOOL BP32K
    LOCKSIZE ROW
    LOCKMAX 0
    COMPRESS NO
    CCSID UNICODE
    CLOSE NO ;