analytics/configuration/schemas/logging/db2zOS/LS_tablespace_db2zOS.sql

-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2013
-- 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 
--
--  Modifications:
--
--  1) Replace IPFSCRIPT_DATABASE  to the desired database name.
--  2) Replace IPFSCRIPT_STOGROUP   to the desired storage group name.
--  3) Replace IPFSCRIPT_LS_ID with a unique audit database ID, no more than two character long, with literal first character 
--  4) Replace IPFSCRIPT_BP with the name of the 8K buffer pool, allocated for regular objects
--  5) Replace IPFSCRIPT_TABLESPACE  with a name of the tablespace, allocated for base tables
--  6) Note: PRIQTY and SECQTY are estimated values, your requirements may differ.
--  7) Note: DSSIZE and the SEGSIZE are estimated values, your requirements may differ.
--  8) Note: LOCKSIZE and CCSID and GBPCACHE are estimated values, your requirements may differ.






------------------------------------------------------------------------
--*Tablespace CREATION DDL                                            --
------------------------------------------------------------------------
 CREATE  TABLESPACE  IPFSCRIPT_TABLESPACE IN IPFSCRIPT_DATABASE 
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 100000   SECQTY 100000 
    ERASE NO 
    FREEPAGE 0 PCTFREE 5
    TRACKMOD YES   
    COMPRESS NO   GBPCACHE CHANGED  
    SEGSIZE  4
    CCSID UNICODE 
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE ANY           LOCKMAX SYSTEM 
    CLOSE NO ;
 COMMIT;

 CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL01  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT; 

  CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL02  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT; 
 
  CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL03  IN IPFSCRIPT_DATABASE 
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT; 
 
  CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL04  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;
 COMMIT; 
 
  CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL05  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;	
 COMMIT; 
 
   CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL06  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;	
 COMMIT; 
 
    CREATE  LOB TABLESPACE  IPFSCRIPT_LS_IDIPFL07  IN IPFSCRIPT_DATABASE  
    USING STOGROUP IPFSCRIPT_STOGROUP   PRIQTY 1600   SECQTY 10016 
    ERASE NO 
    GBPCACHE SYSTEM  
    DSSIZE 4G    
    BUFFERPOOL IPFSCRIPT_BP  
    LOCKSIZE LOB           LOCKMAX 0
    CLOSE YES ;	
 COMMIT;