Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- 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 c... set-ek listázása === <file>select OPTIONSET_NAME from CLOPTSETS where OPTIONSET_NAME not in (select OPTION_SET from nodes where OPTION_SET!='NULL')</file> ====Hib... archar(20)), 'not in libvolumes') as home_element from volumes v left join (select volume_name, home_element from (select volume_name, home_element, row_number() o... ect to tsmdb1 db2 set schema tsmdb1 db2 "select * from schedule_node_addresses where nodeid=(select nodeid from nodes where nodename='KERESETTNODE')" db2 connect
- TSM napi riport shell szkript @shell:riportok
- ="select distinct library_name,'0' as \"SCRATCH\" from libvolumes where library_name not in (select distinct library_name from libvolumes where status='Scratch' group by librar... L_NEM_HASZNALT_OPTIONSETEK="select OPTIONSET_NAME from CLOPTSETS where OPTIONSET_NAME not in (select OPTION_SET from nodes where OPTION_SET!='NULL')" SQL_KEVES_SCRATC... S NULL AND volume_name NOT IN (SELECT volume_name FROM volumes) and (owner=(select server_name from status) or owner IS NULL) and volume_name not in ... AME\",substr(DESTINATION,1,15) as \"DESTINATION\" from bu_copygroups where DESTINATION not in (select stgpool_name from stgpools)" SQL_ACTLOG_ERRORS="SELECT substr(char(
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- nt_timestamp)-days(lastacc_time)) as LAST_ACCESS from nodes no where no.node_name=oc.node_name), sum(REPORTING_MB)/1024 as GB from occupancy oc where (select (days(current_timestam... ctive_nodes,(select count(node_name) as ALL_NODES from nodes no2 where no2.domain_name=no.domain_name) from nodes no where (days(current_timestamp)-days(no.l... sage,' ',1,6)-1) as NODE, count(*) as TAPE_MOUNTS from actlog where msgno in (0839,0406) and session in (select session from actlog where msgno=0511 and substr(message,instr(
- TSM drive usage riport @shell:riportok
- 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(... 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(ti... ))-start_time) END as dec(5,2))) /60*100 as USAGE from summary where ACTIVITY='TAPE MOUNT' and library_n... :00.000000'))) END as dec(5,2))) /60*100 as USAGE from summary where ACTIVITY='TAPE MOUNT' and library_n
- Include-exclude használat @doksik_leirasok
- e-exclude-option-processing **- So if I watch it from server side clopt, it's bottom up, if I check it from a client then evaluation is in reverse?** What y... said is the outputs of the command: 'q cloptset' from OC or dsmadmc and you see the include/exclude opt... . What I said is the outputs of 'dsmc q inclexcl' from client node, which is the real matching order whe... u run backup. For example: 1. Run 'q cloptset' from OC: CHENGH-SP-73> q cloptset Optionset Descr
- 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
- TSM Auto Deployment planner szkript @shell
- '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... , substr(N.PLATFORM_NAME,1,15) as \"OS_VERSION\" FROM NODES N, ASSOCIATIONS A, CLIENT_SCHEDULES CS WHER... $DSMADMC "select date_time, message from actlog where (date_time \> current_timestamp - 16
- 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 Smart Replicator @shell:replikacio
- LE) LAST_NODE_IS_REAL=$($DSMADMC "select count(*) from nodes where node_name='$LAST_NODE'" | sed 's/[^0-... EPL_NODE_NUM=`$DSMADMC "select count(n.node_name) from nodes n where n.repl_state='ENABLED' and n.repl_m... /[^0-9]*//'` $DSMADMC "select n.node_name from nodes n LEFT JOIN REPLICATIONVIEW r ON n.node_nam... itjuk ra if [ $($DSMADMC "select count(*) from processes where status like '% $NODE.%'") -eq 0 ]
- 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'" |
- 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/