SAMPLIB member CBRISQLY, as shown here, provides the DB2 definitions
for part of the OAM administration database. You must modify and run
the job successfully before you use OAM.
//CBRISQLY JOB MSGLEVEL=(1,1),MSGCLASS=A
//***********************************************************
//*
//* $SEG(CBRISQLY) COMP(OSR) PROD(OAM):
//*
//* OAM DB2 Database Definition Job (for Administration
//* Databases).
//*
//* This job will create additional unique indexes for
//* the OAM Administration Databases in DB2.
//*
//* Prior to executing this job you need to make the
//* following modifications:
//*
//* 1. Change "cat_name" to the DB2 VCAT name used
//* for defining the VSAM data sets in CBRIALCY.
//*
//* 2. Change the name in the DSN SYSTEM(DB2) statement to
//* the name of the DB2 Subsystem in your installation.
//*
//* 3. Change the data set name in the RUN statement
//* LIB('DB2.RUNLIB.LOAD') phrase to the data set name used
//* in your installation for the DB2 RUNLIB.LOAD data set.
//*
//* 4. Change the PLAN name (DSNTIA51) in the RUN statement to
//* match your current DB2 version and release level.
//*
//* CHANGE ACTIVITY:
//* $O0=OY28892 320 890601 TUCJRL: Add unique indexes to
//* those defined in
//* CBRISQLX
//* $L1=HDZ11D0 140 970331 TUCSPP: Specify TYPE 1 INDEX for
//* DB2 4.1 or above level
//* $L2=HDZ11G0 R13 001016 TUCLJT: Removed reference to type 1
//* indexes, no longer supported
//* by DB2 and removed SUBPAGES
//* from CREATE statements
//*
//****************************************************************
//CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2)
RUN PROGRAM(DSNTIAD) PLAN(DSNTIA51) -
LIB('DB2.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
CREATE UNIQUE INDEX OAMADMIN.CBRMGTY
ON OAMADMIN.CBR_MGT_CLASS_TBL
(
ODMCNAME ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
CREATE UNIQUE INDEX OAMADMIN.CBRSTOY
ON OAMADMIN.CBR_STO_CLASS_TBL
(
ODSCNAME ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
COMMIT;