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


CBRISQLY

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

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;

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014