StorageTek 312564001 Manuel D’Utilisation
DB2 Manager User Guide
173
StorageTek
Proprietary
OTDBDEF
Member OTDBDEF creates the DB2 Manager system database.
//OTDBDEF JOB
//*
//* DB2 Manager system database creation job.
//*
//* Change history:
//* GW 19-Mar-03 V1.1 created
//* GW 02-Apr-04 V1.1 re-branded
//*
//* This job creates the database manager system database. It
//* includes steps to allocate files, define the database and
//* grant authorities for database access.
//*
//* Before submitting the job, review each line marked with
//* with "<===" and modify as appropriate for execution at
//* your installation.
//*
//STEP01 EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2) <===
RUN PROGRAM(DSNTIAD) PLAN(DSNTIAnn) - <===
LIB('DB2.runtime.library') <===
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DROP DATABASE LCDDB2;
COMMIT;
//*
//STEP02 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DELETE -
DSN610.DSNDBC.LCDDB2.LCDDB2TS.I0001.A001 - <===
CLUSTER
DELETE -
DSN610.DSNDBC.LCDDB2.REGIX1.I0001.A001 - <===
CLUSTER
DELETE -
DSN610.DSNDBC.LCDDB2.REGIX2.I0001.A001 - <===
CLUSTER
SET LASTCC=0
SET MAXCC=0
DEFINE CLUSTER -
(NAME(DSN610.DSNDBC.LCDDB2.LCDDB2TS.I0001.A001) - <===
LINEAR -
SHAREOPTIONS(3 3) -
VOLUMES(vvvvvv) - <===
CYLINDERS(1 1) -
UNIQUE ) -
DATA -
(NAME(DSN610.DSNDBD.LCDDB2.LCDDB2TS.I0001.A001)) <===
DEFINE CLUSTER -
(NAME(DSN610.DSNDBC.LCDDB2.REGIX1.I0001.A001) - <===
LINEAR -
SHAREOPTIONS(3 3) -
VOLUMES(vvvvvv) - <===