//BIPCRDB JOB //****************************************************************** //* * //* @START_COPYRIGHT@ * //* * //* Licensed Materials - Property of IBM; * //* 5655-G97 (c) Copyright IBM Corp. 2004; * //* All Rights Reserved; * //* US Government Users Restricted Rights - use, * //* duplication or disclosure restricted by GSA * //* ADP Schedule Contract with IBM Corp.; * //* See Copyright Instructions * //* * //* @END_COPYRIGHT@ * //* * //****************************************************************** //* IBM WebSphere Event/Message Brokers * //* * //* Create broker storagegroup / database and tablespaces. * //* * //****************************************************************** //* MORE INFORMATION - See: * //* * //* WebSphere Event/Message Brokers Information Centre. * //* * //* * //****************************************************************** //* CUSTOMIZE THIS JCL HERE FOR YOUR INSTALLATION //* YOU MUST DO GLOBAL CHANGES ON THESE PARAMETERS USING YOUR EDITOR //* * //* Replace ++DB2HLQ++ //* DB2 high-level-qualifier. //* e.g. 'SYS2.DB2.V710' //* //* Replace ++DB2RUNLIB++ //* DB2. //* e.g. 'DSN710PK.RUNLIB.LOAD' //* //* Replace ++DB2SUBSYSTEM++ //* DB2 SSID. //* e.g. 'DFK4' //* //* Replace ++DB2LOCATION++ //* DB2 location. //* e.g. 'DSN710PK' //* //* Replace ++DB2CURRENTSQLID++ //* SET CURRENT SQLID user ID. //* e.g. 'MQ01GRP' //* //* Replace ++DB2DATABASE++ //* DB2 database. //* e.g. 'DMQ01BRK' //* //* Replace ++DB2STORAGEGROUP++ //* DB2 storagegroup. //* e.g. 'MQ01STOR' //* //* Replace ++DB2BUFFERPOOL++ //* DB2 base table bufferpool. //* e.g. 'BP0' //* //* Replace ++DB2INDEXBP++ //* DB2 index bufferpool. //* e.g. 'BP0' //* //* Replace ++DB2LOBBP++ //* DB2 LOB table bufferpool. //* e.g. 'BP0' //* //* Replace ++DB2SAMPLEPROGRAM++ //* DB2 sample program name. //* e.g. 'DSNTEP2' //* //* Replace ++DB2SAMPLEPROGRAMPLAN++ //* DB2 sample program plan name. //* e.g. 'DSNTEP71' //* //****************************************************************** //* //****************************************************************** //* Create broker storagegroup //****************************************************************** //* //STORGRP EXEC PGM=IKJEFT01,REGION=0M //* DB2 Runtime Libraries //STEPLIB DD DISP=SHR,DSN=++DB2HLQ++.SDSNEXIT // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOAD // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOD2 // DD DISP=SHR,DSN=++DB2RUNLIB++ //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(++DB2SUBSYSTEM++) RUN - PROGRAM(++DB2SAMPLEPROGRAM++) - PLAN(++DB2SAMPLEPROGRAMPLAN++) //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * SET CURRENT SQLID='++DB2CURRENTSQLID++'; CREATE STOGROUP ++DB2STORAGEGROUP++ VOLUMES('*') VCAT ++DB2LOCATION++; /* //* //****************************************************************** //* Create broker database //****************************************************************** //* //DATABASE EXEC PGM=IKJEFT01,REGION=0M //* DB2 Runtime Libraries //STEPLIB DD DISP=SHR,DSN=++DB2HLQ++.SDSNEXIT // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOAD // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOD2 // DD DISP=SHR,DSN=++DB2RUNLIB++ //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(++DB2SUBSYSTEM++) RUN - PROGRAM(++DB2SAMPLEPROGRAM++) - PLAN(++DB2SAMPLEPROGRAMPLAN++) //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * SET CURRENT SQLID='++DB2CURRENTSQLID++'; CREATE DATABASE ++DB2DATABASE++ STOGROUP ++DB2STORAGEGROUP++ INDEXBP ++DB2INDEXBP++; /* //* //****************************************************************** //* Create broker tablespaces //****************************************************************** //* //TABLESPC EXEC PGM=IKJEFT01,REGION=0M //* DB2 Runtime Libraries //STEPLIB DD DISP=SHR,DSN=++DB2HLQ++.SDSNEXIT // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOAD // DD DISP=SHR,DSN=++DB2HLQ++.SDSNLOD2 // DD DISP=SHR,DSN=++DB2RUNLIB++ //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(++DB2SUBSYSTEM++) RUN - PROGRAM(++DB2SAMPLEPROGRAM++) - PLAN(++DB2SAMPLEPROGRAMPLAN++) //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * SET CURRENT SQLID='++DB2CURRENTSQLID++'; CREATE TABLESPACE BSUBSCRI IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ROW CLOSE NO; CREATE TABLESPACE BPUBLISH IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BCLIENTU IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BUSERCON IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BTOPOLOG IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BNBRCONN IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRETAINE IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ROW CLOSE NO; CREATE TABLESPACE BACLENTR IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BMQPSTOP IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BUSERNAM IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BGROUPNA IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BUSERMEM IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BROKERAA IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BROKERAE IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BROKERRE IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRMINFO IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRMRTDIN IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRMRTDDE IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRMWFDIN IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BRMPHYSI IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE TABLESPACE BAGGREGA IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ROW CLOSE NO; CREATE TABLESPACE BMULTICA IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 7200 SECQTY 720 ERASE NO FREEPAGE 5 PCTFREE 20 SEGSIZE 32 BUFFERPOOL ++DB2BUFFERPOOL++ LOCKSIZE ANY CLOSE NO; CREATE LOB TABLESPACE BSUBLOB1 IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BSUBLOB2 IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BSUBLOB3 IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BPUBLLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BCLIELOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BRETLOB1 IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BRETLOB2 IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BACLELOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BMQPSLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BMULTLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BROKALOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BROKRLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BRMRTLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BRMPHLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; CREATE LOB TABLESPACE BAGGRLOB IN ++DB2DATABASE++ USING STOGROUP ++DB2STORAGEGROUP++ PRIQTY 72000 SECQTY 7200 BUFFERPOOL ++DB2LOBBP++ LOCKSIZE LOB; /* //