Use these samples to create the DB2® databases and storage groups after configuring the stand-alone server or deployment manager.
Before running createDB.sh you must allocate the following buffer pools with these DB2 commands:
-ALTER BUFFERPOOL (BP1) VPSIZE(20000) -ALTER BUFFERPOOL (BP2) VPSIZE(20000) -ALTER BUFFERPOOL (BP3) VPSIZE(20000)You must also make sure that permission to use them has been granted as follows:
GRANT USE OF BUFFERPOOL BP1 TO PUBLIC; GRANT USE OF BUFFERPOOL BP2 TO PUBLIC; GRANT USE OF BUFFERPOOL BP3 TO PUBLIC;You can also run the DB2 commands in a batch job, for example:
//JOBLIB DD DISP=SHR,DSN=db2hlq.SDSNLOAD //STEP1 EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(ssid) -ALTER BUFFERPOOL (BP1) VPSIZE(20000) -ALTER BUFFERPOOL (BP2) VPSIZE(20000) -ALTER BUFFERPOOL (BP3) VPSIZE(20000) RUN PROGRAM(DSNTIAD) PLAN(DSNTIAnn) - LIBRARY('db2hlq.RUNLIB.LOAD') END //SYSIN DD * GRANT USE OF BUFFERPOOL BP1 TO PUBLIC ; GRANT USE OF BUFFERPOOL BP2 TO PUBLIC ; GRANT USE OF BUFFERPOOL BP3 TO PUBLIC ; /*
If you are in datasharing mode, you will need make sure you define the cache XCF structures for group buffer pools GBP1, GBP2 and GBP3. For further information see the DB2 Information Center: Cross-system coupling facility component of z/OS
The following sample SQL statements are provided to assist you when creating separate databases and storage groups after running the configuration script ( zWESBConfig.sh). Customize then run the scripts using a tool such as SPUFI, DSNTEP2, or DBUtility.sh. See Creating the DB2 databases and storage groups using SPUFI, DSNTEP2, or DButility.sh.
-- ######################################################################## -- # Licensed Materials - Property of IBM -- # 5724-L01, 5724-I82, 5655-N53, 5655-R15 -- # (C) Copyright IBM Corporation 2006. All Rights Reserved. -- # US Government Users Restricted Rights - Use, duplication or disclosure -- # restricted by GSA ADP Schedule Contract with IBM Corp. -- ######################################################################## SET CURRENT SQLID = 'WSADMIN'; DROP DATABASE EVENT ; DROP DATABASE EVENTCAT ; DROP STOGROUP EVTSTO; CREATE STOGROUP EVTSTO VOLUMES (WBIUS3,WBIUS4,WBIUS5) VCAT WSDB2; CREATE DATABASE EVENT STOGROUP EVTSTO BUFFERPOOL BP1 CCSID UNICODE INDEXBP BP2; CREATE DATABASE EVENTCAT STOGROUP EVTSTO BUFFERPOOL BP1 CCSID UNICODE INDEXBP BP2; COMMIT;
-- ######################################################################## -- # Licensed Materials - Property of IBM -- # 5724-L01, 5724-I82, 5655-N53, 5655-R15 -- # (C) Copyright IBM Corporation 2006. All Rights Reserved. -- # US Government Users Restricted Rights - Use, duplication or disclosure -- # restricted by GSA ADP Schedule Contract with IBM Corp. -- ######################################################################## SET CURRENT SQLID = 'WSADMIN'; DROP DATABASE B6BSPACE ; CREATE STOGROUP B6BSPSTO VOLUMES (WBIUS3,WBIUS4,WBIUS5) VCAT WSDB2; CREATE DATABASE B6BSPACE STOGROUP B6BSPSTO BUFFERPOOL BP1 CCSID UNICODE INDEXBP BP2; COMMIT;