by admin

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. Show slots Can be used to identify the status of all volumes in the library. There can be missing library volumes from the QUERY LIBVOLUME output when compared with the SHOW SLOTS output, because not all were checked in by TSM. Source: IBM documents: swg21609650, swg21214375, swg21652440 and internet forums. 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. Return to list of show commands. This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in Show Slots Command Tsm the cookie policy. If you want to know more or withdraw your consent to all or some of the cookies, please refer to the cookie policy. New with TSM 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.

Disclaimer

IBM provide the SHOW commands for their own use, for diagnostic gathering. Tivoli / IBM do not support the SHOW commands so it is no use raising problem reports with them if the results are not what you expect. 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 TSM database. If possible, try the commands on a test system before you use them in production. In general, you should not run SHOW commands unless you are familiar with that particular command, or TSM support personnel have asked you to run them.
This is not an exhaustive list of SHOW commands because
  • I do not know them all
  • I have missed out some obscure commands (that is, the ones that I don't understand)
The list is split into commands issued at the client and commands issued at the server.

Client 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
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.
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
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.
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 TIME
Simply displays the server date and time.
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 is worth running as a diagnostic data gathering exercise, to be analysed when free time permits.
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. 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.
Commands to help manage the database and recovery log
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
The above output shows that there are 10 dirty buffers. You use another undocumented command 'FLUSH' to clear out the dirty buffers.
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 LVM
This command shows logical volume manager data, including lots of information about TSM volumes.
SHOW LVMVOLS
Displays usage information for the recovery log and database .
Tsm
SHOW LVMCOPYTABLE
This command shows the status of the database and recovery log copy table and is included in SHOW LVM above.
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 TXN
Shows statistics for the transaction manager.
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 CANCELCommand
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 5.1.7.0 or above.
Example output is
The command tells you that the log is pinned by a backup.
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 Archives Policy-set Node-name
Shows archives for the specified node within a policy set
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. The only output I have ever seen for this command is
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. This command can be useful for diagnosing hangs or other transaction related problems, but the command produces a lot of output, and many of the fields are a bit obscure. Partial output for one single transaction is shown below.
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
The 0. 9041317 is the Object ID. If you use the SHOW command
Storage pool and LAN free 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
SHOW SLOTS
This command Will list out the total number of usable slots in a SCSI library. The Full command is
SHOW TRANSFERSTATS poolname
You use this command to get statistics from the last migration process, for example -
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.
SHOW OBJDIR
will display all the defined database object names, along with their numeric node identifier. Output looks like
Show NODE number
Will display details of one of these nodes
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 LIBRARY
A very useful command that shows the status of all 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

Tsm Show Slots Command Bot


polled; 1 means TSM can't use a drive, either because it has a problem, or because something else is using it

Tsm Show Slots Command Block

출처: http://www.lascon.co.uk/