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