If the number this command produces looks to be too low, you can use the SHOW SLOTS LIBRARYNAME command to examine what is in the library. If a slot contains a checked in tape, its status will be 'Allocated' while slots that have a status of 'Full' contain tapes that are not checked in. SHOW LIBRARY A very useful command that shows the status of all libraries attached to a server,.

Open systems connected to IBM TotalStorage SCSI Libraries

A view of Tivoli Storage Manager's database

• Page 2 MHVTL + TSM on WIN + TD5 tape drive. Hello, I still can't use TSM with TD5 drives using TSM on Windows ad Iscsi Tryed both centos 5.6 and centos 6.0, both scst and stgt Mhvtl latest git.
• Now the problem is the tape has been moved to some slot in library, how can I add that tape to scratch pool, I have other 9 tapes which I have not loaded in the library yet, as I need to confirm first the commands are working. Kindly provide me with the commands so that I can add the new tapes as scratch in library.

TSM (Tivoli Storage Manager) uses Structured Query Language (SQL) to monitor its servers. SQL is a relational database language and has been adopted as an International Standard by the International Organization Standardization (ISO). TSM dsmadmc SELECT command uses a subset of the language element part for the SELECT query of SQL.

System catalog tables

Tivoli Storage Manager provides three system catalog tables to help you find what information is available in the database:

Tsm Show Slots Status Full Hd

• SYSCAT.TABLES:-Contains information about all tables that can be queried with the SELECT SQL query command.
• SYSCAT.COLUMNS:-Contains information about the columns in each table.
• SYSCAT.ENUMTYPES:-Contains information about the valid values for each enumerated type and the order of the values for each type.

Consideration

The below points should be considered while issuing a SELECT statement:

• A minimum of 4MB space is required in the database to use the SELECT command.
• Complex queries can affect Tivoli Storage Manager server performance and hence the usage of the SELECT SQL query command has restrictions.
• The following and correlated subqueries are not supported: UNION, INTERSECT, and EXCEPT.

Some acronyms used throughout this article are given below.

• TSM:Tivoli Storage Manager
• SQL:Structured Query Language
• DB:Database

The tape inventory script

This script uses the syntax of KSH (Korn Shell) and has been intended to work on open systems with TSM version 5.2 or greater installed and connected to IBM TotalStorage SCSI libraries (including 358x, 3310,and 3200). It queries the TSM DB(particularly SYSCAT.TABLES) and pulls out a report on the inventory and state information of all the tapes associated with Tivoli Storage Manager server. Any system or operator privileged TSM administrator can execute this script from a Korn Shell. A brief on both the privileges to a TSM administrator as below:

• System - A system administrator has the highest level of authority in Tivoli Storage Manager, can issue any administrative command and manage all policy domains and all storage pools.
• Operator - An administrator with operator privilege can issue commands that control the immediate operation of the server and the availability of storage media.

Inside the script

The SELECT statements used in the script query the following tables of interest within the system catalog table, SYSCAT.TABLES:

• MEDIA- This table will list the following:
  • VOLUME_NAME:The barcode label written into the tapes during LABEL LIBVOL
  • STATE:A tape can be in any of these two states i.e. MOUNTABLEINLIB:the tape belongs to a storagepool and is present in the library or MOUNTABLENOTINLIB:the tape belongs to a storagepool but is not present in the library
  • STGPOOL_NAME:The storagepool to which the tape is allocated.
  • LIB_NAME:The library that contains the volume/tape
  • STATUS:The status of a tape/volume can be FULL,FILLING or EMPTY
  • ACCESS:the access of a tape/volume can be READWRITE,READONLY or UNAVAILABLE

A sample code from the script will show the above listed fields of MEDIA table being utilized:

• DRMEDIA - This table contains information pertaining to DR(Disaster Recovery)in Tivoli Storage Manager. It lists the below fields:
  • VOLUME_NAME:The barcode label written into the tapes during 'LABEL LIBVOL'
  • STATE:A DR tape can be in any of these states i.e. REMOTE,MOUNTABLE,NOTMOUNTABLE,VAULT,VAULTRETRIEVE,COURIER and COURIERRETRIEVE
  • STGPOOL_NAME:The copy storagepool to which the tape belongs.
  • LIB_NAME:The library that contains the volume/tape
  • VOLTYPE:DR tapes are used either for copystoragepools or dbbackups , the volume type will determine exactly that.

A DR tape in REMOTE state will imply that it is present on an offsited remote server. A sample code from the script will show the above listed fields of DRMEDIA table being utilized:

• STGPOOLS:-This table has been utilized for the POOLTYPE field which forks into PRIMARY or COPY type and only the volumes with storagepool of type COPY will be queried in the DRMEDIA table.

• LIBVOLUMES:-This table will determine the HOME_ELEMENT(slot number in the library) and STATUS(Private or Scratch) of a volume.Volumes with status as scratch are not assigned to any storagepool and can be automatically picked by any or be manually assigned to a storagepool.

State change considerations

This section covers certain points while looking at state changes of a DR tape i.e. a coptstoragepool or a dbbackup tape.

• Tapes which had been in a media state of VAULT gradually see their contents expire, until the tape is finally empty, at which time the state automatically changes to VAULTRETRIEVE.
• To specify the number of days before a database backup series is expired, issue the SET DRMDBBACKUPEXPIREDAYS command. This is effective for non-virtual/local backup volumes only.
• The volume update from VAULT to VAULTRETRIEVE is not a state change as the volume is still in the vault. With no state change there is no date/time update.

Implementation of the script

Download the script from the Downloads sub-section of this article and make sure the user has 'execute' permission before running it. The first step will ask you to supply a TSM administrator's name with system or operator privilege, followed by password of the respective administrator. Note here that the script cancels the display of password for security reasons. The last step after pressing return will be the TSM's server or instance name. This name should be the one supplied using SET SERVERNAME command at the TSM server prompt.

A stepwise execution of the script is shown below:

Output of the script

This part will cover the outcome of the script and brief about the various fields in the output.

• SNO- The serial number determining the number of volumes associated with the TSM server.
• VOLNAME- The tape barcode label written into the tape/volume during LABEL LIBVOL.
• LOC- The LOC tells about the position of tape with respect to library i.e., whether it is in the library, out of the library, is vaulted or is it a remote type. Following are the possible values to this field:
  • IN_LIB - The tape is physically present in the library
  • OUT_LIB - The tape is physically out of the library
  • DR Media States like VAULT,VAULTRETRIEVE
  • REMOTE - In which case the volume is present on an offsited remote server
• SLOT- It contains information about the home slot to which a volume originally belongs. Alternatively, can be checked using SHOW SLOTS command at the TSM prompt.
• LIB- The library that contains the tape/volume.
• SVR- The server/instance which own the volume. In case you have a library manager-client setup, you are advised to run this script only on the library manager, as it will contain volume ownership for the library client too.
• POOL- The storagepool to which the tape is assigned. In case of a PRIMARY storagepool, the script will list the storagepool name too and for a COPY pool, only CopyStgPool will be displayed, whereas for dbbackup tapes DBBackup will be the value of this field. A value of SCRATCH suggests that this volume has not been assigned to any storage pool.
• OFFSITABLE?- Whether the tape/volume is an offsitable tape i.e., a DR tape, this value will be YES for COPY storagepool and DBBACKUP(non-remote) tapes whereas will be NA for PRIMARY storagepool and REMOTE tapes
• OFFSITED?- If the tape belongs to COPY storagepool or DBBACKUP and if it has met the criteria for offsiting/DR, it will have the value as YES else a NO
• DRSTATE- The state of the tape with respect to DR, for PRIMARY storagepool tapes this value will be NA.
• STATUS- Values of this field will signify if the tape is FULL (no additional data can be written), FILLING (additional data can be added to the tape until it's at capacity) or EMPTY. For tapes that qualify for offsiting, this value will be NA.
• ACCESS- This field determines if the tape is available for read only or read/write access. A case of UNAVAILABLE would mean the tape is not accessible for either reading or writing purpose. For tapes that qualify for offsiting, this value will be NA. A value of SCRATCH signifies that the volume is of type scratch and has no access available unless assigned to a storagepool for used for dbbackup.

Tsm Show Slots Status Full Screen

The below screenshot shows the above headers of the script's output.

A sample output of the script excluding the headers is shown below. The first field is the serial order and tells us that there are 3 tapes associated with the TSM server. AC7594, TPD551 and TPD607 are the tape labels which in ideal case match with the barcode on the exterior of the tape. In case of discrepancies in labels, pass the OVERWRITE=YES parameter with the LABEL LIBVOL command. The VAULT and CopyStgPool signifies that the volume belongs to a storagepool of type COPY and has been offsited or kept in a vault which can also be seen from the value YES for 'OFFSITED?' field. Also, note that since TPD551 is offsited, it is not available for access and the STATUS is NA. Similarly, is the case with TPD607 volume, which being a dbbackup tape is not available for readwrite purpose. Moreover, this dbbackup tape has met the conditions of offsiting and is ready to be offsited from the 'OFFSITABLE?' values as YES, but has not been offsited as from the 'OFFSITED?' value being NO, so this tape needs attention and must be couriered to an offsite location.

Note- The complete output can be redirected to a file on Open Systems and also imported into a Microsoft Excel sheet with a 'tab' delimiter.

Downloadable resources

• TSM Tape Inventory ksh script (TSM_Tape_Inventory_v1.1.zip | 1.21KB)

Related topics

Comments

Sign in or register to add and subscribe to comments.