Server SHOW commands

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 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 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.

SHow CSVars:

Shows client schedule variables and statistics.

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 LVM:

Shows logical volume manager info: server disk volumes.

SHow LVMCOPYTABLE:

Shows the LVM database and recovery log copy table status.

SHow LVMVOLS:

Shows database and recovery log volume usage.

SHOW MP:

Useful for determining which volume is in-use by a given mount point and other attributes for the assigned mount points.

SHow PENDing:

Shows pending administrative and client schedules.

SHow TIME:

Shows the current server date and time.

SHow TXN:

Shows Transaction manager statistics.