Storage Viewer for Backup Database Views > apt_v_tsm_session
  
Version 10.0.01
apt_v_tsm_session
The apt_v_tsm_session view provides TSM session details.
Table 3.172 apt_v_tsm_session
Column Name
Data Type
Description
instance_name
STRING
Server instance name
is_active
STRING
Y=Yes, N=No
job_id
NUMBER
Foreign key to apt_v_tsm_job. Unique job ID. Primary key in this view. This is the Storage Viewer internal job ID and NOT the same as the TSM Job ID.
kilobytes_recd
NUMBER
Number of kilobytes received during the session.
kilobytes_send
NUMBER
Number of kilobytes sent during the session
node_id
NUMBER
Foreign key to apt_v_tsm_node.
node_session_id
NUMBER
Numeric identifier of the node for the session
server_instance_id
NUMBER
Foreign key to apt_v_server_instance
session_id
NUMBER
Numeric identifier of the session
session_state
NUMBER
Current state of the session
session_state_name
STRING
Possible values: UnKnown, Starting, Ending, Running, Idle Wait, Media Wait, Rec Wait, Send Wait
start_date
DATE
Date the session started
wait_time_secs
NUMBER
Wait time