Processus (TSM)

Fiche express
Table SQL	processes
Rôle	Processus serveur en cours (migration, reclamation, expiration...)
Voir aussi	Session (TSM) · TSM

La table SQL processes liste les processus serveur TSM en cours d'exécution (migration, reclamation, expiration, etc.) avec leur débit instantané.

Processus en cours

SELECT process_num, process,
  substr(char(start_time),1,19) AS START_TIME,
  substr(char(current_timestamp - start_time),1,10) AS "ELAPTIME (D HHMMSS)",
  cast(float(bytes_processed) /1024/1024 AS DEC(8,2)) AS MB,
  cast((cast(bytes_processed as dec(18,0))/cast((current_timestamp-start_time) seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "MB/s"
  FROM processes

Voir aussi

• Session (TSM) · Résumé/statistiques (TSM)