analytics/configuration/schemas/ans/zosdb2/ANN_TABLESPACES.sql

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: HTS
--    
--    (c) Copyright IBM Corp. 2003, 2011.
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    

--
--  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.

CREATE TABLESPACE ANNANNOT
    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 ANNANNPR
    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 ANNANNTX
    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 ANNANNCN
    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 ANNCTXDI
    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 ANNDATIT
    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 ANNDIMEN
    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 ANNDIMMM
    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 ANNDIMDI
    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 ANNDIMMT
    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 ANNIDTBL
    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 ANNMETIT
    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 ANNMODEL
    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 ANNMDLDI
    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 ANNVERSI
    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 LOB TABLESPACE ANNLOBPR
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

-------------------------------------------------------------------------------
--	END ANS_CREATE_Db2Zos.sql        *  DO NOT EDIT  *
-------------------------------------------------------------------------------