analytics/configuration/schemas/hts/zosdb2/HTS_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.

-------------------------------------------------------------------------------
-- HTS_CREATE_Hsql.sql         *  DO NOT EDIT  *          Data Store Version: 2
-------------------------------------------------------------------------------

CREATE TABLESPACE HTSATTAC
    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 HTSLOBAT
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSCLBCK
    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 HTSCBPAR
    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 HTSLOBCP
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSHDLNE
    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 HTSDDLNE
    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 HTSESCAL
    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 HTSESCHR
    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 HTSESCTP
    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 HTSFOLDE
    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 HTSHUMRL
    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 HTSIMPOR
    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 HTSNOTIF
    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 HTSDLESC
    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 HTSESCHS
    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 HTSLCKNT
    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 HTSLNESC
    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 HTSPOTSS
    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 HTSPRSPR
    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 HTSTSKDE
    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 HTSTKESC
    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 HTSTKIMP
    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 HTSTKPRE
    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 HTSTCPRE
    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 HTSTSKPR
    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 HTSTSKPJ
    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 HTSTSKPY
    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 HTSTSKPU
    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 HTSTKPEN
    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 HTSTKSUB
    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 HTSTUDPL
    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 HTSTKPRL
    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 HTSTKRDY
    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 HTSTSKTK
    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 HTSTSKTR
    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 HTSTSKUB
    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 HTSMSGTS
    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 HTSLOBMS
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSPOSTS
    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 HTSLOBPT
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSPRDES
    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 HTSLOBPD
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSPRELS
    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 HTSPRSDC
    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 HTSLOBDE
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSPELSN
    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 HTSPDSUB
    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 HTSELSPS
    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 HTSRENDR
    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 HTSLOREN
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSTASKT
    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 HTSTSKCL
    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 HTSLOTKC
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

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

CREATE TABLESPACE HTSTCPRO
    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 HTSTSKSU
    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 HTSTSKUS
    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 HTSTPCTR
    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 HTSLOTPC
    IN NCCOG
    USING STOGROUP DSN8G810
        PRIQTY 3200
        SECQTY 1600
    ERASE NO
    GBPCACHE SYSTEM
    BUFFERPOOL BP32K
    LOCKSIZE LOB
    LOCKMAX 0
    CLOSE YES ;

CREATE TABLESPACE HTSTSKRB
    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 HTSTHRED
    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 HTSUNSUB
    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 HTSUDISN
    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 HTSVERSI
    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 ;