![]() |
![]() |
Tivoli Storage Manager provides a variety of QUERY commands that display formatted information about definitions, settings, processes, and status. In some cases, you can display the information in either of two formats: standard or detailed. The standard format presents partial information and is useful in displaying an overview of many objects.
During TSM system setup, an administrator can define many objects. These objects include storage management policies, database and recovery log volumes, storage pools, and device classes. Tivoli Storage Manager provides queries that display information about these objects.
Most of these definition queries let you request standard format or detailed format. Standard format limits the information and usually displays it as one line per object. Use the standard format when you want to query many objects, for example, all registered client nodes. Detailed format displays the default and specific definition parameters. Use the detailed format when you want to see all the information about a limited number of objects.
Here is an example of the standard output for the QUERY NODES command:
+--------------------------------------------------------------------------------+ |Node Name Platform Policy Days Days Locked? | | Domain Since Since | | Name Last Password | | Access Set | |---------- -------- --------- ------ -------- ------- | |CLIENT1 (?) STANDARD 6 6 No | |GEORGE OS/2 STANDARD 1 1 No | |JANET (?) STANDARD 1 1 No | |JOEOS2 OS/2 STANDARD <1 <1 No | |TOMC (?) STANDARD 1 1 No | +--------------------------------------------------------------------------------+
Here is an example of the detailed output for the QUERY NODES command:
+--------------------------------------------------------------------------------+ | Node Name: JOEOS2 | | Platform: OS/2 | | Policy Domain Name: STANDARD | | Last Access Date/Time: 05/19/2000 09:59:52 | | Days Since Last Access: 2 | | Password Set Date/Time: 05/18/2000 11:04:45 | | Days Since Password Set: 3 | | Invalid Password Limit: | | Minimum Password Length: | | Locked?: No | | Contact: | | Compression: No | | Archive Delete Allowed?: Yes | | Backup Delete Allowed?: No | | Registration Date/Time: 05/18/2000 11:04:45 | | Registering Administrator: OPEN_REGISTRATION | |Last Communication Method Used: Tcp/Ip | | Bytes Received Last Session: 226 | | Bytes Sent Last Session: 556 | |Duration of Last Session (sec): 3.32 | | Pct. Idle Wait Last Session: 88.48 | | Pct. Comm. Wait Last Session: 6.63 | | Pct. Media Wait Last Session: 0.00 | +--------------------------------------------------------------------------------+
When administrators or users access Tivoli Storage Manager, an administrative or client node session is established with the server. The server assigns each client session a unique session number.
To request information about client sessions, enter:
query session
Figure 59 shows a sample client session report.
Figure 59. Information about Client Sessions
+--------------------------------------------------------------------------------+ | Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name | |Number Method State Time Sent Recvd Type | |------ ------ ------ ------ ------- ------- ----- -------- -------------------- | | 3 Tcp/Ip IdleW 9 S 7.8 K 706 Admin OS/2 TOMC | | 5 Tcp/Ip IdleW 0 S 1.2 K 222 Admin OS/2 GUEST | | 6 Tcp/Ip Run 0 S 117 130 Admin OS/2 MARIE | | | +--------------------------------------------------------------------------------+
Check the wait time and session state. The wait time determines the length of time (seconds, minutes, hours) the server has been in the current state. The session state can be one of the following:
For example, Tivoli Storage Manager cancels the client session if the IDLETIMEOUT option is set to 30 minutes, and a user does not initiate any operations within those 30 minutes. The client session is automatically reconnected to the server when it starts to send data again.
Most commands run in the foreground, but others generate background processes. In some cases, you can specify that a process run in the foreground. TSM issues messages that provide information about the start and end of processes. In addition, you can request information about active background processes. If you know the process ID number, you can use the number to limit the search. However, if you do not know the process ID, you can display information about all background processes by entering:
query process
Figure 60 shows a server background process report after a DELETE FILESPACE command was issued. The report displays a process ID number, a description, and a completion status for each background process.
Figure 60. Information about Background Processes
+--------------------------------------------------------------------------------+ | Process Process Description Status | | Number | |-------- ------------------------ --------------------------------------------- | | 2 DELETE FILESPACE Deleting filespace DRIVE_D for node CLIENT1: | | 172 files deleted. | | | +--------------------------------------------------------------------------------+
Any administrator can request general server information, most of which is defined by SET commands. To request this information, enter:
query status
The displayed information includes:
Task | Required Privilege Class |
---|---|
Query server options | Any administrator |
Use the QUERY OPTION command to display information about one or more server options.
You can issue the QUERY OPTION command with no operands to display general information about all defined server options. You also can issue the QUERY OPTION command with a specific option name or pattern-matching expression to display information on one or more server options.
To display general information about all defined server options, enter:
query option
You can set options by editing the server options file. See Administrator's Reference for more information.
The QUERY SYSTEM command lets you combine multiple queries of your Tivoli Storage Manager system into a single command. This command can be used to collect statistics and to provide information for problem analysis by IBM service. When you issue the QUERY SYSTEM command, the server issues the following queries:
select platform_name,count(*) from nodes group by platform_name
select stgpool_name,devclass_name,count(*) from volumes group by stgpool_name,devclass_name
The first command displays the number of client nodes by platform.
The second command displays the name and associated device class of all storage pools having one or more volumes assigned to them.