//BIPCRDB JOB //****************************************************************** //* * //* @START_COPYRIGHT@ * //* * //* Lizenziertes Material - Eigentum der IBM. * //* 5655-G97 (c) Copyright IBM Corp. 2004. * //* Alle Rechte vorbehalten. * //* 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 * //* * //* Speichergruppe/Datenbank und Tabellenbereiche für den Broker * //* erstellen. * //* * //****************************************************************** //* Hier finden Sie weitere Informationen: * //* * //* WebSphere Event/Message Brokers Information Center. * //* * //* * //****************************************************************** //* PASSEN SIE DIESEN JCL-CODE FÜR IHRE INSTALLATION AN //* AN DIESEN PARAMETERN MÜSSEN SIE MIT HILFE IHRES EDITORS GLOBALE ÄNDERUNGEN VORNEHMEN //* * //* Ersetzen Sie ++DB2HLQ++ //* DB2-Pfadname. //* z. B. 'SYS2.DB2.V810' //* //* Ersetzen Sie ++DB2RUNLIB++ //* DB2. //* z. B. 'DSN810PK.RUNLIB.LOAD' //* //* Ersetzen Sie ++DB2SUBSYSTEM++ //* Subsystem-ID für DB2. //* z. B. 'DFK4' //* //* Ersetzen Sie ++DB2LOCATION++ //* DB2-Speicherposition. //* z. B. 'DSN810PK' //* //* Ersetzen Sie ++DB2CURRENTSQLID++ //* SET CURRENT SQLID-Benutzer-ID. //* z. B. 'MQ01GRP' //* //* Ersetzen Sie ++DB2DATABASE++ //* DB2-Datenbank. //* z. B. 'DMQ01BRK' //* //* Ersetzen Sie ++DB2STORAGEGROUP++ //* DB2-Speichergruppe. //* z. B. 'MQ01STOR' //* //* Ersetzen Sie ++DB2BUFFERPOOL++ //* DB2-Basistabellenpufferpool. //* z. B. 'BP0' //* //* Ersetzen Sie ++DB2INDEXBP++ //* DB2-Indexpufferpool. //* z. B. 'BP0' //* //* Ersetzen Sie ++DB2LOBBP++ //* DB2 LOB-Tabellenpufferpool. //* z. B. 'BP0' //* //* Ersetzen Sie ++DB2SAMPLEPROGRAM++ //* Name des DB2-Beispielprogramms. //* z. B. 'DSNTEP2' //* //* Ersetzen Sie ++DB2SAMPLEPROGRAMPLAN++ //* Name des DB2-Beispielprogrammplans. //* z. B. 'DSNTEP81' //* //****************************************************************** //* //****************************************************************** //* Speichergruppe für den Broker erstellen //****************************************************************** //* //STORGRP EXEC PGM=IKJEFT01,REGION=0M //* DB2-Laufzeitbibliotheken //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++; /* //* //****************************************************************** //* Brokerdatenbank erstellen //****************************************************************** //* //DATABASE EXEC PGM=IKJEFT01,REGION=0M //* DB2-Laufzeitbibliotheken //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++; /* //* //****************************************************************** //* Tabellenbereiche für den Broker erstellen //****************************************************************** //* //TABLESPC EXEC PGM=IKJEFT01,REGION=0M //* DB2-Laufzeitbibliotheken //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; /* //