サンプル 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 最終更新: 08/21/2006
ae22390_