Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- eonként === <WRAP prewrap> <file>select - sum((end_time-start_time) minutes) as "Minutes", - decimal(cast(sum((end_time-start_time) minutes) as decimal (6,2)) /1440... rt_time),1,2)) as ORA, sum( cast(CASE WHEN substr(end_time,1,13)=substr(start_time,1,13) THEN timestampdiff(4,end_time-start_time) WHEN substr(end_time,1,13)>subst
- Hálózati okosságok @linux
- your files there, add a trailing slash (/) at the end of the destination path. If you add the trailing ... érő === netstat -an | awk '/^tcp/ {A[$(NF)]++} END {for (I in A) {printf "%5d %s\n", A[I], I}}' =
- TSM napi riport shell szkript @shell:riportok
- RONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB",substr(FRONTEND_CAP_DATE,1,19) as "Front-End Date",FRONTEND_CLIENT_COUNT as "Front-End client count",cast(TOTALSUROCC_TB as decimal (8,2)) as "SUR ... RONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB",substr(FRONTEND_CAP_DATE,1,19) as "Front-End
- Linux okosságok
- find / -printf '%u %k\n' | awk '{arr[$1]+=$2} END {for (i in arr) {print i,arr[i]}}' ==== SWAP h... void (*rtld_fini)(void), void (*stack_end)){ static int (*real___libc_start_main)() = N... ubp_av, init, fini, rtld_fini, stack_end); } </file> ==== Hasznos oldalak ==== * [[htt
- Szkriptelés @linux
- le | sed 's/([^(]*)$/,&/' | awk -F'[,]' '{a[$2]++}END{for(k in a) print $1,k,$3,"("a[k]"x)"}' ==== Use... shortest part of $Pattern that matches the front end of $var.| |${var##Pattern} | Remove from $var the longest part of $Pattern that matches the front end of $var.| |${var%Pattern} | Remove from $var the shortest part of $Pattern that matches the back end of $var.| |${var%%%%Pattern} | Remove from $var t
- TSM "Inkrementális" archiváló szkript @shell
- ]} echo "------------------------ $(date) END ----------------------" >> "$LOGFILE" if
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- 7 nap aktivitasa tipusonken:t SQL1="SELECT substr(end_time,1,10), substr(activity,1,20), cast(float(sum... 4/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hours and activity<>'EXPIRATION' and bytes>0 GROUP BY activity, substr(end_time,1,10)" # Az elmuĂlt 7 nap adatmozgasai SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) a
- TSM drive usage riport @shell:riportok
- rt_time),1,2)) as ORA, sum( cast(CASE WHEN substr(end_time,1,13)=substr(start_time,1,13) THEN timestampdiff(4,end_time-start_time) WHEN substr(end_time,1,13)>substr(start_time,1,13) THEN timestampdiff(4,timestamp(con... start_time),1,2) || ':59:59.000000'))-start_time) END as dec(5,2))) /60*100 as USAGE from summary where
- TSM kliens riport shell szkript @shell:riportok
- ed - e.actual_start), '_______abcdefgh_____',' ') end as \"RUNTIME \", case when e.result=0 then ' 0-... e.result as char) || '-' || substr(e.status,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.scheduled_start and e.schedul
- DB2 HADR beállítás @doksik_leirasok
- ználhatóba tétele: db2 rollforward db TSMDB1 to end of logs and complete [[https://www-01.ibm.com/
- ovm_functions.sh szkript @shell:oravm
- ' whi=$'\e[1;37m' inv=$'\e[7;37m' gry=$'\e[1;90m' end=$'\e[0m' function ovm_cli() { OVMCLI="ss
- Oracle VM CPU pin map @shell:oravm
- ' whi=$'\e[1;37m' inv=$'\e[7;37m' gry=$'\e[1;90m' end=$'\e[0m' function fejlec { # $1: CIM, $2: h... r:]' '[:upper:]'` KIMENET="-=[ ${yel}$FEJLEC${end} ]=-" for I in `seq 1 $((($2-${#FEJLEC}-3)/2)... in `seq 1 $2`; do printf '#'; done printf "${end}" } function show_parameters { echo "Parancs... pcionális]" echo -e "Pl: $0 -c rgzd@aegon.hu${end}" } [[ ! $@ =~ -(c|-check) ]] && echo Kulcs elle
- VM-ek diszkjeinek listázása @shell:oravm
- %-30s %-40s %10s %3s\n",$1,$2,$3,$4,$5}' printf $end ovm_cli "list vmdiskMapping" | egrep -v '(EMPTY_C... %3s\n",$1,$2,$3,$4,$5}' printf ${end} else DISK_ID=$(ovm_exec
- SSH kulcs terítő szkript @shell
- ' whi=$'\e[1;37m' inv=$'\e[7;37m' gry=$'\e[1;90m' end=$'\e[0m' nor=$'\e[0m' grep -v '^#' $INPUT_FILE
- Fizikai diszkeket átnevező szkript @shell:oravm
- $(env printf '\u2501')> UUID: ${grn}${DISK_UUID}${end}, Nev: ${grn}${DISK_NAME}${end}, Shared: ${grn}${DISK_SHARED}${end}, VM(ek): ${grn}${VM_NAMES}${end}" | tee -a $LOGFILE printf "$(env printf '\u2503') Ha ez nem