TSM SHOW COMMANDS

  Home       SQL for TSM      SHOW COMMANDS        TIVOLI KNOWLEDGE BASE      CONTACT

Show commands

Below are the more or less hidden TSM show commands. More or less, because Tivoli Support lately is spreading the word that they exist and some of them are even mentioned in TSM documentation. They are splitted in TSM client and TSM Server commands, and all are verified and tested on TSM Client 5.2.3.4 and TSM Server 5.3.2.3.

Client commands:

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
Displays capabilities that this client has for this connection to the server. The client and server report and negotiate the capabilities that each has when a session is started by a client to a server. This show command reports the capabilities available by this server and client.

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. Because (as you may have noticed) the TSM version info after running dmsc is from the server, not the client.

SHOW CLUSTER
Displays information about the disk mappings in a Windows or a Netware Cluster.


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
TSM uses Subfile backups to backup only changed portions of files over slow network links. TSM 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.

The options below only applies to Windows OS:

SHOW SYSTEMOBJECT / SHOW SYSTEMSTATE
You use these commands to find out what system facilities are installed, and which ones can be backed up with TSM. SYSTEMOBJECT is used for Windows 2000 and XP clients, and SYSTEMSTATE for Windows 2003 clients.
SYSTEMSERVICES
For Windows 2003 clients, 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.

Server commands:

SHOW CONFIG
This issues a set of QUERY and SHOW commands and then uses these to build a quite comprehensive picture of the state of the server.

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. 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 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 BUFSTATS
Use this command to see if you need to increase your database buffer pool size.

SHOW BUFVARS
This command will display the status of the buffer pool variables and can be used to check for dirty buffer pages.
You use another undocumented command 'FLUSH' to clear out the dirty buffers.

FLUSH
This causes a database buffer write to flush, which would be used to
test for buffer-writer starvation.  Use this command when SHOW BUFVARS has
a dpDirty (dirty pages) value in the thousands.  Then check log
utilization to see if it freed things up.

SHOW DBTXNT
Use this command to displays the database transaction table.

SHOW DBV
Displays database global attributes.

SHOW DBBACKUPVOLS
Use this command to get details on the latest full and incremental database backup volumes.

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.

SHOW LOGV
You can use this command to display the recovery log global attributes, but it is less obvious what they all mean.

SHOW LOGstats
Use this command to see statistics on log usage.
An associated command is SHOW LOGRESET This command will RESET the log statistics back to 0.

SHOW LOCK
If your TSM 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 TSM 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.


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.

SHOW TXNT
You use this command to get information about active server transactions. Transactions are the low level operations that actually read or update the database.

SHow INVObject 0 ObjectId
Use this command to show an inventory object, reporting its nodename, filespace, management class, 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 SSPOOL
Useful for displaying the states and attributes of defined storage pools.

SHow DAMAGED poolname 
This command will list out all the files in a storage pool that are marked as damaged. Typ
Volume ID: 34281, Volume Name: QZ1720
  Segment number: 1,  Segment start: 1606,
  Segment Size: 0.85470464
  file_name
  etc....
   Found 4349 damaged bitfiles.

To fix them, run an audit command like

AUDIT VOL QZ1720 FIX=YES

SHOW TRANSFERSTATS poolname
You use this command to get statistics from the last migration process, for example -
SHOW TRANSFERSTATS BACKUPPOOL