Teljes szöveg:
- 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 Auto Deployment planner szkript
- 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 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 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
- -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
- 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 '
- Linuxos "cfgmgr" @shell:device_management
- e "\e[A\e[A\e[A\e[A${red}$SGDEV changed: ${bold}\nfrom:${SCSISTR#* } \nto: $STR ${norm} \n\n\n" retu... e "\e[A\e[A\e[A\e[A${red}$SGDEV changed: ${bold}\nfrom:${TMPSTR} \nto: $TYPE ${norm} \n\n\n" return ... 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
- 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>
- Node replikacio ellenorzo szkript @shell:replikacio
- report -dataonly=y -se=$SRCHOST 'select node_name from nodes' | sort > /tmp/${SRCHOST}_nodes.tmp dsmadmc... report -dataonly=y -se=$DSTHOST 'select node_name from nodes' | sort > /tmp/${DSTHOST}_nodes.tmp echo "#
- 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
- Egy node adott objektumának kikeresése, van-e, melyik szalagon van @shell:riportok
- id, FILESPACE_NAME, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name=upper('$NODE') $HL_NAME $... elect object_id, FILESPACE_NAME, HL_NAME, LL_NAME from archives where node_name=upper('$NODE') $HL_NAME
- Minden TSM-es process leállítása
- report -pa=report -dataonly=y "select PROCESS_NUM from processes" | grep -v 'AN[RS]'`; do echo "
- TSM ütemezés átnevező szkript (asszociációk megmaradnak)
- -se=$SE -dataonly=y -displ=tabl "select node_name from associations where domain_name=upper('$DOMAIN') a