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
- TSM napi riport shell szkript @shell:riportok
- SM-hez SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_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_
- 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 ... udo -S <parancs>\" expect "Are you sure" { send "yes\r"} timeout {} expect "?assword:" send \"$Pass\r\" expect eof" </file> Az ssh par... érő === netstat -an | awk '/^tcp/ {A[$(NF)]++} END {for (I in A) {printf "%5d %s\n", A[I], I}}' =
- 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
- TSM node replikacios iranyt forgato szkript @shell:replikacio
- ját. Opcionális paraméterrel szűkíthetjük csak a Send vagy csak a Receive módúakra. __ Replikációs irá... egi küldő legyen az új fogadó és fordítva (A SyncSend és SyncReceive paramétereket használva.) Ezután f... g. __Szinkron módba állítás:__ A node-okat, SyncSend/SyncReceive módba állítja, hogy újra repéikálható... [-n/-m/-f] parameterrel deklaralt node-okon SyncSend, a $TSMSRV2 szerveren SyncReceive modba allitja a
- SSH kulcs terítő szkript @shell
- sh/id_ecdsa.pub $host expect { "continue" { send "yes\n"; exp_continue } "assword:" { send "$password\n"; } "added: 1" { exit 0 } "added: 0... ' whi=$'\e[1;37m' inv=$'\e[7;37m' gry=$'\e[1;90m' end=$'\e[0m' nor=$'\e[0m' grep -v '^#' $INPUT_FILE