Volume table (VOLUME)

The volume table contains one row for each optical disk volume. The DB2 name of the volume table is VOLUME. The table is defined in table space OCVOLTSP. Table 1 describes the attributes of the columns in the volume table. Two rows are inserted into the volume table when the two optical volumes comprising an optical disk are identified to OAM. The two optical volumes are identified to OAM when the following conditions exist:

The two volumes are labeled on an operator-accessible optical disk drive in response to an OAM LABEL command.
The two volumes are labeled on a library-resident optical disk drive when the operator enters an unlabeled optical cartridge into the input/output station of an optical library.
The two volumes comprising an already labeled, but unknown, optical cartridge are verified as part of the cartridge being entered into an optical library.

Should OAM discover minor discrepancies with the Volume table at initialization, the following recovery actions are automatically invoked to circumvent failure of the initialization:

The row that is in error is skipped over, and a corresponding volume or tape volume control block is not built. A message is issued indicating the row that was skipped and the reason it was bypassed.
The table row is corrected when a valid value is easily recognizable, and a message is issued stating the correction that is made by OAM and what steps can be taken if the correction is not acceptable to the customer.
More detailed messages containing recovery actions are provided and issued during OAM initialization for database discrepancies.

Table 1. Volume table column description
Column description	Name	DB2 type	DB2 attribute	Value	Report label
Volume serial number	VOLSER	CHAR(6)	NN		VOLSER
Other side VOLSER	OVOLSER	CHAR(6)	NN		OTHER_VOLSER
Location	LOCATION	CHAR(1)	NN	L\|S	LOCATION
Slot name	SLOT²	CHAR(3)	NN		SLOT
Library name	OLIBRARY	CHAR(8)	NN		OLIBRARY
Shelf location	SHELFLOC	CHAR(32)	NND		SHELF_LOCATION
Last-mounted date	MNTDATE	DATE	NND		DATE_LAST_MOUNTED
Last-written date	WRTDATE	DATE	NND		DATE_LAST_WRITTEN
Expiration date	EXPDATE	DATE	NND		EXPIRATION_DATE
Eject/Enter date	EJECTDAT	DATE	NND		EJECT/ENTER_DATE
Address of last data sector	LASTDATA²	INTEGER	NN		LAST_DATA_SECTOR
Address of last logical OVTOC sector	LASTVTCL²	INTEGER	NN		LAST_LOGICAL_VTOC_SECTOR
Address of last physical OVTOC sector	LASTVTCP²	INTEGER	NN		LAST_PHYSICAL_VTOC_SECTOR
Storage group name	VOLUMSET	CHAR(8)	NN		STORAGE_GROUP
Volume type	TYPE	CHAR(1)	NN	B\|G\|S	TYPE
Orientation	ORIENT²	CHAR(1)	NN	0\|1	ORIENTATION
Full status	FULL	CHAR(1)	NN	Y\|N\|P	FULL
Readable	READABLE	CHAR(1)	NN	Y\|N	VOLUME_READABLE_STATUS
Writable	WRITABLE	CHAR(1)	NN	Y\|N	VOLUME_WRITABLE_STATUS
Write-protected status	WRTPROT	CHAR(1)	NN	Y\|N	WRITE_PROTECTED
Owner information part	OWNERP	CHAR(1)	NND	1\|2	OWNER_INFORMATION_POSITION
Owner information	OWNER	CHAR(32)	NND		OWNER_INFORMATION
Free space	FRESPACE	INTEGER	NND		FREE_SPACE
Deleted space	DELSPACE¹	INTEGER	NND		DELETED_SPACE
Number of deleted objects	DELCOUNT¹	INTEGER	NND		DELETED_OBJECTS
Fragmentation index	FRAGIDX¹	SMALLINT	NND		FRAGMENTATION_INDEX
Media type	MEDIATYP	CHAR(2)	NND		MEDIA_TYPE
Volume creation date	CREDATE	DATE	NND		CREATE_DATE
Volume error status	ERRSTAT³	SMALLINT	NND		VOLUME_ERROR_STATUS
Volume empty	VOLEMPTY¹	CHAR(1)		Y\|N	VOLUME_EMPTY
Deleted objects recount	RECOUNT¹	SMALLINT		0\|1	DELETED_OBJECTS_ RECOUNT
Volume Capacity	CAPACITY	INTEGER	NND		CAPACITY
OAM XCF member name	MEMBER	CHAR(16)	NND		OAM_XCF_MEMBER
Pseudo library name	PLIBRARY	CHAR(8)	NND		PSEUDO_LIBRARY_FOR_VOLUME
Backup type	BKTYPE	CHAR(1)	NND	1\|2\|blank	BKTYPE
Note: ¹ DELSPACE, DELCOUNT, FRAGIDX, VOLEMPTY, and RECOUNT apply only to OAM rewritable media. ³ Applies only to the 3995.

The VOLSER column has a unique index. Therefore, each optical disk volume defined in the volume table must have a unique volume serial number. The optical disk volume serial number must be unique across all types of media used by the installation. The optical disk volume serial number must not conflict with the volume serial number of a tape volume being used by OAM. The optical disk volume serial number must not conflict with the serial number of any SMS-managed DASD volume or any mounted non-SMS-managed DASD volume.

The columns labeled volume location, volume type, volume orientation, volume full, volume readable, volume writable, write-protected status, owner information position, media type, volume error status, volume empty, and deleted objects recount in the volume table require specific values:

VOLSER

The volume serial number on one side of the optical disk.

OVOLSER

The volume serial number on the opposite side of the optical disk.

LOCATION

The location of the optical volume

L: This volume is in a library.
S: This volume is on the shelf.

SLOT

The library slot location for the optical volume.

OLIBRARY

The library name in which the volume resides.

SHELFLOC

The shelf location of the shelf-resident optical volume.

MNTDATE

The date that OAM last mounted the volume.

WRTDATE

The date that OAM last wrote to the volume.

EXPDATE

The expiration date of the volume. This date is the latest expiration date of all the objects that reside on the optical volume.

EJECTDAT

This date is when the volume was last entered into or ejected out of the optical library.

LASTDATA

The address of the last data sector on the optical volume. This field is not used for 3995 volumes.

LASTVTCL

The address of the last logical optical VTOC sector on the optical volume. This field is not used for 3995 volumes.

LASTVTCP

The address of the last physical optical VTOC sector on the optical volume. This field is not used for 3995 volumes.

VOLUMESET

The name of the storage group to which the optical volume is associated.

TYPE

The type of the optical volume.

B: This is a BACKUP volume.
G: This is a GROUPED volume.
S: This is a SCRATCH volume.

FULL

The capacity of the optical volume.

Y: This volume is full.
N: This volume is not full.

READABLE

Specifies whether the optical volume is readable.

Y: This volume can be read.
N: This volume cannot be read.
P: This volume is marked permanently full.

WRITABLE

Specifies whether the optical volume is writable.

Y: This volume can be written on.
N: This volume cannot be written on.

WRTPROT

Specifies whether the optical volume is write-protected.

Y: This volume is write-protected.
N: This volume is not write-protected.

OWNERP

Position of the owner information.

1: This is part 1 of the owner information.
2: This is part 2 of the owner information.

OWNER

The volume owner information.

FRESPACE

The available free space left for writing data, in kilobyte units (1 kilobyte = 1 024 bytes) on the optical volume.

DELSPACE

The amount of deleted space on a rewritable optical disk.

Note: When updating DELSPACE, the size of a deleted object is rounded up to the next 1 kilobyte for this field, so deleting a 100 byte object will result in DELSPACE being incremented by 1 kilobyte, even though the actual amount of data deleted is significantly less than 1 kilobyte.

DELCOUNT

The amount of deleted objects marked for deletion from the rewritable optical disk.

FRAGIDX

The fragmentation index on a rewritable optical disk.

MEDIATYP

The media type of the optical volume.

01: 3995 5.25-inch, single-density, rewritable volume
03: 3995 5.25-inch, single-density, WORM volume
11: 3995 5.25-inch, double-density, rewritable volume
13: 3995 5.25-inch, double-density, WORM volume
15: 3995 5.25-inch, double-density, CCW volume
21: 3995 5.25-inch, quad-density, rewritable volume
23: 3995 5.25-inch, quad-density, WORM volume
25: 3995 5.25-inch, quad-density, CCW volume
31: 3995 5.25-inch, 8x-density, rewritable volume
33: 3995 5.25-inch, 8x-density, WORM volume
35: 3995 5.25-inch, 8x-density, CCW volume

CREDATE

The date the optical volume was created.

ERRSTAT

The error status of the optical volume.

0: No error status. This is the initial setting.
101: This volume has an entry in the OCDB but AUDIT found no corresponding entry in the outboard inventory.
102: The cartridge is missing from its assigned slot in the library (empty slot found).
103: AUDIT found the wrong volser in the slot.
105: An error occurred when attempting to read the volume serial number while auditing a volume.
201: This volume has an entry in the OCDB but REMAP found no corresponding entry in the outboard inventory.

VOLEMPTY

Specifies whether the optical volume can be erased.

Y: This 3995 rewritable volume can be reformatted.
N: This 3995 write-once-read-many volume cannot be erased.

RECOUNT

Specifies whether a recount of the logically deleted objects, or a summing up of the available deleted kilobytes, is performed.

0: No recount of the number of logically deleted objects, or summing up of the available kilobytes that have been deleted, is performed.
1: A recount of the number of logically deleted objects, or summing up of the available kilobytes that have been deleted, is performed.

MEMBER

Specifies the name of the OAM within a Parallel Sysplex that is managing this optical volume.

For library-resident optical volumes, this member name is the equivalent of the member name for the library in which this volume resides if the library is online. This MEMBER field is blank if the library is offline.
For shelf-resident optical volumes that are mounted on operator-accessible drives, this member name is the equivalent of the member name for the operator-accessible drive (where the operator-accessible drive is online).
For shelf-resident optical volumes that are not mounted on an operator-accessible drive, this member name is blank.

PLIBRARY

The name of the pseudo library the volume is assigned to when it is no longer a library-resident volume.

For shelf-resident optical volumes, this field value is the same as the OLIBRARY column in the DB2 row that represents the volume.
For library-resident optical volumes the field value is either of the following values:
- The pseudo library that the volume was associated with, if it was shelf-resident prior to being entered into the library
- Blank if the volume was not shelf-resident prior to being entered into the library.

BKTYPE

This indicates whether this volume is used for first or second backup copies of an object when the volume has a type of "B", which indicates that it is a backup volume belonging to an Object Backup storage group.