//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;
/*
//