QUERY SESSION (Query client sessions)

Use this command to display information about administrative, node, and server sessions.

Privilege class

Any administrator can issue this command.

Syntax


>>-Query SEssion--+---------+----------------------------------->
                  '-sessnum-'   

>--+------------------------------+----------------------------->
   '-MINTIMethreshold--=--minutes-'   

>--+----------------------------------------+------------------->
   '-MAXTHRoughput--=--kilobytes_per_second-'   

   .-Format--=--Standard-----.  .-Type--=--*----------.   
>--+-------------------------+--+---------------------+--------->
   '-Format--=--+-Standard-+-'  '-Type--=--+-Admin--+-'   
                '-Detailed-'               +-Node---+     
                                           '-Server-'     

   .-CLIENTName--=--*---------------.   
>--+--------------------------------+--------------------------><
   '-CLIENTName--=----client_name---'

Parameters

sessnum

Specifies the number of the administrative or client node session to query. This parameter is optional. If you do not specify a value for this parameter, all sessions display.

MINTIMethreshold

Specifies to display sessions that had at least this number of minutes elapse from the time the client sent data to the server for storage. This parameter is optional. The minimum number of minutes is 1. The maximum number of minutes is 99999999.

MAXTHRoughput

Specifies to display sessions that are transferring data at a rate less than this number of kilobytes per second. This parameter is optional. The minimum number of kilobytes per second is 0. The maximum number of kilobytes per second is 99999999.

Format

Specifies how the information displays. This parameter is optional. The default value is STANDARD. The following values are possible:

Standard: Specifies that partial information displays for the session.
Detailed: Specifies that complete information displays for the session.

Type

Specifies the type of sessions to include in the query results. If you do not specify a value for this parameter, all types of sessions are queried. This parameter is optional. You can specify one of the following values:

Admin: Specifies that administrative sessions are displayed.
Node: Specifies that node sessions are displayed.
Server: Specifies that server sessions are displayed.

CLIENTName

Specifies the name of an administrator, client node, or server to be queried. You can specify one or more names. You can also specify node groups and proxy nodes. If you specify multiple names, separate the names with commas; use no intervening spaces. You can use wildcard characters with node names but not with node group names. The parameter is optional.

During node replication, the client name on the target server is displayed as node_name (server_name), where node_name is the node whose data is being replicated, and server_name is the name of the source server. You can specify either the node name or the server name in the CLIENTName parameter to display the replication sessions.

Example: List active client node sessions

Display information about all administrative and client node sessions that are communicating with the server. See Field descriptions for field descriptions.

query session

  Sess Comm.  Sess     Wait   Bytes   Bytes Sess  Platform Client
Number Method State    Time    Sent   Recvd Type           Name
------ ------ ------ ------ ------- ------- ----- -------- ------
    4  TCP/IP  Run    0 S    1.4 K    162   Admin  WinNT   ADMIN

Example: Display detailed information about active client node sessions

Display detailed information about all administrative and client node sessions that are communicating with the server. See Field descriptions for field descriptions.

query session format=detailed

              Sess Number: 4
             Comm. Method: Tcp/Ip
               Sess State: Run
                Wait Time: 0 S
               Bytes Sent: 1.4 K
              Bytes Recvd: 162
                Sess Type: Admin
                 Platform: WinNT
              Client Name: ADMIN
      Media Access Status:
                User Name:
Date/Time First Data Sent:
   Proxy By Storage Agent:
                  Actions:
            Failover Mode: No

Field descriptions

Sess Number

Specifies a unique session identification number that is assigned by the server.

Comm. Method

Specifies the method that is used by the client to communicate with the server.

Sess State

Specifies the current communications state of the server. The following states are possible:

End: The session is ending (session resources are released).
IdleW: Waiting for client's next request (session is idle).
MediaW: The session is waiting for access to a sequential access volume.
RecvW: Waiting to receive an expected message from the client.
Run: The server is running a client request (and not waiting to send data).
SendW: The server is waiting to send data to the client (waiting for data to be delivered to the client node that was already sent).
SSLiW: The session is waiting for Secure Sockets Layer (SSL) initialization to complete.
Start: The session is starting (authentication is in progress).

Wait Time

Specifies the amount of time (seconds, minutes, or hours) the server is in the current state shown.

Bytes Sent

Specifies the number of bytes of data that is sent to the client node since the session was initiated.

Bytes Recvd

Specifies the number of bytes of data that is received from the client node since the session was initiated.

Sess Type

Specifies the type of session in process: ADMIN for an administrative session, NODE for a client node session, or SERVER. SERVER specifies the server starts a session and initiates server-to-server operations such as central configuration, library sharing, and storage agent sessions.

Platform

Specifies the type of operating system that is associated with the client.

Client Name

Specifies the name of the client node or the administrator.

For node replication sessions, the client name is updated to node_name (server_name) on the target server after data transfer starts.

Media Access Status

Specifies the type of media wait state. When a session is in a media wait state, this field displays a list of all mount points and sequential volumes for the session. The list of mount points specifies the device class and the associated storage pool. The list of volumes specifies the primary storage pool volumes in addition to any copy storage pool and active-data pool volumes along with their assigned storage pool.

The server allows multiple sessions to read and one session to write to a volume concurrently in a storage pool that is associated with the FILE or CENTERA device type. As a result, a volume in a storage pool with a device type of FILE or CENTERA can appear as the current volume for more than one session.

Proxy by Storage Agent

Specifies the storage agent that is the proxy for LAN-free data movement for the node.

User Name

Specifies the user ID of the node, on a multi-user system, that connects to the server when it is not the same system user who originally connected to the server.

Date/Time First Data Sent

Specifies the date and time that the client first sent data to the server for storage.

Actions

Displays a list of actions that are performed during the session. An action is listed only once, even if the action occurs multiple times during a session. The following actions are possible:

BkIns: One or more backup objects were stored on the server. The operation might have been an incremental backup or a selective backup.
BkUpd: One or more attributes were updated for a backup object that is stored on the server.
BkDel: One or more backup objects that are stored on the server are deleted.
BkRebind: One or more backup objects that are stored on the server are bound to a different management class.
NoQueryRestore: A no-query restore operation was initiated from the client to restore backed-up files from the server to the client system.
ArIns: One or more archive objects were stored on the server.
ObjRtrv: One or more files were retrieved from the server. This might have been to retrieve archive files, or to restore backup data (except for backup data from a no-query restore operation).
MigIns: One or more files are migrated and stored on the server by Tivoli® Storage Manager for Space Management (HSM client).
MigDel: One or more space-managed files that were stored on the server are deleted.
MigRebind: One or more space-managed files that are stored on the server are bound to a different management class.
MigRecall: One or more space-managed files that are stored on the server are recalled.
MigUpd: The attributes for one or more space-managed files that are stored on the server are updated.
FSAdd: The client node added one or more new file spaces to server storage.
FSUpd: The client node updated attributes for one or more file spaces that are defined to the server.
DefAuth: A SET ACCESS command is processed by the client node, which caused an authorization rule for access to the client node's data to be added.

Failover Mode

Specifies whether the client session was started in failover mode. The following values are possible:

Force: The FORCEFAILOVER flag is specified on the client and the session is forced into failover mode.
Yes: The client session was started in failover mode.
No: The client session was not started in failover mode.

Related commands

Table 1. Command related to QUERY SESSION
Command	Description
CANCEL SESSION	Cancels active sessions with the server.