WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


Sample DB2 commands and SQL

Use these samples to create the DB2® databases and storage groups after configuring the stand-alone server or deployment manager.

Before you begin

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

Purpose

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.

Sample SQL

Common Event Infrastructure
-- ########################################################################
-- # 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;                                                          
Business Space
-- ########################################################################
-- # 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;

reference Reference topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.zseries.doc/doc/rins_zos_db_scripts.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).