Slot table (SLOT)

The slot table contains one row for each slot in an optical library. The DB2 name of the slot table is SLOT. The table is defined in table space OCSLTTSP. The row for each slot gives the status of the slot. Also, a row exists for the optical library input/output station and the optical library cartridge access mechanism. Table 1 describes the attributes of the columns in the SLOT table.

Table 1. Slot table column description
Column description	Name	Index	DB2 type	DB2 attribute	Value	Report label
Slot name	NAME	P	CHAR(3)	NN		NAME
Optical library name	OLIBRARY	P	CHAR(8)	NN		OLIBRARY
Occupied status	OCCUPIED		CHAR(1)	NN	Y\|N	OCCUPIED
Operational status	OPERATNL		CHAR(1)	NN	Y\|N	OPERATIONAL
Side 0 volume serial number	VOLSER0		CHAR(6)	NND		VOLSER0
Side 1 volume serial number	VOLSER1		CHAR(6)	NND		VOLSER1
Note: This table is not used for 3995 libraries.

The combination of NAME and OLIBRARY must be unique for each slot defined in the slot table because there is a partitioned index on the NAME and OLIBRARY columns.

During OAM initialization, all necessary rows are inserted into the slot table based on the optical libraries defined in the library table.

The occupied status and operational status columns in the slot table require specific values:

OCCUPIED

Indicates the status of the slot within the library.

Y: Slot is occupied.
N: Slot is not occupied.

OPERATNL

Indicates the operational status of the slot within the library.

Y: Slot is operational.
N: Slot is not operational.