Tsm Show Slots Command

Warning: This update has a bug also concerning Data Domain that causes errors if the defined VTL has more than 4400 slots. So when we upgraded the server to fix the LAN-Free bug we inadvertently encountered this bug. Update: Here is the APAR listing for the Data Domain VTL slot bug in TSM 6.2.x. Tsm Show Slots Library parameters: RTP and volatility. RTP shows what part of bets a slot returns to players over a long term. Volatility has to do with the frequency and size of payouts. There are slots that have small but frequent payouts and those that pay out rarely but generously. The volume A00004L3 in slot 4106 is in the library TS3310 but not in the TSM's inventory database. Please either check in this volume or remove it from the library. This is what i got when trying to check it out.

Show commands for server or storage agent

The show commands listed are those that are most typically requested or used for diagnosing problems. This list does not discuss all possible show commands that are available.

To find information about a show command, click the command in the table below or scroll through the list of commands below the table. The information about show commands is in the form:

COMMAND

Description of command

Recommendation for when to use

Other information

ASQUEUED

Displays the mount point queue.

In order to use a drive, a client session or server process must first obtain a mount point. The mount point management on the server allows for queuing waiters for mount points if more mount points are needed than are available. Useful for determining the state of a mount point request especially if a session or process appears to be hung waiting for a mount point.

The syntax is SHOW ASQueued.

ASVOL

Displays assigned volumes.

As sequential media volumes are assigned for use by a session or a process, they are tracked in an in-memory list. Viewing this list is useful to determine the state of in-use volumes as well as hang or deadlock situations where a session or process appears to be stuck waiting for a volume or holding a volume and waiting for something else.

The syntax is SHOW ASVol.

BFOBJECT

Displays information about a bitfile object in the server storage hierarchy.

This command is useful to determine the existence and attributes of a bitfile object in the server's storage hierarchy. You might use this command if you are having trouble restoring, retrieving, expiring, or auditing the object.

The syntax is SHOW BFObject objID-high objID-low. objID-high and objID-low are the high-order and low-order 32-bit words of the 64-bit object id of the object being queried. The high-order word is optional; if not specified, a value of zero is assumed. The object can be a backup object, an archive object, a space-managed object, etc.

BUFSTATS

Displays usage statistics for the database buffer pool.

Useful for determining if the configured database buffer pool size is large enough.

The syntax is SHOW BUFStats.

BUFVARS

Displays database buffer pool global attributes.

Useful for determining if the configured database buffer pool size is large enough.

This may also be useful for diagnosing cases where the server is hung or when the server runs out of recovery log space. The database buffer pool performance and characteristics can influence the server's running out of recovery log space because the ability to write (flush) the changed pages to the database volumes can impact the ability of the recovery log to manage its space.

The syntax is SHOW BUFVars.

CONFIGURATION

A summary show command that actually issues many different show commands and queries.

Useful for providing a general configuration and other information about the server to IBM service.

The syntax is SHOW CONFIGuration.

DBTXNTABLE

Displays information about transactions that are performing database operations.

For transactions performing database operations, this command displays information about:

• Database tables that are open (in-use)
• Recovery log usage information such as the number of log records written and the recovery log space used
• The first, last, and next recovery log records written
• Whether or not a transaction is valid or being aborted (rolled back)

The syntax is SHOW DBTXNTable.

DBVARS

Displays database global attributes.

Useful for viewing the current state and attributes of the server database.

The syntax is SHOW DBVars.

DEVCLASS

Displays information about device classes.

Useful for displaying the states of allocated drives, device class attributes, and other information. Often used to diagnose problems with devices or hangs waiting for a drive, library, or volume. The command SHOW LIBRARY will also give good complementary information about drives and libraries.

The syntax for this command is SHOW DEVCLass.

GROUPLEADERS

Displays all backup group leaders for an object in the server's inventory.

This command is useful to determine the backup group relationships of an object in the server's inventory. You might use this command if you are having trouble restoring, retrieving, expiring, or auditing the object.

The syntax is SHOW GROUPLeaders objID-high objID-low. objID-high and objID-low are the high-order and low-order 32-bit words of the 64-bit object id of the object being queried. The high-order word is optional; if not specified, a value of zero is assumed. The object must be a backup object.
Only available in 5.2.3.0 or above.

Tsm Show Slots Command Cheat

GROUPMEMBERS

Displays all backup group members for an object in the server's inventory.

This command is useful to determine the backup group relationships of an object in the server's inventory. You might use this command if you are having trouble restoring, retrieving, expiring, or auditing the object.

The syntax is SHOW GROUPMembers objID-high objID-low. objID-high and objID-low are the high-order and low-order 32-bit words of the 64-bit object id of the object being queried. The high-order word is optional; if not specified, a value of zero is assumed. The object must be a backup object.
Only available in 5.2.0.0 or above.

INVOBJECT

Displays information about an inventory object in the server.

This command is useful to determine the existence and attributes of an object in the server's inventory. You might use this command if you are having trouble restoring, retrieving, expiring, or auditing the object.
As of 5.2.2.0, this command will report new information for archive retention protected objects. This command will report if the archive object is in deletion hold. If the object uses event-based retention, this command will report appropriately: if the Expiring.Objects row does not exist, then the object's event has not been signaled; if the basedate in the Expiring.Objects row is later than the insert date, then this is the date the object's event was signaled.

The syntax is SHOW INVObject objID-high objID-low. objID-high and objID-low are the high-order and low-order 32-bit words of the 64-bit object id of the object being queried. The high-order word is optional; if not specified, a value of zero is assumed. The object can be a backup object, an archive object, a space-managed object, etc.

LANFREE

A number of definitions are needed on the server in order for a given client to perform LAN-free data movement operations. In cases where these definitions are not present or are incorrect, it may be difficult to determine if the LAN-free environment is configured correctly.

Tsm Show Slots Command Block

In version 5.2.2 of the TSM server, the SHOW LANFREE command was added. This will evaluate all possible destination storage pools for this client node and report whether or not the storage pool is capable of LAN-free data movement operations.

The syntax is SHOW LANFREE nodeName storageAgent.

LIBINVENTORY

This command displays the current state of the library inventory for the library specified.

This command is useful if there seems to be a problem with the library inventory information. The command will display current in-memory properties of the library inventory.

The syntax is SHOW LIBINVentory libraryName where libraryName is optional, and if left out, the command will return the inventory information for all libraries.

LIBRARY

This command displays the current state of the specified library and all of its drives.

This command is useful to gather a quick view of all in-memory information about a library and its drives. This output should be gathered for any problem related to libraries or drives (e.g. mounting problems).

The syntax is SHOW LIBRary libraryName where libraryName is optional, and if left out, the command will return information for all the libraries.

LOCK

Displays lock holders and waiters.

The server and storage agent use locks as a mechanism to serialize access and updates to information and other constructs. Displaying this information is useful for diagnosing hangs or other resource contention issues.

The syntax is SHOW LOCK.

LOGPINNED

Evaluates and determines whether or not the server recovery log is pinned. A pinned recovery log may cause the recovery log to run out of space and possibly cause the server to crash.

This show command interrogates a number of server control structures and correlates the data to determine if a session, transaction, or process is pinning the recovery log. If it determines that something is pinning the recovery log, it will report this.

The syntax is SHOW LOGPInned. To recover from a pinned recovery log, issue 'SHOW LOGPInned Cancel' to cause the server to cancel or terminate the session, transaction, or process.
Only available in 5.1.7.0 or above.

LOGVARS

Displays recovery log global attributes.

Useful for determining the state of the recovery log.

The syntax is SHOW LOGVars.

MEMTREND

This command will report the memory used by the server, in megabytes, recorded at hourly intervals for the last 50 hours (this is a constant in the server code and is not user-configurable). The command will also display a histogram to help visualize the usage trend.

This command is useful to determine if the server has a memory leak. If the memory usage is constantly increasing, that might indicate a leak. Note that for the measurements to be valid, the measurement period (the last 50 hours) should represent normal, steady-state server activity. The reported usage represents the amount of memory internal server routines request from the pseudo-kernel memory routines. It does NOT represent the total amount of memory the server is using. Nevertheless, it is still useful in determining the server's memory usage trend.

The syntax is SHOW MEMTREnd.
Only available in 5.3.0.0 or above

MP

Displays mount points.

Useful for determining which volume is in-use by a given mount point and other attributes for the assigned mount points. SHOW LIBRARY and SHOW DEVCLASS have useful complimentary information with this command to display the current state of drives and current devclass mp counts.

The syntax is SHOW MP.

RESQUEUE

Displays the resource queue.

The resource queue is used to monitor common resources on the server. If a resource appears to be hung or holding a resource for an unreasonable amount of time, the resource monitoring algorithms for the server will take action and cancel or terminate the resource user. Typically, this is useful for displaying information about transactions, locks, and other resources used by a storage agent on the database server that it is configured to use.

The syntax is SHOW RESQueue.

Tsm Show Slots Command Bot

Tsm Show Slots Commands

SESSIONS

Displays information about sessions connected to the server or storage agent.

Useful for diagnosing hangs or other general session problems while a session is still connected to the server. This is also useful in cases where a session is cancelled or terminated and still appears in QUERY SESSION.

SHOW SESSions.

SLOTS

This command displays the current state of the specified library's slot information (e.g. which volumes are in the library and in which slots).

The information displayed is what was saved directly from the library hardware to in-memory values, and it can be used to determine if this information is out of sync, incorrect, or determine if the values returned from the library hardware itself are invalid.
Alternatively, this command can also be used to determine the drive element numbers for a SCSI library if QUERY SAN is unavailable for a particular library (e.g. 3570 library).

The syntax is SHOW SLOTS libraryName.

SSPOOL

Displays information storage pools.

Useful for displaying the states and attributes of defined storage pools.

The syntax is SHOW SSPool.

THREADS

Displays information about all threads known to the server.

The server will display information about each thread, typically including the TSM thread ID, the system thread id, the thread name, mutexes it holds (if any), and mutex or condition it is awaiting (if any). This command is platform-specific, so each platform may have slightly different information. You might use this command if the server or a particular server process appears to be hung, to see if there are threads waiting for resources held by another thread.

The syntax is SHOW THReads.
Note that on some platforms (e.g. HP), the information reported is obtained without serialization. On a busy system (one that is not hung), the information may be inconsistent: multiple threads may report holding the same mutex, or a thread may report that it is waiting on a mutex held by another thread that doesn't claim to hold it.

On TSM Server V5.3 for AIX, SHOW THReads displays a stack trace of each thread. A stack trace reveals information about the server, which can help developers and service diagnose problems. See examples below.

TOCSETS

Displays all Table Of Contents (TOC) sets known to the server.

A TOC set is used during file-level NDMP operations. During an NDMP backup with the TOC=YES parameter, a TOC is built in the server db. During a restore, one or more TOCs may be loaded into the server database in order to provide file and directory names to the client GUI. This command will display the status of the TOC set (e.g. building or loading), and how much temporary DB space is in use for each TOC set. You might use this command if you are having trouble doing an NDMP backup with the TOC=YES parameter, or having trouble restoring files from an NDMP backup, or if TOC sets are being retained in the server database too long or not long enough.

The syntax is SHOW TOCSets DELETE=setNum TOUCH=setNum. The DELETE parameter will cause the specified TOC set number to be deleted. The TOUCH parameter will update the last used date of the specified TOC set number. A TOC set will be retained for the TOC retention period following the last used date (see SET TOCRETENTION command).
Only available in 5.2.0.0 or above.

TOCVARS

Displays information about the Table Of Contents (TOC) component of the server.

This command is useful to determine the status of the toc component. You might use this command if you are having trouble doing an NDMP backup with the TOC=YES parameter, or having trouble restoring files from an NDMP backup.

The syntax is SHOW TOCVars.
Only available in 5.2.0.0 or above.

TXNTABLE

Displays information about transactions in-use on the server.

Transactions are used by server processes, sessions, or other operations to read information from the database, make updates to the database (such as insert, update, or delete information), or to manage locks. This information is useful for diagnosing hangs or other transaction related failures while the transaction is still open on the server.

The syntax is SHOW TXNTable.

VERIFYEXPTABLE

Performs verification of the Expiring.Objects table of the server.

This command is useful to find and clean up orphaned entries in the Expiring.Objects table (e.g. entries that don't have corresponding entries in the Backup.Objects or Archive.Objects tables). You might use this command if you are having trouble with inventory expiration.

The syntax is SHOW VERIFYEXPtable.
Make sure the IMEXP trace class is active.

VOLINUSE

Displays whether or not the volume specified is currently in the server's in-use list. This command will display additional information that may be helpful - including whether the volume is currently pending removal from the in-use list.

This command is useful to determine whether or not a volume is currently in the in-use list, and if necessary, this command can be used to remove it from that list. Note that operations associated with this volume might fail if it is removed from the in-use list.

The syntax is SHOW VOLINUSE volumeName. If the volume needs to be removed from the in-use list an additional parameter can be specified to remove the volume from the list: SHOW VOLINUSE volumeName REMOVE=YES.