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:q_pr [2013/11/14 17:13] – adminshell:riportok:q_pr [2017/05/18 15:25] (aktuális) – ↷ Page moved from shell:q_pr to shell:riportok:q_pr admin
Sor 17: Sor 17:
 SQL='SELECT process_num, substr(process,1,20) as PROCESS, 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)", cast(float(bytes_processed/1024/1024) AS DEC(12,2)) AS MB, cast((cast(bytes_processed as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "MB/s" FROM processes' SQL='SELECT process_num, substr(process,1,20) as PROCESS, 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)", cast(float(bytes_processed/1024/1024) AS DEC(12,2)) AS MB, cast((cast(bytes_processed as dec(18,0))/cast(timestampdiff(2,char(current_timestamp-start_time)) as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "MB/s" FROM processes'
  
-echo -e $GREEN"TMSERVER:"$DEFAULT+echo -e "$GREEN$TMSERVER:$DEFAULT"
 echo "PROCESS_NUM   PROCESS                START_TIME            ELAPTIME              MB               MB/s" echo "PROCESS_NUM   PROCESS                START_TIME            ELAPTIME              MB               MB/s"
 echo "-----------   --------------------   -------------------   -----------   ----------   ----------------" echo "-----------   --------------------   -------------------   -----------   ----------   ----------------"
 dsmadmc -pa=$PA -id=$ID -dataonly=y -se=$TSMSERVER -commadel -displ=list "$SQL" | awk -F',' '{printf "%-11s   %-20s   %-19s   %2dd %2dh %2dm   %11s %17s\n", $1, $2, $3, $4, $5, $6, $7, $8 ,$9}' dsmadmc -pa=$PA -id=$ID -dataonly=y -se=$TSMSERVER -commadel -displ=list "$SQL" | awk -F',' '{printf "%-11s   %-20s   %-19s   %2dd %2dh %2dm   %11s %17s\n", $1, $2, $3, $4, $5, $6, $7, $8 ,$9}'
 </file> </file>