Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- a query was executed in the following order: - FROM clause - WHERE clause - GROUP BY clause - H... n_name,class_name as "MGMT CLASS without OBJECTS" from mgmtclasses where class_name not in (select distinct class_name from backups) and class_name not in (select distinct class_name from archives) and set_name='ACTIVE'</file> === Milye
- TSM napi riport shell szkript @shell:riportok
- ,substr(SUROCC_DATE,1,19) as "SUR occupancy date" from status' #SQL_LICENSZ_HASZNALATOK='select cast(FRO... UR retain TB",SUROCC_DATE as "SUR occupancy date" from status' SQL_UTOLSO24H_ADATMOZGASAI="select nn.dom... mary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between curr... sum(bytes))/1024/1024/1024 as dec(8,2)) as \"GB\" FROM summary WHERE end_time>current_timestamp-24 hours
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- oat(sum(bytes))/1024/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hour... mary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between curr... NUM_FILES,count(distinct vu.volume_name) as tapes from auditocc ao JOIN occupancy oc ON ao.node_name=oc.... )\", cast(bytes/1024/1024/1024 as DEC(8,2)) as GB FROM summary WHERE activity='FULL_DBBACKUP' AND curren
- TSM drive usage riport @shell:riportok
- ataonly=y -commadel "select distinct library_name from drives where online='YES'") bold=$(tput bold) ... $TSMSERVER -dataonly=y -commadel "select count(*) from drives where online='YES' and library_name='${LIB... ect ORA, cast(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}')) as dec(4,0)) from ( \ select concat(date(start_time) || ' ',substr(
- TSM Auto Deployment planner szkript @shell
- RIPTION),NODE_NAME,FILESPACE_NAME,HL_NAME,LL_NAME FROM ARCHIVES WHERE NODE_NAME LIKE 'IBM_CLIENT_DEPLOY%... 'DEPLOY%'" SQL_QUERY_DEPLOY_DIR="SELECT DIRECTORY FROM DEVCLASSES WHERE DEVCLASS_NAME IN (SELECT DEVCLASS FROM STGPOOLS WHERE STGPOOL_NAME IN (SELECT DESTINATION FROM AR_COPYGROUPS WHERE DOMAIN_NAME='IBM_CLIENT_DEPLO
- TSM node replikacios iranyt forgato szkript @shell:replikacio
- only=y -tabdelim" SQL_REPLNODES="select node_name from nodes where REPL_STATE='ENABLED' order by node_na... $LOG_FILE REPL_MODE=`$DSMADMC1 "select REPL_MODE from nodes where node_name=upper('$NODE')"` # Ha nem ... onje while [[ $($DSMADMC1 "select session_id from sessions where CLIENT_NAME='$NODE' and SESSION_TY... sse while [[ $($DSMADMC1 "select process_num from processes where STATUS like '%$NODE%'" | egrep -v
- Technikai poolokat, vezérlő szkripteket kialakító szkript @shell
- -se=$TSMSERVER -dataonly=y "select DEVCLASS_NAME from devclasses where library_name='$DR_LIBRARY'" prin... ol=no reclaimpr=2 recl=100 maxscr=' || maxscratch from stgpools where stgpool_name like '%$SUFFIX'" echo... SUFFIX','') || '$DR_SUFFIX NEXTSTG='''' HI=100\"' from stgpools where stgpool_name like '%$SUFFIX'" echo... $SUFFIX','') || '$DR_SUFFIX ACCESS=UNAVAILABLE\"' from stgpools where stgpool_name like '%$SUFFIX'" | se
- TSM Cirkuláris Másolatkészítő szkript @shell
- E PRIMARY_POOL_NUM=`$DSMADMC "select count(*) from stgpools where ${PRIM_POOL_WHERE} and POOLTYPE='P... sed 's/[^0-9]*//'` $DSMADMC "select stgpool_name from stgpools where ${PRIM_POOL_WHERE} and POOLTYPE='P... itjuk ra if [ $($DSMADMC "select count(*) from processes where status like '% $POOL,%' and proce... BACKUPNUM=$($DSMADMC "select count(*) from processes where process='Backup Storage Pool'" |
- TSM Smart Replicator @shell:replikacio
- REPL_NODE_NUM=`$DSMADMC "select count(node_name) from nodes where repl_state='ENABLED' and repl_mode in... | sed 's/[^0-9]*//'` $DSMADMC "select node_name from nodes where repl_state='ENABLED' and repl_mode in... itjuk ra if [ $($DSMADMC "select count(*) from processes where status like '% $NODE.%'") -eq 0 ]... n REPLNUM=$($DSMADMC "select count(*) from processes where process='Replicate Node'" | sed '
- Szkriptelés @linux
- tions/3173131/redirect-copy-of-stdout-to-log-file-from-within-bash-script-itself]] ==== Ismétlődő sorok... n declared and is null.| |${var#Pattern} | Remove from $var the 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 t
- Linux okosságok
- == find / -name "*\.trc" -print0 | du --files0-from=- -hc | tail -n1 ==== Milyen felbontásokat tám... wargv = malloc((argc+1)*sizeof(*argv)); char *from,*to; int i,len; for(i = 0; i<argc; i++){ from = argv[i]; len = strlen(from)+1; to = malloc(len); memcpy(to,from,len);
- Linuxos "cfgmgr" @shell:device_management
- st $channen $id $lun exists # Outputs description from /proc/scsi/scsi (unless arg passed) # Returns SCS... fi done } # Returns the list of existing LUNs from device $host $channel $id $lun # and returns list... emove="$lunremove $lun" fi # $lun removed from $lunsearch (echo for whitespace cleanup) targ... cho -n "Temporarily setting kernel scanning flags from " printf "0x%08x to 0x%08x\n" $OLD_SCANFLAGS
- VMware image mentések riportja @shell:riportok
- TSMUSER=user TSMPASS=password TSMSERVER=tsm EMAIL_FROM="TSM riporter" TSMNODE=VCENTER01 IN_RISK_DAYS=31 ... SS -se=$TSMSERVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNODE' and hl_name li... T_FILE.html)" > $OUTPUT_FILE.html cat $OUTPUT_FILE.html | sendmail -B 8BITMIME -t -F $EMAIL_FROM </file>
- Tapeutil, itdt használat @doksik_leirasok
- oor| | tapeutil -f /dev/smc0 move X Y | Move tape from slot element number X to slot element number Y| |... -f /dev/rmt1 mount <element number> | Mount tape from element number on drive rmt0| | tapeutil -f /dev/rmt1 unmount <element number> | Dismount tape from element number on drive rmt0| | tapeutil -f /dev/
- TSM kliens riport shell szkript @shell:riportok
- || substr(e.status,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.s... timestamp)-days(n.lastacc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=curr