Session (TSM)

Fiche express
Table SQL	sessions
Commandes	query session, cancel session
Voir aussi	Nœud (TSM) · Processus (TSM)

Une session TSM correspond à un job en cours d'exécution côté serveur : sauvegarde, restauration, ou migration de données entre serveurs TSM.

Afficher les sessions

query session

Annuler une session

cancel session 6
cancel session all

Sessions de restauration réitérables

Les sessions de restauration réitérables (restartable restore) ont un numéro de session négatif.

query restore

cancel restore -1        # annuler une session de restauration réitérable
cancel session -2         # interrompre une session de restauration réitérable active

Requêtes SQL utiles

-- Nombre de sessions de type nœud
SELECT COUNT(*) FROM sessions WHERE session_type='Node'

-- Nombre de sessions de type nœud en attente de média
SELECT COUNT(*) FROM sessions WHERE session_type='Node' AND state='MediaW'

-- Détail des sessions en attente de média
SELECT client_name, session_id, start_time, state, mount_point_wait, input_mount_wait, input_vol_wait
  FROM sessions WHERE state='MediaW'

-- Nœuds utilisant des bandes (lecteurs)
SELECT client_name, session_id, start_time, state, bytes_sent, bytes_received, input_vol_access, output_vol_access
  FROM sessions WHERE ( input_vol_access is not NULL OR output_vol_access is not NULL )

-- Informations sur les sessions d'un nœud donné
SELECT session_id, start_time, commmethod, state, wait_seconds, CAST(bytes_sent/1024/1024 AS DEC(8,2)) AS "MB_Sent",
  CAST(bytes_received/1024/1024 AS DEC(8,2)) AS "MB_Rcvd", mount_point_wait FROM sessions WHERE client_name='MY_NODE'

-- Performance des sessions de type nœud
SELECT client_name,session_id, current_timestamp-start_time AS ElapTime, commmethod, state,
  CAST(bytes_sent/1024/1024 AS DEC(8,2)) AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,2)) AS "MB_Rcvd",
  cast((cast(bytes_sent as dec(18,0))/cast((current_timestamp-start_time) seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "Sent_MB/s",
  cast((cast(bytes_received as dec(18,0))/cast((current_timestamp-start_time) seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "Rcvd_MB/s"
  FROM sessions WHERE session_type='Node'

Voir aussi

• Nœud (TSM) · Processus (TSM) · Journal (TSM)