//BIPCRDB JOB //****************************************************************** //* * //* @START_COPYRIGHT@ * //* * //* Materiales bajo licencia - Propiedad de IBM; * //* 5655-G97 (c) Copyright IBM Corp. 2004; * //* Reservados todos los derechos; * //* Derechos restringidos para los usuarios del gobierno de EE.UU. * //* Utilización, duplicación o divulgación restringida por el GSA * //* ADP Schedule Contract con IBM Corp.; * //* Vea las instrucciones de copyright * //* * //* @END_COPYRIGHT@ * //* * //****************************************************************** //* IBM WebSphere Event/Message Brokers * //* * //* Creación de grupo de almacenamiento / base de datos y espacios * //* de tablas de intermediario. * //* * //****************************************************************** //* MÁS INFORMACIÓN - Consulte: * //* * //* Centro de información de WebSphere Event/Message Brokers. * //* * //* * //****************************************************************** //* PERSONALICE AQUÍ ESTE JCL PARA SU INSTALACIÓN //* HA DE EFECTUAR CAMBIOS GLOBALES EN ESTOS PARÁMETROS USANDO SU EDITOR //* * //* Sustituya ++DB2HLQ++ //* Calificador de alto nivel DB2. //* por ej. 'SYS2.DB2.V810' //* //* Sustituya ++DB2RUNLIB++ //* DB2. //* por ej. 'DSN810PK.RUNLIB.LOAD' //* //* Sustituya ++DB2SUBSYSTEM++ //* DB2 SSID. //* por ej. 'DFK4' //* //* Sustituya ++DB2LOCATION++ //* Ubicación de DB2. //* por ej. 'DSN810PK' //* //* Sustituya ++DB2CURRENTSQLID++ //* ID de usuario SET CURRENT SQLID. //* por ej. 'MQ01GRP' //* //* Sustituya ++DB2DATABASE++ //* Base de datos DB2. //* por ej. 'DMQ01BRK' //* //* Sustituya ++DB2STORAGEGROUP++ //* Grupo de almacenamiento de DB2. //* por ej. 'MQ01STOR' //* //* Sustituya ++DB2BUFFERPOOL++ //* Agrupación de almacenamientos intermedios //* de tabla de base DB2. //* por ej. 'BP0' //* //* Sustituya ++DB2INDEXBP++ //* Agrupación de almacenamientos intermedios //* de índice de DB2. //* por ej. 'BP0' //* //* Sustituya ++DB2LOBBP++ //* Agrupación de almacenamientos intermedios //* de tabla LOB de DB2. //* por ej. 'BP0' //* //* Sustituya ++DB2SAMPLEPROGRAM++ //* Nombre de programa de ejemplo de DB2. //* por ej. 'DSNTEP2' //* //* Sustituya ++DB2SAMPLEPROGRAMPLAN++ //* Nombre de plan de programa de ejemplo de DB2. //* por ej. 'DSNTEP81' //* //****************************************************************** //* //****************************************************************** //* Creación de grupo de almacenamiento de intermediario //****************************************************************** //* //STORGRP EXEC PGM=IKJEFT01,REGION=0M //* Bibliotecas de ejecución DB2 //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++; /* //* //****************************************************************** //* Creación de una base de datos de intermediario //****************************************************************** //* //DATABASE EXEC PGM=IKJEFT01,REGION=0M //* Bibliotecas de ejecución DB2 //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++; /* //* //****************************************************************** //* Creación de espacios de tablas de intermediario //****************************************************************** //* //TABLESPC EXEC PGM=IKJEFT01,REGION=0M //* Bibliotecas de ejecución DB2 //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; /* //