샘플 BIPCRDB 파일

변경 시작
//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.V810'
//*
//*    Replace   ++DB2RUNLIB++
//*                      DB2.
//*                      e.g. 'DSN810PK.RUNLIB.LOAD'
//*
//*    Replace   ++DB2SUBSYSTEM++
//*                      DB2 SSID.
//*                      e.g. 'DFK4'
//*
//*    Replace   ++DB2LOCATION++
//*                      DB2 location.
//*                      e.g. 'DSN810PK'
//*
//*    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. 'DSNTEP81'
//*
//******************************************************************
//*
//******************************************************************
//* 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;
/*
//
변경 끝
관련 태스크
브로커 구성요소 데이터 세트 사용자 정의
관련 참조
mqsichangebroker 명령
mqsideletebroker 명령
주의사항 | 등록상표 | 다운로드 | 라이브러리 | 지원 | 피드백
Copyright IBM Corporation 1999, 2006 마지막 갱신 날짜: 5월 12, 2006
ae22390_