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