analytics/configuration/schemas/content/db2zOS/tablespace_db2zOS.sql

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

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


--  This script creates the tablespaces for
--  IBM DB2 for z/OS 
--
--  Modifications:
--
--  1) Replace CMSCRIPT_DATABASE  to the desired database name.
--  2) Replace CMSCRIPT_STOGROUP   to the desired storage group name.
--  3) Replace CMSCRIPT_CS_ID with a unique content store ID, no more than two character long, with literal first character 
--  4) Replace CMSCRIPT_LARGE_BP with the name of the buffer pool, allocated for especially large objects
--  5) Replace CMSCRIPT_REGULAR_BP with the name of the buffer pool, allocated for regular objects
--  6) Replace CMSCRIPT_TABLESPACE  with a name of the tablespace, allocated for base tables
--  7) Note: PRIQTY and SECQTY are estimated values, your requirements may differ.
--  8) Note: DSSIZE and the SEGSIZE are estimated values, your requirements may differ.
--  9) Note: LOCKSIZE and CCSID and GBPCACHE are estimated values, your requirements may differ.
--  10) Next available tablespace number is 147

------------------------------------------------------------------------
--*Tablespace CREATION DDL                                            --
------------------------------------------------------------------------
 CREATE  TABLESPACE  CMSCRIPT_CS_IDCMSCRIPT_TABLESPACE IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 100000   SECQTY 100000 
    ERASE NO 
    FREEPAGE 0 PCTFREE 5
    TRACKMOD YES   
     COMPRESS NO   GBPCACHE CHANGED  
    SEGSIZE  4
   CCSID UNICODE 
    BUFFERPOOL CMSCRIPT_REGULAR_BP     
    LOCKSIZE ROW           LOCKMAX SYSTEM 
    CLOSE NO ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML001 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML002 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML003 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML004 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP 
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML005 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML006 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML007 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML008 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML009 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML010 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML011 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML012 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML013 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML014 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML015 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML016 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML017 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML018 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML019 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML020 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML021 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML022 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML023 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML024 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML025 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML026 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML027 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML028 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML029 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML030 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML031 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML032 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML033 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML034 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML035 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML036 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML037 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML038 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML039 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML040 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML041 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML042 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML043 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML044 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML045 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML046 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML047 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML048 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML049 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML050 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML051 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML052 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML053 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML054 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML055 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML056 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML057 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML058 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML059 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML060 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML061 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML062 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 1024 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML063 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML064 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML065 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML066 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML067 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML068 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML069 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML070 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML071 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML072 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML073 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML074 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML075 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML076 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML077 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML078 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML079 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML080 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP    
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML081 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML082 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_LARGE_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML083 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML084 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML085 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML086 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML087 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
  CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML088 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

  CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML089 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML090 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML091 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML092 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML093 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML094 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML095 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML096 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML097 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML098 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML099 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML100 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML102 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML103 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML104 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML105 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML106 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML107 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML108 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML109 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML110 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO 
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML111 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML112 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 -- unused, was originally added for CMDATA.DATAURI
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML113 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML114 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML115 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML116 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML117 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML118 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML119 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML120 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML121 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML122 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML123 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML124 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML125 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM  
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML126 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML127 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML128 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML129 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML130 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML131 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML132 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML133 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML134 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML135 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

 CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML136 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
  CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML137 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML138 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML139 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;
 
   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML140 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML141 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML142 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML143 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML144 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML145 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;

   CREATE  LOB TABLESPACE  CMSCRIPT_CS_IDCML146 IN CMSCRIPT_DATABASE 
    USING STOGROUP CMSCRIPT_STOGROUP       PRIQTY 1600   SECQTY 10016 
    ERASE NO
      GBPCACHE SYSTEM
  DSSIZE 4G
    BUFFERPOOL CMSCRIPT_REGULAR_BP   
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT;