analytics/configuration/schemas/logging/db2zOS/LS_tablespaceUpgrade_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  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;
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL07 TO IPFSCRIPT_USERNAME;