z/OS DFSMS OAM Planning, Installation, and Storage Administration Guide for Object Support
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


CBRISQLX

z/OS DFSMS OAM Planning, Installation, and Storage Administration Guide for Object Support
SC23-6866-00

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;

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014