SAMPLIB member CBRISQLX, as shown here, provides DB2 definitions
for part of the OAM administration database. You must modify and run
the job successfully before you use OAM.
//CBRISQLX JOB MSGLEVEL=(1,1),MSGCLASS=A
//****************************************************************
//*
//* $SEG(CBRISQLX) COMP(OSR) PROD(OAM):
//*
//* OAM DB2 Database Definition Job (for Administration
//* Databases).
//*
//* This job will create the OAM Administration databases,
//* tables, and indexes in DB2.
//*
//* Before running this job, you must change the following:
//*
//* 1. Change "cat_name" to the DB2 VCAT name used
//* for defining the VSAM data sets in CBRIALCX.
//*
//* 2. Change "auth_id" to the identifier(s)
//* authorized for the respective group.
//*
//* 3. Change the name in the DSN SYSTEM(DB2) statement to
//* the name of the DB2 Subsystem in your installation.
//*
//* 4. 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.
//*
//* 5. Change the PLAN name (DSNTIA51) in the RUN statement to
//* match your current DB2 version and release level.
//*
//*
//* CHANGE ACTIVITY:
//* $L0=JDP3227 320 890601 TUCJRL: Initial Release
//* $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 DATABASE OAMADMIN;
COMMIT;
CREATE TABLESPACE MCIND
IN OAMADMIN
USING VCAT cat_name
LOCKSIZE ANY
CLOSE NO
BUFFERPOOL BP0;
CREATE UNIQUE INDEX OAMADMIN.CBRSTOX
ON OAMADMIN.CBR_STO_CLASS_TBL
(
ODSCNUM ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
COMMIT;
CREATE TABLE OAMADMIN.CBR_COLLECTION_TBL
(
ODCLSCNM VARCHAR(30) NOT NULL,
ODCLMCNM VARCHAR(30) NOT NULL,
ODCLSGNM VARCHAR(30) NOT NULL,
ODCLID INTEGER NOT NULL,
ODCLNAME VARCHAR(44) NOT NULL
)
IN OAMADMIN.COLIND;
CREATE TABLESPACE SCIND
IN OAMADMIN
USING VCAT cat_name
LOCKSIZE ANY
CLOSE NO
BUFFERPOOL BP0;
CREATE TABLESPACE COLIND
IN OAMADMIN
USING VCAT cat_name
LOCKSIZE ANY
CLOSE NO
BUFFERPOOL BP0;
COMMIT;
CREATE TABLE OAMADMIN.CBR_MGT_CLASS_TBL
(
ODMCNUM SMALLINT NOT NULL,
ODMCNAME VARCHAR(30) NOT NULL
)
IN OAMADMIN.MCIND;
CREATE UNIQUE INDEX OAMADMIN.CBRMGTX
ON OAMADMIN.CBR_MGT_CLASS_TBL
(
ODMCNUM ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
COMMIT;
CREATE TABLE OAMADMIN.CBR_STO_CLASS_TBL
(
ODSCNUM SMALLINT NOT NULL,
ODSCNAME VARCHAR(30) NOT NULL
)
IN OAMADMIN.SCIND;
CREATE UNIQUE INDEX OAMADMIN.CBRCLTX1
ON OAMADMIN.CBR_COLLECTION_TBL
(
ODCLID ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
CREATE UNIQUE INDEX OAMADMIN.CBRCLTX2
ON OAMADMIN.CBR_COLLECTION_TBL
(
ODCLNAME ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
CREATE INDEX OAMADMIN.CBRCLTX3
ON OAMADMIN.CBR_COLLECTION_TBL
(
ODCLSGNM ASC
)
USING VCAT cat_name
CLOSE NO
BUFFERPOOL BP1
PCTFREE 10;
COMMIT;
GRANT ALL ON
OAMADMIN.CBR_MGT_CLASS_TBL
TO auth_id;
GRANT ALL ON
OAMADMIN.CBR_STO_CLASS_TBL
TO auth_id;
GRANT ALL ON
OAMADMIN.CBR_COLLECTION_TBL
TO auth_id;
COMMIT;