IBM provide the SHOW commands for their own use, for diagnostic gathering, and can be used to look at run time activities like in-memory control structures. Be aware that some of these commands are resource intensive and cannot be cancelled and some commands will try to fix problems; that is they may UPDATE the Spectrum Protect database. IBM Stated that "The SHOW commands must be used only with the recommendation of IBM Software Support." If you want to run these commands yourself, then if possible, try the commands on a test system before you use them in production. Do not use wild card with any of the show commands, it will crash the TSM Server. In general, you should not run SHOW commands unless you are familiar with that particular command, or Spectrum Protect support personnel have asked you to run them.
Many of the older show commands are now official, as they have equivalent 'display' or 'validate' commands.
The list is split into 6.x and upwards commands issued at the client, 6.x and upwards commands issued at the server and 5.x commands.
Client commands can produce a lot of output that will scroll off the screen, so you may prefer to pipe them into a file. For example SHOW OPTTABLE > output.txt
- SHOW OPTIONS
- Displays the active client options.
- SHOW OPTTABLE
- You can configure a client so it can get its option settings from either the client option file or from the server. This command will tell you which one is in use for this client.
- SHOW SESSION
- Issue this command to diagnose stoppages or other general session problems while a session is still connected to the server. This command is also useful in cases where a session is canceled and is still shown in the QUERY SESSION.
- SHOW TRACEFLAGS
- Use this to determine which trace options could be used for this client.
- SHOW VERSION
- Use this command to find out what release and version of TSM is installed.
- SHOW DOMAIN
- Use this command to display information and summarise the DOMAIN, DOMAIN.IMAGE, and DOMAIN.NAS client options.
- SHOW CLUSTER
- Displays information about the disk mappings in a Windows or a Netware Cluster.
The next five commands all apply to Windows clients
- SHOW PLUGINS
- If you want to use extra capabilities like image backup, then they are provided by 'plug-ins'. You use this command to find out what plug-ins are available for this client.
- SHOW CACHE
- Spectrum Protect uses Subfile backups to backup only changed portions of files over slow network links. Spectrum Protect knows what parts of a file have changed, by storing checksum information in a cache file on the client. This command will display information about the subfile cache, if the client is configured to use subfile backup.
- SHOW SYSTEMSTATE
- You use this commands to find out which VSS writers are installed and will be used for Spectrum Protect backups.
- Displays the SYSTEM SERVICES data that is available on this client.
Useful to determine which SYSTEM SERVICES files are installed on this Windows client and those that could be backed up.
- SHOW TIME
- Simply displays the server date and time.
Current Date and Time on the Server
UTC (GMT) Date/Time is: 04/17/2012 10:08:08
Last Noted Date/Time is: 04/17/2012 10:45:51
Daylight Savings Time is in effect: YES
- SHOW CONFIG
- This is one of the long running commands that produce lots of output. It actually issues a set of QUERY and SHOW commands then uses these to build a quite comprehensive picture of the state of the server. This command could be worth running as a diagnostic data gathering exercise in a problem situation.
- SHOW PENDing
- Use this command to see pending administrative and client schedules. The output shows the schedule name, the node it will be run against, and the schedule time.
- SHOW DB2CONNECTIONS
- Use this command to show how many DB2 connections are defined, in-use, and free in total and within a particular pool.
- SHOW DB2TABLES
- Use this command to show the registered tables and their column attributes.
- SHOW DBVARS
- Use this command to view the current state and global attributes of the server database.
Object aggregation allows Spectrum Protect servers to optimise server internal data movement operations.
- SHOW AGGREGATE aggrID-high aggrID-low
- Shows information about an aggregate object in the server storage hierarchy.
If you have problems restoring or retrieving files, expiring or moving data, backing up primary storage pools, copying active data to active data pools, or auditing volumes, you might see an aggregate ID in the error message.
aggrID-high and aggrID-low are the high-order and low-order 32-bit words of the 64-bit aggregate ID of the aggregate that is being queried.
The output will tell you which logical files that are stored in the aggregate object, including the offset, length, and active state of backup files within the aggregate.
You might find the next 3 commands useful if you have problems restoring, retrieving, expiring, or auditing an object.
- SHOW BFOBJECT
- The commaand will tell you:
The active/inactive state of logical files within an aggregate
The offset/length of logical files within an aggregate
The active state or owner bitfile ID of logical files within an aggregate
The link bitfile ID if the deduplicated extent is linked to another extent
- SHOW GROUPLEADERS objID-high objID-low
This command will show all backup group leaders for a backup object in the server inventory. objID-high and objID-low are the high-order and low-order 32-bit words of the 64-bit object ID of the object that is being queried.
- SHOW GROUPMEMBERS objID-high objID-low
This command will show all backup group members for an backup object in the server inventory. objID-high and objID-low are as above, and for both commands, if the high-order is not specified, a value of zero is assumed.
Commands to help with session or tape drive problems
- SHOW ASQUEUED
- If you have a client session or process stuck, it may be waiting for a drive. You can use this command to see if there are sessions queued waiting
for mount points.
- SHOW DEVCLASS
- Is also useful if you have problems with drives, libraries or volumes. It displays the status of each device class, including the status of allocated drives.
- SHOW MP
- 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 complementary information with this command to show the current state of drives and current devclass mount point counts.
- SHOW ASVOL
- If you are having problems with sessions or processes queued, or waiting for tape volumes, then this command will display the in-memory list of assigned volumes.
- SHOW SLOTS
- This command will list out the total number of usable slots in a SCSI library. The Full command is
SHOW SLOTS libraryname
You can use this command to make sure that all your tapes are checked into your tape library. Start with the command below, where LIBRARY_NAME is your library name.
select count(*) from libvolumes where library_name='LIBRARY_NAME'
If the number this command produces looks to be too low, you can use the SHOW SLOTS LIBRARY_NAME 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 library_name
- The library name is optional, if it is missed off the all libraries are seleted.
A very useful command that shows the in-memory status of libraries attached to a server, and all their drives. Some of the parameters include
busy; either 1 (busy) or 0 (not),
online; 0 means a drive is offline
polled; 1 means TSM can't use a drive, either because it has a problem, or because something else is using it
- SHOW LIBINVENTORY libraryname
- You would use this command if you think you may have a problem with the library inventory information, as the command shows the current in-memory properties of the library inventory. If the library name is not specified, then the command returns the inventory information for all libraries.
Commands to help manage the database and recovery log
- SHOW CSVARS
- This command shows client and admin schedule variables and statistics. An example is
- SHOW PEND
- Displays the next execution time for client and admin schedules.
- SHOW DBTXNT
- Use this command to displays the database transaction table. Sample output looks like
This is showing that this transaction has 4 database tables open, that the transaction is valid, and that it is not writing log records.
- SHOW TXNTable
- Shows statistics for the transaction manager. This command can be used to find which thread or process is using excessive database locks. Start from the DB2 command line (the database section tells you how to open this) and run command
$ db2 get snapshot for all applications > snapshot.txt
Then from the DB2 command line run
SHOW TXNT > txnt.txt
Now search the snapshot.txt file for string 'Locks held by application' and look for an application that is holding a lot of locks, 1,000,000 or more could be considered excessive. When you find one, look up from this line a bit for a line that looks like
Application handle = 2109
Now check out your txnt.txt line, searching for '2109'. You should find the relevant application handle in there, in a section that looks like
Tsn=0:2142362, Resurrected=False, InFlight=True, Distributed=False, Persistent=True, Addr 13528572
Start ThreadId=49, Timestamp=11/07/15 09:24:42, Creator=bfdedup.c(10369)
Last known in use by ThreadId=47
EndInFlight False, endThreadId 0, tmidx 0, processBatchCount 0, mustAbort False.
Participant DB: voteReceived=False, ackReceived=False
DB: Txn 122590f32, ReadOnly(NO), connP=135220d04, applHandle=2109, openTbls=0:
DB: --> RegSqlId=0x0100003D INSERT for table=BF.Queued.Chunks, executed(Yes).
DB: --> RegSqlId=0x0100003E DELETE for table=BF.Dereferenced.Chunks, executed(No).
you can see that this process is running a DELETE on the table BF.Dereferenced.Chunks. This is part of the file expiration process, so you can either run file expiration more frequently to reduce the number of de-referenced chunks being processed in one operation, or you could increase the database lock list. IBM technote http://www-01.ibm.com/support/docview.wss?uid=swg21430874 explains how to do this.
- SHOW DBV
- Displays database global attributes.
- SHow DBBACKUPVOLS
- Use this command to get details on the latest full and incremental database backup volumes.
- SHOW Archives Policy-set Node-name
- Shows archives for the specified node within a policy set
- SHOW MEMTREND
- You might use this command to determine if the server has a memory leak, as the MEMTREND command reports the memory that is used by the server, in megabytes. It is recorded at hourly intervals for the last 50 hours. The command also shows a histogram to help visualize the usage trend.
If the memory usage is constantly increasing, a memory leak might have occurred. For the measurements to be valid, the measurement period (the last 50 hours) must be normal, steady state server activity. The reported usage represents the amount of memory that internal server routines request from the pseudo-kernel memory routines. It does NOT represent the total amount of memory that the server is using.
- SHOW VOLINUSE volumeName REMOVE=YES
- Use this command to see whether the volume specified is in the server's in-use list. The command output can tell you if the volume is pending removal from the in-use list.
If you need to, you cna manually remove the volume from the in-use list with the REMOVE=YES parameter, but this might cause some operations to fail, if they need that volume.
Commands to help with session hangs
- SHOW TOCVARS
- You might use this command if you want to know the status of the TOC component, maybe because you are having problems completing an NDMP backup with the TOC=YES parameter, or have problems restoring files from an NDMP backup.
- SHOW LOCK
- If your Spectrum Protect server is running very slow it is worth trying this command. A TSM server uses locks to serialise updates to prevent corruption. You use this command to see what resources are locked.
- SHOW RESQUEUE
- The Spectrum Protect server monitors resource usage and will cancel any resource users that are holding onto resources for too long. You use the SHOW RESQUEUE command to display the resource queue and it will display information about transactions, locks, and other resources. The only output I have ever seen for this command is
RESOURCE Timeout is 60 minutes.
Resource list is unlocked.
There are current no waiters.
- SHOW SESSION
- 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.
*** Warning *** The SHOW SESSION command can crash a Spectrum Protect server that is between code levels 5.5 and 6.3 IBM Technote swg1IC82490 refers
- SHow INVObject 0 ObjectId
- Use this command to show an inventory object, reporting its nodename, filespace, management class, whether the archive object is in deletion hold, whether the object uses event-based retention and more. This command can be useful if you get errors with objects. For example, when exporting a server you may see a message like
ANR9999D xibf.c(664): Return code 87 encountered in writing object 0.9041317 to export stream.
ANR0661E EXPORT SERVER: Internal error encountered in accessing data storage.
The 0. 9041317 is the Object ID. If you use the SHOW command
SHow INVObject 0 9041317
The result below will tell you what the object is
OBJECT: 0. 9041317 (Backup):
Node: ACSN08 Filespace: /y2. /msg/rlds/ temp
Type: 2 CG: 1 Size: 0.0 HeaderSize: 0
BACKUP OBJECTS ENTRY:
State: 1 Type: 2 MC: 1 CG: 1
/y2 : / msg/rlds/ temp
This (MC: DEFAULT)
Active, Inserted 08/01/03 07:58:58
EXPIRING OBJECTS ENTRY:
Expiring object entry not found.
- SHOW OBJDIR
- will display all the defined database object names, along with their numeric node identifier. Output looks like
Defined Database Object Names (Home Address):
Administrative.Attributes(37), Administrators(40), etc..
Storage pool and LAN free and library commands
- SHOW SSPOOL
- Useful for displaying the states and attributes of defined storage pools.
- SHOW DAMAGED poolname
- Contributed by Roy Adeyosoye, This command will list out all the files in a storage pool that are marked as damaged. Typical output looks like
Volume ID: 34281, Volume Name: QZ1720
Segment number: 1, Segment start: 1606,
Segment Size: 0.85470464
Found 4349 damaged bitfiles.
To fix them, run an audit command like
AUDIT VOL QZ1720 FIX=YES
- SHOW SDPOOL
New with Spectrum Protect 7.1.3, use this command to check on the free space position in a directory-container storage pool. A QUERY STGPOOL command will show the free space in the pool including freespace within allocated containers. This show command splits that free space up into free space within the file system and within the containers. Typical output is:
SD Pool PTFM-VE (25):
Needs Refresh: False
Maximum Size: 0
FsCapacity: 109025280 MB
FsFreeSpace: 0 MB
CntrAllocSpace: 108980607 MB
CntrUsedSpace: 72545862 MB
CntrFreeSpace: 36434745 MB
PoolCapacity: 08980607 MB
PoolFree: 36434745 MB
Reserved Space: 0 MB
Last Space Check: 01/13/16 14:38:12
- SHOW TRANSFERSTATS poolname
- You use this command to get statistics from the last migration process, for example -
SHOW TRANSFERSTATS BACKUPPOOL
Statistics for last migration from pool BACKUPPOOL
Start date/time: 05/26/04 02:30:21
Elapsed time: 24128 seconds
Total wait time: 17232 seconds
Number of participating processes: 2
Total duration of all processes: 48169 seconds
Total physical files: 11934
Total logical files: 316992
Total bytes: 273999794176
Average logical files per physical file: 26.6
Average physical file size: 22421.5 KB
Number of batch/file transactions ended: 782
Number of batch transactions aborted: 0
Number of file transactions started: 0
Number of file transactions aborted: 0
- SHOW LANFREE nodeName storageAgent
- This command was added with TSM version 5.2.2. It will check out all possible destination storage pools for a given client node and tell you if this storage pool can support LAN-free backup and restore.
It has been superceded by the official 'validate LANFREE nodeName storageAgent' command.
- Show NODE number
- Will display details of one of these nodes
Show Node 49
B-Tree ROOT node: PageAddr=49, Lsn=121563.242.2284, ObjName=Activity.Log
LeftSib=-1, RightSib=-1, Continuation=-1
NumRecs=2, Free=994, NextSlot=163, DirOff=0, PartKeyLen=0
Level=2, NumCols=19, KeyCols=2, PartCols=0, NodeAttr=80
MaxCapacity=1004, Capacity=1004, Occupancy=10, LowOccupancy=334
Record 0 (KeyLen=9, DataLen=4):
Key: ->(,.....)(002D)< -
Record 1 (KeyLen=2, DataLen=4):
Key: ->(+Infinite)(+Infinite)< -
- SHOW TREE tree.name
gives details about the data in a tree
- SHOW VERIFYEXPTABLE
This command used to be used to fix problems where data is not being expired correctly. It has now been replaced by the command CLEANUP EXPTABLE [BEGINNODE=nn ENDNODE=NN]. You must discuss and agree with IBM before running this command, as it updates your database. Once you start this command it cannot be cancelled, and will prevent EXPIRE INVENTORY from running.
- SHOW VERSIONS
- The Syntax of the command is
Show Versions nodename filespace_name HL_name LL_name
Where the HL_name and LL_name are optional and represent the directory path and filename.
This command shows the status of a file backup (active or inactive) the date it was created, the date it went inactive and other data. If the inactive date is 'Deactivated 1900-01-01 00:00:00.000000' then this backup has been marked as ready for deletion and will be deleted next time expiration runs.
The following 3 commands came from the site belonging to Michael Malitz, http://www.mm-it.at/de/TSM_Show_Commands.html
- SHOW DEDUPDELETEINFO
- Displays the status of background deletion threads for dereferenced deduplicated objects. Issue this command to check the status of the background deletion process for deduplicated objects. When a file is deleted or moved out of a deduplicated storage pool, the extents are queued to a background processor for attempted removal from the storage pool. This command is useful for checking the backlog of queued extents and the status of each deletion thread.
- SHOW DEDUPPENDING stg-pool-name
- Shows the pending amount of data that will be removed.
- SHOW DEDUPOBJECTobjectid
- Use this command to see data deduplication information for files. Issue the SHOW VERSION command to determine the value of the objectid. The information returned includes:
The bit file ID for each extent
The owning bit file ID
The offset and length of the owning bit file
The digest type and value of the data deduplication object
- SHOW REPLICATION
- Shows all known replication servers and their globally unique identifier (GUID) and all running replication processes. The processes might include the individual statistics of each file space and the status of each replication session. Issue this command if replication does not appear to be progressing or if replication is not working correctly.
- SHOW VERSIONHISTORY
- Displays the installed TSM version(s) on the TSM server.
- SHOW TOCSETS
- You might run this command if you are having problems with NDMP backups or restores. If you run an NDMP backup with the TOC=YES parameter, a TOC is built in the server database. During a restore, one or more TOCs might be loaded into the server database to provide file and directory names to the client GUI. This command shows the status of the TOC set; for example, building or loading, and how much temporary database space is in use for each TOC set.
The command has two optional parameters: DELETE=setNum TOUCH=setNum.
You would use the DELETE parameter on advice from Spectrum Support, if the TOCSET has been retained incorrectly and is causing problems.
A TOC set is retained for the TOC retention period that follows the last used date. The TOUCH parameter updates the last used date so that particular TOC set is retained for longer.
- SHOW VM ALL
- show all virtual machines in ESX(I) or vCenter from the DSMC - BA Client point of view.
- SHOW THREADS
- You might want to issue this command to investigate why a server or a particular server process is stopped. It will tell you whether there are threads waiting for resources that are held by another thread. The server displays information about each thread, typically including the IBM Spectrum Protect thread ID, the system thread id, the thread name, mutexes it holds (if any), and mutex or condition it is awaiting (if any).
The information presented differs between platforms. On some operating systems the information that is reported is obtained without serialization so the information returned might be inconsistent.
I'v never tested these commands, so they are supplied on good faith, no idea if they work or not
- SHOW NASDEV
- Shows the SCSI devices that are attached to a network-attached storage (NAS) file server that is associated with a NAS datamover definition. I suspect this command needs 2 parameters, a NAS node and datamover.
- SHOW NASFS
- Show the file systems on a NAS file server that is associated with a NAS datamover definition. Any file systems that are shown might be backed up by IBM Spectrum Protect. Again, I suspect this command needs 2 parameters, a NAS node and datamover.
- SHOW NASINFORMATION
- Shows configuration information about the NAS file server that is associated with a NAS datamover definition. This command is useful for identifying basic communication problems with NAS file servers such as authentication errors. Again, I suspect this command needs 2 parameters, a NAS node and datamover.
- SHOW NASWORKLOAD
- Shows the workload of backend data movement and backup and restore operations for NAS files that are used for all IBM Spectrum Protect operations.
TSM 5.x SHOW COMMANDS
- SHOW LOGPINNED
- You can use this command if your logfile is running out of space. The oldest active record in the log is 'pinning' the log. This command will tell you what task owns that oldest record. You could follow this up with
SHOW LOGPINNED CANCEL
which will cancel whatever is holding the pinned record. This is one of those 'UPDATE' SHOW commands that you need to use with extreme care, and preferably after advice from Tivoli. However, if your log is rapidly filling up, will you have time to make that support call? It would be best to investigate and test this command before you need to use it in an emergency. The command is only available in TSM version 18.104.22.168 to 5.5.
Example output is
Dirty page Lsn=4597153.124.2199, Last DB backup Lsn=4596680.43.3348,
Transaction table Lsn=4597152.240.3249, Running DB backup Lsn=0.0.0,
Log truncation Lsn=4596680.43.3348
Lsn=4596680.43.3348, Owner=DB, Length=194
Type=Update, Flags=C2, Action=ExtInsert, Page=2171054,
Tsn=0:818261705, PrevLsn=4596680.43.3137, UndoNextLsn=0.0.0,
UpdtLsn=4596680.43.3137 ===> ObjName=AS.Segments, Index=26,
RootAddr=14, PartKeyLen=3, NonPartKeyLen=4, DataLen=87
The recovery log is pinned by the last data base backup.
Space will not be freed until data base backup is run again.
The command tells you that the log is pinned by a backup.
- SHOW BUFSTATS
- Use this command to see if you need to increase your database buffer pool size.
Example output is
- SHOW BUFVARS
- This command will display the status of the buffer pool variables and can be used to check for dirty buffer pages.
Example output is
Database buffer pool global variables:
CkptId=1642081, NumClean=32880, MinClean=32784, NumTempClean=32880,
BufPoolSize=32880, BufDescCount=33071, BufDescMaxFree=36168,
DpTableSize=49161, DpCount=0, DpDirty=10, DpCkptId=1642081,
DpCursor=64, NumEmergency=0 CumEmergency=0, MaxEmergency=0.
BuffersXlatched=0, xLatchesStopped=False, FullFlushWaiting=False.
The above output shows that there are 10 dirty buffers. You use another undocumented command 'FLUSH' to clear out the dirty buffers.
- SHOW LVMVOLS
- Displays usage information for the recovery log and database
- SHOW LVMCOPYTABLE
- This command shows the status of the database and recovery log copy table and is included in SHOW LVM above.
- SHOW LVM
- This command shows logical volume manager data, including lots of information about TSM volumes.
back to top