Teljes szöveg:
- TSM napi riport shell szkript @shell:riportok
- ################################# # Hasznalt SQL selectek TSM-hez SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB... ancy date" from status' #SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as ... cy date" from status' SQL_UTOLSO24H_ADATMOZGASAI="select nn.domain_name,summary.activity, sum(cast(summary
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- # Az elmult 7 nap aktivitasa tipusonken:t SQL1="SELECT substr(end_time,1,10), substr(activity,1,20), cas... time,1,10)" # Az elmuĂlt 7 nap adatmozgasai SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_n... activity,domain_name asc" # Node-ok méretei SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_... zis mentesek futasi ideje elmult 30 napban: SQL4="SELECT DATE(start_time) as DATE, TRANSLATE('a bc:de:fg',
- TSM drive usage riport @shell:riportok
- pa=$TSMPASS -se=$TSMSERVER -dataonly=y -commadel "select distinct library_name from drives where online='Y... pa=$TSMPASS -se=$TSMSERVER -dataonly=y -commadel "select count(*) from drives where online='YES' and libra... RY}'") # Minden library-re kulon lefuttatjuk SQL="select ORA, cast(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}
- TSM kliens riport shell szkript @shell:riportok
- ################################## # Hasznalt SQL selectek TSM-hez SQL_Q_FAILED_EVENTS="select substr(e.node_name,1,20) as \"NODE NAME\", e.schedule_name, cast ( ... ]]; then continue; fi SQL_3X_MISSED="select substr(e.node_name,1,20) as \"NODE NAME\", substr
- VMware image mentések riportja @shell:riportok
- $TSMUSER -pa=$TSMPASS -se=$TSMSERVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNOD
- Technikai poolokat, vezérlő szkripteket kialakító szkript
- $TSMUSER -pa=$TSMPASS -se=$TSMSERVER -dataonly=y "select DEVCLASS_NAME from devclasses where library_name=... $TSMUSER -pa=$TSMPASS -se=$TSMSERVER -dataonly=y "select 'def stg ' || replace(stgpool_name,'$SUFFIX','') ... $TSMUSER -pa=$TSMPASS -se=$TSMSERVER -dataonly=y "select 'upd scr ${LIBRARY}_CRASH \"UPD STG ' || replace(... =$TSMPASS -se=$TSMSERVER -dataonly=y -displ=tabl "select 'upd scr ${LIBRARY}_CRASH \"UPD STG ' || stgpool_
- TSM node replikacios iranyt forgato szkript @shell:replikacio
- se=$TSMSRV2 -dataonly=y -tabdelim" SQL_REPLNODES="select node_name from nodes where REPL_STATE='ENABLED' o... =[ $NODE ]=-" >> $LOG_FILE REPL_MODE=`$DSMADMC1 "select REPL_MODE from nodes where node_name=upper('$NODE... k, mig nincs sessionje while [[ $($DSMADMC1 "select session_id from sessions where CLIENT_NAME='$NODE... nk, mig nincs processe while [[ $($DSMADMC1 "select process_num from processes where STATUS like '%$N
- DB2 I/O rebalance-t végző szkript
- onnect to tsmdb1 db2 -x set schema tsmdb1 db2 -x "select substr(tbspace,1,20) from syscat.tablespaces wher
- TSM Smart Replicator @shell:replikacio
- )" | tee -a $LOGFILE REPL_NODE_NUM=`$DSMADMC "select count(node_name) from nodes where repl_state='ENA... END','SYNCSEND')" | sed 's/[^0-9]*//'` $DSMADMC "select node_name from nodes where repl_state='ENABLED' a... eplikacio, elinditjuk ra if [ $($DSMADMC "select count(*) from processes where status like '% $NOD... E)" -eq 0 ]; then REPLNUM=$($DSMADMC "select count(*) from processes where process='Replicate
- Minden TSM-es process leállítása
- -se=$TSMSERVER -id=report -pa=report -dataonly=y "select PROCESS_NUM from processes" | grep -v 'AN[RS]'`;
- TSM ütemezés átnevező szkript (asszociációk megmaradnak)
- N -pa=$DSMPASSWD -se=$SE -dataonly=y -displ=tabl "select node_name from associations where domain_name=upp
- Egy node adott objektumának kikeresése, van-e, melyik szalagon van @shell:riportok
- d=$ID -pa=$PSW -dataonly=y -displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME, BACK... d=$ID -pa=$PSW -dataonly=y -displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME from
- Node replikacio ellenorzo szkript @shell:replikacio
- c -id=report -pa=report -dataonly=y -se=$SRCHOST 'select node_name from nodes' | sort > /tmp/${SRCHOST}_no... c -id=report -pa=report -dataonly=y -se=$DSTHOST 'select node_name from nodes' | sort > /tmp/${DSTHOST}_no
- Szebb 'q process' kimenet @shell:riportok
- m' LIGHT_CYAN='\033[1;36m' DEFAULT='\033[0m' SQL='SELECT process_num, substr(process,1,20) as PROCESS, sub
- TSM Auto Deployment planner szkript
- CSAK HA TUDOD MIT CSINALSZ SQL_Q_DEPLOY_PACKAGES="SELECT DISTINCT(DESCRIPTION),NODE_NAME,FILESPACE_NAME,HL... DESCRIPTION LIKE '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='IB