Tivoli Storage Manager for Windows Administrator's Guide


Using Tivoli Storage Manager Queries to Display Information

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.

Note:For information about creating customized queries of the database, see Using SQL to Query the Tivoli Storage Manager Database.

Requesting Information about Tivoli Storage Manager Definitions

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

Requesting Information about Client Sessions

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 70 shows a sample client session report.

Figure 70. 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:

Start
Connecting with a client session.

Run
Running a client request.

End
Ending a client session.

RecvW
Waiting to receive an expected message from the client while a database transaction is in progress. A session in this state is subject to the COMMTIMEOUT limit.

SendW
Waiting for acknowledgment that the client has received a message sent by the server.

MediaW
Waiting for removable media to become available.

IdleW
Waiting for communication from the client, and a database transaction is NOT in progress. A session in this state is subject to the IDLETIMEOUT limit.

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.

Requesting Information about Server Processes

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 71 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 71. Information about Background Processes

+--------------------------------------------------------------------------------+
| Process Process Description      Status                                        |
|  Number                                                                        |
|-------- ------------------------ --------------------------------------------- |
|       2 DELETE FILESPACE         Deleting filespace DRIVE_D for node CLIENT1:  |
|                                   172 files deleted.                           |
|                                                                                |
+--------------------------------------------------------------------------------+

Requesting Information about Server Settings

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:

Querying Server Options


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 through the Tivoli Storage Manager Server Utilities or by editing the server options file. See Administrator's Reference.

Querying the System

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:

QUERY ASSOCIATION
Displays all client nodes that are associated with one or more client schedules

QUERY COPYGROUP
Displays all backup and archive copy groups (standard format)

QUERY DB
Displays information about the database (detailed format)

QUERY DBVOLUME
Displays information about all database volumes (detailed format)

QUERY DEVCLASS
Displays all device classes (detailed format)

QUERY DOMAIN
Displays all policy domains (standard format)

QUERY LOG
Displays information about the recovery log (detailed format)

QUERY LOGVOLUME
Displays information about all recovery log volumes (detailed format)

QUERY MGMTCLASS
Displays all management classes (standard format)

QUERY OPTION
Displays all server options

QUERY PROCESS
Displays information about all active background processes

QUERY SCHEDULE
Displays client schedules (standard format)

QUERY SESSION
Displays information about all administrative and client node sessions in standard format

QUERY STATUS
Displays general server parameters, such as those defined by SET commands

QUERY STGPOOL
Displays information about all storage pools (detailed format)

QUERY VOLUME
Displays information about all storage pool volumes (standard format)

SELECT
Displays the results of two SQL 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]