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


CBRSAMPL

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

SAMPLIB member CBRSAMPL, as shown in CBRSAMPL SAMPLIB member, creates the OAM configuration database.
//CBRSAMPL JOB MSGLEVEL=(1,1),MSGCLASS=A                                00050000
//********************************************************************* 00100000
//*                                                                     00150000
//*  $SEG(CBRSAMPL) COMP(DBM) PROD(OAM):                                00151900
//*                                                                     00153800
//*  OAM DB2 Database Definition Job (for OAM Configuration             00155700
//*  Database).                                                         00157600
//*                                                                     00159500
//*  This job will create the LCS databases, tables, and indexes        00161400
//*  in DB2 for the OAM Configuration Database.                         00163300
//*                                                                     00165200
//*  Before running this job, you must change the following:            00167100
//*                                                                     00169000
//*  1. Change "vol_ser" to the volume serials that your                00170900
//*     target database should reside on.                               00172800
//*                                                                     00174700
//*  2. Change "cat_name" to the name of the catalog you                00176600
//*     will be using under DB2.                                        00178500
//*                                                                     00180400
//*  3. Change "pass_word" to the name of the catalog                   00182300
//*     password.                                                       00184200
//*                                                                     00186100
//*  4. Change the name in the DSN SYSTEM(DB2) statement to             00188000
//*     the name of the DB2 Subsystem in your installation.             00189900
//*                                                                     00191800
//*  5. Change the data set name in the RUN statement                   00193700
//*     LIB('DBxxx.RUNLIB.LOAD') phrase to the data set name used       00195600
//*     in your installation for the DB2 RUNLIB.LOAD data set.          00197500
//*                                                                     00199400
//*  6. Change the PLAN name (DSNTIAxx) in the RUN statement to         00201300
//*     match your current DB2 version and release level.               00203200
//*                                                                     00205100
//*  CHANGE ACTIVITY:                                                   00207000
//*    $L0=JDP3227 320 890601 TUCJRL: Initial Release                   00208900
//*    $L1=JDP3331 331 900815 TUCJRL: Added the deleted objects         00210800
//*                                   table. Changed NUMSLOTS and       00212700
//*                                   NUMESLOT to INTEGER in            00214600
//*                                   OLIBRARY table. Added DEVTYPE     00216500
//*                                   and LIBRDES to OLIBRARY table.    00218400
//*                                   Added DEVTYPE and DRIVDES to      00220300
//*                                   DRIVE table. Added FRESPACE,      00222200
//*                                   DELSPACE, DELCOUNT, FRAGIDX,      00224100
//*                                   MEDIATYP, CREDATE, ERRSTAT,       00226000
//*                                   VOLEMPTY, and RECOUNT to          00227900
//*                                   VOLUME table.                     00229800
//*    $P1=KBI0238 331 900904 TUCKHB: CHANGED LABEL FOR VOLUMSET        00231700
//*                                   TO STORAGE_GROUP.                 00233600
//*                                                                     00235500
//*    $L2=CAPELLA2 120 921203 TUCGRD: ADDED CLIBRARY, MEDIATYP AND     00237400
//*                                   LIBINDEX TO OLIBRARY TABLE.       00239300
//*                                   ADDED CAPACITY TO VOLUME TABLE    00241200
//*                                                                     00243100
//*    $L3=FRBTAPE  332 920220 TUCKHB: ADDED TAPEVOL TABLE FOR          00245000
//*                                   FRB TAPE SUPPORT.                 00246900
//*                                                                     00247400
//*    $L4=OBJTAPE  120 930523 TUCKMF: UPDATED TAPEVOL STEPS TO ADD     00247900
//*                                   NEW 120 COLUMNS FOR LOGICAL       00248400
//*                                   KB DELETED AND TAPE COMPACTION    00248900
//*                                   INDICATOR.                        00249400
//*    $L5=OPTSPE   130 950823 TUCSMC: Added new DRIVENUM to the        00249600
//*                                    DRIVE table.                     00249800
//*    $L6=HDZ11D0  140 970331 TUCSPP: Specify TYPE 1 INDEX for         00262300
//*                                    DB2 4.1 or above level           00274800
//*    $L7=HDZ11E0  150 970812 TUCLJT: ADDED MEMBER TO OLIBRARY TABLE,  00276800
//*                                    DRIVE TABLE, VOLUME TABLE, AND   00278800
//*                                    TAPEVOL TABLE                    00280800
//*                                    ADDED PLIBRARY TO OLIBRARY TABLE 00282800
//*                                    AND VOLUME TABLE                 00284800
//*    $L8=OW38975  1E0 990609 TUCSPP: ADDED NEW EPI FIELD TO THE       00285600
//*                                    TAPE VOLUME TABLE                00286400
//*    $L9=HDZ11G0  R13 000915 TUCLJT: ADDED BKTYPE TO VOLUME TABLE AND 00286700
//*                                    TAPEVOL TABLE                    00287000
//*    $LA=HDZ11H0  R15 011207 TUCBLC: ADDED OUNITNAM AND DATACLAS TO   00287100
//*                                    TAPEVOL TABLE                    00287200
//*    $LB=WRM3592  1J0 042904 TUCLJS: ADDED DSNFMT TO TAPEVOL TABLE    00290400
//*                                     (OA07105)                       00293600
//*    $LC=OAMR19   R19 060310 TUCBJF: ADDED SUBLEVEL TO TAPEVOL TABLE  00295200
//*    $LD=35923E   1K0 070914 TUCBJF: Adding KB overflow columns to    00295500
//*                                    TAPEVOL table:                   00295800
//*                                    (CAPACITYO, FRESPACEO,           00296100
//*                                    NUMLKBWO, NUMPKBWO, NUMLKBDEO)   00296400
//*    $LE=HYDRA16  190 043009 TUCPSS: ADDED VOLATTRF TO TAPEVOL TABLE  00296600
//*    $LF=OAMR1D   R1D 100223 TUCDEW: Added FSDELETE Table             00296700
//*                                                                     00296800
//********************************************************************* 00300000
//OCDBTABS EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)                    00350000
//SYSTSPRT DD SYSOUT=*                                                  00400000
//SYSTSIN  DD *                                                         00450000
 DSN SYSTEM(DB2)                                                        00500000
 RUN  PROGRAM(DSNTIAD) PLAN(DSNTIAxx) -                                 00550000
      LIB('DBxxx.RUNLIB.LOAD')                                          00600000
//SYSPRINT DD SYSOUT=*                                                  00650000
//SYSUDUMP DD SYSOUT=*                                                  00700000
//SYSIN    DD *                                                         00750000
  CREATE STOGROUP CBROAM                                                00800000
      VOLUMES (vol_ser)                                                 00850000
      VCAT cat_name                                                     00900000
      PASSWORD pass_word;                                               00950000
                                                                        01000000
  CREATE DATABASE CBROAM                                                01050000
      STOGROUP CBROAM                                                   01100000
      BUFFERPOOL BP0;                                                   01150000
                                                                        01200000
  CREATE TABLESPACE OCLIBTSP                                            01250000
     IN CBROAM                                                          01300000
     USING STOGROUP CBROAM                                              01350000
     BUFFERPOOL BP0                                                     01400000
     CLOSE NO;                                                          01450000
                                                                        01500000
  CREATE TABLESPACE OCDRVTSP                                            01550000
     IN CBROAM                                                          01600000
     USING STOGROUP CBROAM                                              01650000
     BUFFERPOOL BP0                                                     01700000
     CLOSE NO;                                                          01750000
                                                                        01800000
  CREATE TABLESPACE OCSLTTSP                                            01850000
     IN CBROAM                                                          01900000
     USING STOGROUP CBROAM                                              01950000
     BUFFERPOOL BP0                                                     02000000
     CLOSE NO;                                                          02050000
                                                                        02100000
  CREATE TABLESPACE OCVOLTSP                                            02150000
     IN CBROAM                                                          02200000
     USING STOGROUP CBROAM                                              02250000
     BUFFERPOOL BP0                                                     02300000
     CLOSE NO;                                                          02350000
                                                                        02400000
  CREATE TABLESPACE OCDELTSP                                            02450000
     IN CBROAM                                                          02500000
     USING STOGROUP CBROAM                                              02550000
     BUFFERPOOL BP0                                                     02600000
     CLOSE NO;                                                          02650000
                                                                        02700000
  CREATE TABLESPACE OCTVLTSP                                            02707100
     IN CBROAM                                                          02708100
     USING STOGROUP CBROAM                                              02709100
     BUFFERPOOL BP0                                                     02710100
     CLOSE NO;                                                          02711100
                                                                        02712100
  CREATE TABLESPACE OCFSDTSP                                            02713100
     IN CBROAM                                                          02714200
     USING STOGROUP CBROAM                                              02721300
     BUFFERPOOL BP0                                                     02728400
     CLOSE NO;                                                          02735500
                                                                        02742600
  CREATE TABLE OLIBRARY                                                 02750000
    (NAME      CHAR(8)    NOT NULL,                                     02800000
     ONLINE    CHAR(1)    NOT NULL,                                     02850000
     OPERATNL  CHAR(1)    NOT NULL,                                     02900000
     PATHSTAT  CHAR(1)    NOT NULL,                                     02950000
     COMMAND   CHAR(5)    NOT NULL WITH DEFAULT,                        03000000
     PRIMCTC   CHAR(4)    NOT NULL WITH DEFAULT,                        03050000
     PRIMPORT  CHAR(1)    NOT NULL WITH DEFAULT,                        03100000
     ALTCTC    CHAR(4)    NOT NULL WITH DEFAULT,                        03150000
     ALTPORT   CHAR(1)    NOT NULL WITH DEFAULT,                        03200000
     FAULT     CHAR(3)    NOT NULL WITH DEFAULT,                        03250000
     OLIBTYPE  CHAR(1)    NOT NULL,                                     03300000
     NUMSLOTS  INTEGER    NOT NULL WITH DEFAULT,                        03350000
     NUMESLOT  INTEGER    NOT NULL WITH DEFAULT,                        03400000
     NUMDRVS   SMALLINT   NOT NULL,                                     03450000
     RCOMMAND  CHAR(5)    NOT NULL WITH DEFAULT,                        03464200
     DEVTYPE   CHAR(8)    NOT NULL WITH DEFAULT,                        03478400
     LIBRDES   CHAR(120)  NOT NULL WITH DEFAULT,                        03492600
     CLIBRARY  CHAR(8)    NOT NULL WITH DEFAULT,                        03506800
     MEDIATYP  CHAR(8)    NOT NULL WITH DEFAULT,                        03521000
     LIBINDEX  SMALLINT   NOT NULL WITH DEFAULT,                        03528200
     MEMBER    CHAR(16)   NOT NULL WITH DEFAULT,                        03535400
     PLIBRARY  CHAR(8)    NOT NULL WITH DEFAULT)                        03542600
    IN CBROAM.OCLIBTSP;                                                 03550000
                                                                        03600000
  CREATE TABLE DRIVE                                                    03650000
    (NAME      CHAR(8)    NOT NULL,                                     03700000
     OLIBRARY  CHAR(8)    NOT NULL,                                     03750000
     CTC       CHAR(4)    NOT NULL,                                     03800000
     SCSI      CHAR(1)    NOT NULL,                                     03850000
     LUN       CHAR(1)    NOT NULL,                                     03900000
     ONLINE    CHAR(1)    NOT NULL,                                     03950000
     OPERATNL  CHAR(1)    NOT NULL,                                     04000000
     LDRIVENO  CHAR(1)    NOT NULL WITH DEFAULT,                        04050000
     DRIVTYPE  CHAR(1)    NOT NULL,                                     04075000
     DEVTYPE   CHAR(8)    NOT NULL WITH DEFAULT,                        04100000
     DRIVDES   CHAR(120)  NOT NULL WITH DEFAULT,                        04116600
     DRIVENUM  SMALLINT   NOT NULL WITH DEFAULT,                        04127700
     MEMBER    CHAR(16)   NOT NULL WITH DEFAULT)                        04138800
    IN CBROAM.OCDRVTSP;                                                 04150000
                                                                        04200000
  CREATE TABLE SLOT                                                     04250000
    (NAME      CHAR(3)    NOT NULL,                                     04300000
     OLIBRARY  CHAR(8)    NOT NULL,                                     04350000
     OCCUPIED  CHAR(1)    NOT NULL,                                     04400000
     OPERATNL  CHAR(1)    NOT NULL,                                     04450000
     VOLSER0   CHAR(6)    NOT NULL WITH DEFAULT,                        04500000
     VOLSER1   CHAR(6)    NOT NULL WITH DEFAULT)                        04550000
    IN CBROAM.OCSLTTSP;                                                 04600000
                                                                        05250000
  CREATE TABLE VOLUME                                                   05300000
    (VOLSER    CHAR(6)    NOT NULL,                                     05350000
     OVOLSER   CHAR(6)    NOT NULL,                                     05400000
     LOCATION  CHAR(1)    NOT NULL,                                     05450000
     SLOT      CHAR(3)    NOT NULL,                                     05500000
     OLIBRARY  CHAR(8)    NOT NULL,                                     05550000
     SHELFLOC  CHAR(32)   NOT NULL WITH DEFAULT,                        05600000
     MNTDATE   DATE       NOT NULL WITH DEFAULT,                        05650000
     WRTDATE   DATE       NOT NULL WITH DEFAULT,                        05700000
     EXPDATE   DATE       NOT NULL WITH DEFAULT,                        05750000
     EJECTDAT  DATE       NOT NULL WITH DEFAULT,                        05800000
     LASTDATA  INTEGER    NOT NULL,                                     05850000
     LASTVTCL  INTEGER    NOT NULL,                                     05900000
     LASTVTCP  INTEGER    NOT NULL,                                     05950000
     VOLUMSET  CHAR(8)    NOT NULL,                                     06000000
     TYPE      CHAR(1)    NOT NULL,                                     06050000
     ORIENT    CHAR(1)    NOT NULL,                                     06100000
     FULL      CHAR(1)    NOT NULL,                                     06150000
     READABLE  CHAR(1)    NOT NULL,                                     06200000
     WRITABLE  CHAR(1)    NOT NULL,                                     06250000
     WRTPROT   CHAR(1)    NOT NULL,                                     06257100
     OWNERP    CHAR(1)    NOT NULL WITH DEFAULT,                        06264200
     OWNER     CHAR(32)   NOT NULL WITH DEFAULT,                        06271300
     FRESPACE  INTEGER    NOT NULL WITH DEFAULT,                        06278400
     DELSPACE  INTEGER    NOT NULL WITH DEFAULT,                        06285500
     DELCOUNT  INTEGER    NOT NULL WITH DEFAULT,                        06292600
     FRAGIDX   SMALLINT   NOT NULL WITH DEFAULT,                        06299700
     MEDIATYP  CHAR(2)    NOT NULL WITH DEFAULT,                        06306800
     CREDATE   DATE       NOT NULL WITH DEFAULT,                        06313900
     ERRSTAT   SMALLINT   NOT NULL WITH DEFAULT,                        06321000
     VOLEMPTY  CHAR(1)    NOT NULL WITH DEFAULT,                        06328100
     RECOUNT   SMALLINT   NOT NULL WITH DEFAULT,                        06335200
     CAPACITY  INTEGER    NOT NULL WITH DEFAULT,                        06338900
     MEMBER    CHAR(16)   NOT NULL WITH DEFAULT,                        06340700
     PLIBRARY  CHAR(8)    NOT NULL WITH DEFAULT,                        06342600
     BKTYPE    CHAR(1)    NOT NULL WITH DEFAULT)                        06346300
    IN CBROAM.OCVOLTSP;                                                 06350000
                                                                        06351400
  CREATE TABLE DELOBJT                                                  06352800
    (COLNAME   CHAR(44)   NOT NULL,                                     06354200
     OBJNAME   CHAR(44)   NOT NULL,                                     06355600
     VOLSER    CHAR(6)    NOT NULL,                                     06357000
     VTOCTOKN  INTEGER    NOT NULL,                                     06358400
     OBJSIZE   INTEGER    NOT NULL)                                     06359800
    IN CBROAM.OCDELTSP;                                                 06361200
                                                                        06362600
  CREATE TABLE TAPEVOL                                                  06364000
    (VOLSER    CHAR(6)    NOT NULL,                                     06365400
     UNITNAME  CHAR(8)    NOT NULL,                                     06366800
     MEDIATYP  CHAR(2)    NOT NULL,                                     06368200
     STORGRP   CHAR(8)    NOT NULL,                                     06369600
     TYPE      CHAR(1)    NOT NULL,                                     06371000
     CREDATE   DATE       NOT NULL,                                     06372400
     MNTDATE   DATE       NOT NULL,                                     06373800
     WRTDATE   DATE       NOT NULL,                                     06375200
     EXPDATE   DATE       NOT NULL,                                     06376600
     CAPACITY  INTEGER    NOT NULL,                                     06378000
     FRESPACE  INTEGER    NOT NULL,                                     06379400
     LSTBLKID  INTEGER    NOT NULL,                                     06380800
     PFULL     SMALLINT   NOT NULL,                                     06382200
     NUMLBLKS  INTEGER    NOT NULL,                                     06383600
     NUMLKBW   INTEGER    NOT NULL,                                     06385000
     NUMPKBW   INTEGER    NOT NULL,                                     06386400
     NUMLKBDE  INTEGER    NOT NULL,                                     06387100
     FULL      CHAR(1)    NOT NULL,                                     06387800
     READABLE  CHAR(1)    NOT NULL,                                     06389200
     WRITABLE  CHAR(1)    NOT NULL,                                     06390600
     INUSE     CHAR(1)    NOT NULL,                                     06392000
     COPIED    CHAR(1)    NOT NULL,                                     06393400
     AVOLSER   CHAR(6)    NOT NULL,                                     06394300
     COMPACT   CHAR(1)    NOT NULL,                                     06394900
     EPI       SMALLINT   NOT NULL WITH DEFAULT,                        06395200
     MEMBER    CHAR(16)   NOT NULL WITH DEFAULT,                        06395500
     BKTYPE    CHAR(1)    NOT NULL WITH DEFAULT,                        06395600
     OUNITNAM  CHAR(8)    NOT NULL WITH DEFAULT,                        06395700
     DATACLAS  CHAR(8)    NOT NULL WITH DEFAULT,                        06395800
     DSNFMT    CHAR(1)    NOT NULL WITH DEFAULT,                        06395900
     SUBLEVEL  CHAR(1)    NOT NULL WITH DEFAULT,                        06396400
     CAPACITYO INTEGER    NOT NULL WITH DEFAULT,                        06396900
     FRESPACEO INTEGER    NOT NULL WITH DEFAULT,                        06397400
     NUMLKBWO  INTEGER    NOT NULL WITH DEFAULT,                        06397900
     NUMPKBWO  INTEGER    NOT NULL WITH DEFAULT,                        06398400
     NUMLKBDEO INTEGER    NOT NULL WITH DEFAULT,                        06398700
     VOLATTRF  SMALLINT   NOT NULL WITH DEFAULT)                        06399000
    IN CBROAM.OCTVLTSP;                                                 06399400
                                                                        06403600
 CREATE TABLE FSDELETE                                                  06407800
   (ID       INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY           06409900
                     (START WITH 1, INCREMENT BY 1, CACHE 50, CYCLE),   06412000
    DELTIME  INTEGER      NOT NULL WITH DEFAULT,                        06414100
    DELREAS  CHAR(1)      NOT NULL WITH DEFAULT,                        06416200
    SYSNAME  CHAR(8)      NOT NULL WITH DEFAULT,                        06420400
    SGNAME   CHAR(8)      NOT NULL WITH DEFAULT,                        06424600
    COLNAME  CHAR(44)     NOT NULL WITH DEFAULT,                        06428800
    OBJNAME  CHAR(44)     NOT NULL WITH DEFAULT,                        06433000
    INSTID   INTEGER      NOT NULL WITH DEFAULT)                        06437200
   IN CBROAM.OCFSDTSP;                                                  06441400
                                                                        06445600
 CREATE UNIQUE INDEX LNAMINDX                                           06450000
   ON OLIBRARY                                                          06500000
   (NAME ASC)                                                           06550000
   USING STOGROUP CBROAM                                                06600000
   CLUSTER                                                              06650000
   BUFFERPOOL BP0                                                       06700000
   CLOSE NO;                                                            06750000
                                                                        06800000
 CREATE UNIQUE INDEX DNAMINDX                                           06850000
   ON DRIVE                                                             06900000
   (NAME ASC)                                                           06950000
   USING STOGROUP CBROAM                                                07000000
   BUFFERPOOL BP0                                                       07050000
   CLOSE NO;                                                            07100000
                                                                        07150000
 CREATE UNIQUE INDEX DRIDINDX                                           07200000
   ON DRIVE                                                             07250000
   (CTC, SCSI, LUN ASC)                                                 07300000
   USING STOGROUP CBROAM                                                07350000
   BUFFERPOOL BP0                                                       07400000
   CLUSTER                                                              07450000
   CLOSE NO;                                                            07500000
                                                                        07550000
 CREATE UNIQUE INDEX SLIBINDX                                           07600000
   ON SLOT                                                              07650000
   (NAME, OLIBRARY ASC)                                                 07700000
   USING STOGROUP CBROAM                                                07750000
   BUFFERPOOL BP0                                                       07800000
   CLUSTER                                                              07850000
   CLOSE NO;                                                            07900000
                                                                        07950000
 CREATE UNIQUE INDEX VSERINDX                                           07960500
   ON VOLUME                                                            07971000
   (VOLSER ASC)                                                         07981500
   USING STOGROUP CBROAM                                                07992000
   BUFFERPOOL BP0                                                       08002500
   CLUSTER                                                              08013000
   CLOSE NO;                                                            08023500
                                                                        08034000
 CREATE INDEX DVOLINDX                                                  08044500
   ON DELOBJT                                                           08055000
   (VOLSER ASC)                                                         08065500
   USING STOGROUP CBROAM                                                08076000
   BUFFERPOOL BP0                                                       08086500
   CLOSE NO;                                                            08097000
                                                                        08107500
 CREATE UNIQUE INDEX DELOINDX                                           08118000
   ON DELOBJT                                                           08128500
   (COLNAME, OBJNAME, VOLSER, VTOCTOKN ASC)                             08139000
   USING STOGROUP CBROAM                                                08150000
   BUFFERPOOL BP0                                                       08200000
   CLUSTER                                                              08250000
   CLOSE NO;                                                            08300000
                                                                        08350000
 CREATE UNIQUE INDEX TVOLINDX                                           08400000
   ON TAPEVOL                                                           08450000
   (VOLSER ASC)                                                         08500000
   USING STOGROUP CBROAM                                                08505500
   BUFFERPOOL BP0                                                       08511000
   CLUSTER                                                              08516500
   CLOSE NO;                                                            08522000
                                                                        08527500
 CREATE UNIQUE INDEX FSDTINDX                                           08533000
   ON FSDELETE                                                          08538500
   (ID ASC)                                                             08544000
   USING STOGROUP CBROAM                                                08550000
   BUFFERPOOL BP0                                                       08600000
   CLUSTER                                                              08650000
   CLOSE NO;                                                            08700000
                                                                        08750000
 LABEL ON OLIBRARY                                                      08800000
   (NAME IS 'NAME',                                                     08850000
    ONLINE IS 'ONLINE',                                                 08900000
    OPERATNL IS 'OPERATIONAL',                                          08950000
    PATHSTAT IS 'CURRENT_PATH',                                         09000000
    COMMAND IS 'CURRENT_COMMAND',                                       09050000
    PRIMCTC IS 'PRIMARY_CTC',                                           09100000
    PRIMPORT IS 'PRIMARY_PORT',                                         09150000
    ALTCTC IS 'ALTERNATE_CTC',                                          09200000
    ALTPORT IS 'ALTERNATE_PORT',                                        09250000
    FAULT IS 'FAULT_CODE',                                              09300000
    OLIBTYPE IS 'LIBRARY_TYPE',                                         09350000
    NUMSLOTS IS 'SLOTS',                                                09400000
    NUMESLOT IS 'EMPTY_SLOTS',                                          09450000
    NUMDRVS IS 'DRIVES',                                                09500000
    RCOMMAND IS 'RECOVERY_COMMAND',                                     09514200
    DEVTYPE IS 'DEVICE_TYPE',                                           09528400
    LIBRDES IS 'LIBRARY_DESCRIPTION',                                   09542600
    CLIBRARY IS 'CONTROLLING_LIBRARY',                                  09556800
    MEDIATYP IS 'DEFAULT_MEDIA_TYPE',                                   09571000
    LIBINDEX IS 'LIBRARY_INDEX',                                        09578200
    MEMBER IS 'OAM_XCF_MEMBER',                                         09585400
    PLIBRARY IS 'DEFAULT_PSEUDO_LIBRARY');                              09592600
                                                                        09600000
 LABEL ON DRIVE                                                         09650000
   (NAME IS 'NAME',                                                     09700000
    OLIBRARY IS 'OLIBRARY',                                             09750000
    CTC IS 'CTC',                                                       09800000
    SCSI IS 'SCSI',                                                     09850000
    LUN IS 'LUN',                                                       09900000
    ONLINE IS 'ONLINE',                                                 09950000
    OPERATNL IS 'OPERATIONAL',                                          10000000
    LDRIVENO IS 'DRIVE_NUMBER',                                         10050000
    DRIVTYPE IS 'DRIVE_TYPE',                                           10075000
    DEVTYPE IS 'DEVICE_TYPE',                                           10100000
    DRIVDES IS 'DRIVE_DESCRIPTION',                                     10116600
    DRIVENUM IS 'PHYS_DRIVE_NUMBER',                                    10127700
    MEMBER IS 'OAM_XCF_MEMBER');                                        10138800
                                                                        10150000
 LABEL ON SLOT                                                          10200000
   (NAME IS 'NAME',                                                     10250000
    OLIBRARY IS 'OLIBRARY',                                             10300000
    OCCUPIED IS 'OCCUPIED',                                             10350000
    OPERATNL IS 'OPERATIONAL',                                          10400000
    VOLSER0 IS 'VOLSER0',                                               10450000
    VOLSER1 IS 'VOLSER1');                                              10500000
                                                                        11100000
 LABEL ON VOLUME                                                        11150000
   (VOLSER IS 'VOLSER',                                                 11200000
    OVOLSER IS 'OTHER_VOLSER',                                          11250000
    LOCATION IS 'LOCATION',                                             11300000
    SLOT IS 'SLOT',                                                     11350000
    OLIBRARY IS 'OLIBRARY',                                             11400000
    SHELFLOC IS 'SHELF_LOCATION',                                       11450000
    MNTDATE IS 'DATE_LAST_MOUNTED',                                     11500000
    WRTDATE IS 'DATE_LAST_WRITTEN',                                     11550000
    EXPDATE IS 'EXPIRATION_DATE',                                       11600000
    EJECTDAT IS 'EJECT/ENTER_DATE',                                     11650000
    LASTDATA IS 'LAST_DATA_SECTOR',                                     11700000
    LASTVTCL IS 'LAST_LOGICAL_VTOC_SECTOR',                             11750000
    LASTVTCP IS 'LAST_PHYSICAL_VTOC_SECTOR',                            11800000
    VOLUMSET IS 'STORAGE_GROUP',                                        11850000
    TYPE IS 'TYPE',                                                     11900000
    ORIENT IS 'ORIENTATION',                                            11950000
    FULL IS 'FULL',                                                     12000000
    READABLE IS 'VOLUME_READABLE_STATUS',                               12004200
    WRITABLE IS 'VOLUME_WRITABLE_STATUS',                               12008400
    WRTPROT IS 'WRITE_PROTECTED',                                       12012600
    OWNERP IS 'OWNER_INFORMATION_POSITION',                             12016800
    OWNER IS 'OWNER_INFORMATION',                                       12021000
    FRESPACE IS 'FREE_SPACE',                                           12025200
    DELSPACE IS 'DELETED_SPACE',                                        12029400
    DELCOUNT IS 'DELETED_OBJECTS',                                      12033600
    FRAGIDX IS 'FRAGMENTATION_INDEX',                                   12037800
    MEDIATYP IS 'MEDIA_TYPE',                                           12042000
    CREDATE IS 'CREATE_DATE',                                           12046200
    ERRSTAT IS 'VOLUME_ERROR_STATUS',                                   12050400
    VOLEMPTY IS 'VOLUME_EMPTY',                                         12054600
    RECOUNT IS 'DELETED_OBJECTS_RECOUNT',                               12058800
    CAPACITY IS 'CAPACITY',                                             12060900
    MEMBER IS 'OAM_XCF_MEMBER',                                         12061900
    PLIBRARY IS 'PSEUDO_LIBRARY_FOR_VOLUME',                            12063000
    BKTYPE IS 'BACKUP_TYPE');                                           12065100
                                                                        12067200
 LABEL ON DELOBJT                                                       12071400
   (COLNAME IS 'COLLECTION_NAME',                                       12075600
    OBJNAME IS 'OBJECT_NAME',                                           12079800
    VOLSER IS 'VOLSER',                                                 12084000
    VTOCTOKN IS 'VTOC_TOKEN',                                           12088200
    OBJSIZE IS 'OBJECT_SIZE');                                          12092400
                                                                        12096600
 LABEL ON TAPEVOL                                                       12100800
   (VOLSER IS 'VOLSER',                                                 12105000
    UNITNAME IS 'UNIT_NAME',                                            12109200
    MEDIATYP IS 'MEDIA_TYPE',                                           12113400
    STORGRP IS 'STORAGE_GROUP',                                         12117600
    TYPE IS 'TYPE',                                                     12121800
    CREDATE IS 'CREATION_DATE',                                         12126000
    MNTDATE IS 'DATE_LAST_MOUNTED',                                     12130200
    WRTDATE IS 'DATE_LAST_WRITTEN',                                     12134400
    EXPDATE IS 'EXPIRATION_DATE',                                       12138600
    CAPACITY IS 'CAPACITY',                                             12142800
    FRESPACE IS 'FREE_SPACE',                                           12147000
    LSTBLKID IS 'LAST_BLOCKID',                                         12151200
    PFULL IS 'PERCENT_FULL',                                            12155400
    NUMLBLKS IS 'LOGICAL_BLOCKS_WRITTEN',                               12159600
    NUMLKBW IS 'LOGICAL_KILOBYTES_WRITTEN',                             12163800
    NUMPKBW IS 'PHYSICAL_KILOBYTES_WRITTEN',                            12168000
    NUMLKBDE IS 'LOGICAL_KILOBYTES_DELETED',                            12170100
    FULL IS 'FULL',                                                     12172200
    READABLE IS 'VOLUME_READABLE_STATUS',                               12176400
    WRITABLE IS 'VOLUME_WRITABLE_STATUS',                               12180600
    INUSE IS 'IN_USE',                                                  12184800
    COPIED IS 'COPIED',                                                 12189000
    AVOLSER IS 'ALTERNATE_VOLUME',                                      12192600
    COMPACT IS 'TAPE_COMPACTION_INDICATOR',                             12195000
    EPI     IS 'EPI',                                                   12196200
    MEMBER IS 'OAM_XCF_MEMBER',                                         12197400
    BKTYPE IS 'BACKUP_TYPE',                                            12198000
    OUNITNAM IS 'ORIGINAL_UNIT_NAME',                                   12198600
    DATACLAS IS 'DATACLASS',                                            12199000
    DSNFMT IS 'DATASET_NAME_FORMAT',                                    12199300
    SUBLEVEL IS 'TAPE_SUBLEVEL',                                        12199400
    CAPACITYO IS 'CAPACITY_OVERFLOW',                                   12199500
    FRESPACEO IS 'FREE_SPACE_OVERFLOW',                                 12199600
    NUMLKBWO  IS 'LOGICAL_KBS_WRITTEN_OVERFLOW',                        12199700
    NUMPKBWO  IS 'PHYSICAL_KBS_WRITTEN_OVERFLOW',                       12199800
    NUMLKBDEO IS 'LOGICAL_KBS_DELETED_OVERFLOW',                        12249800
    VOLATTRF  IS 'VOLUME_ATTRIBUTE_FLAGS');                             12299800
                                                                        12349800
 LABEL ON FSDELETE                                                      12399800
   (ID      IS 'ID',                                                    12433100
    DELTIME IS 'DELETE_TIME',                                           12466400
    DELREAS IS 'REASON',                                                12499800
    SYSNAME IS 'SYS_NAME',                                              12549800
    SGNAME  IS 'SG_NAME',                                               12599800
    OBJNAME IS 'OBJECT_NAME',                                           12649800
    COLNAME IS 'COLLECTION_NAME',                                       12699800
    INSTID  IS 'INSTANCE_ID');                                          12749800
                                                                        17500000
 COMMIT;                                                                17550000
/*                                                                      17600000

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014