meta data for this page
  •  

Különbségek

A kiválasztott változat és az aktuális verzió közötti különbségek a következők.

Összehasonlító nézet linkje

Előző változat mindkét oldalonElőző változat
Következő változat		Előző változat
shell:riportok:q_se [2024/11/06 17:38] – adminshell:riportok:q_se [2024/11/28 11:45] (aktuális) – admin
Sor 24: Sor 24:
  
 Belső TSM-es szkript: Belső TSM-es szkript:
 +
 <WRAP prewrap> <WRAP prewrap>
-<FILE> +<file> 
-SELECT SESSION_ID, substr(CLIENT_NAME,1,20) as NODE_NAME, substr(char(start_time),1,19) AS START_TIME,substr(char(days(current_timestamp) - days(start_time)),1,2) AS "(D)" ,substr(char((current_timestamp - start_time)hours),1,2) AS "(HH)", substr(char((current_timestamp - start_time)minutes),1,2) AS "(MM)", substr(STATE,1,10) as STATE,WAIT_SECONDS, cast(float(bytes_sent) /1024/1024 AS DEC(12,2)) AS "Sent MB", cast((cast(bytes_sent as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS "Sent MB/s",cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS "Rec. MB", cast((cast(bytes_received as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS "Rec. MB/s"  FROM sessions WHERE SESSION_TYPE='Node'</FILE>+DEFINE SCRIPT  Q_SE "SELECT SESSION_ID, substr(CLIENT_NAME,1,20) as NODE_NAME, substr(char(start_time),1,19) AS START_TIME,TRANSLATE('a bc:de:fg', DIGITS(current_timestamp - start_time), '_______abcdefgh_____',' ') as RUNTIME, substr(STATE,1,10) as STATE,WAIT_SECONDS, cast(float(bytes_sent)/1024/1024 AS DEC(12,2)) AS ""Sent MB"", cast((cast(bytes_sent as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time+1)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Sent MB/s"",cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS ""Rec. MB"", cast((cast(bytes_received as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time+1)) as decimal(18,0))) / 1024 / 1024 AS DEC (10,2)) AS ""Rec. MB/s""  FROM sessions WHERE SESSION_TYPE='Node'" 
 +</file>
 </WRAP> </WRAP>