meta data for this page
  •  

Keresés

A keresés eredményét lentebb láthatod.

Teljes szöveg:

Hasznos TSM SQL lekérdezések
68 Találatok, Utolsó módosítás:
uted in the following order: - FROM clause - WHERE clause - GROUP BY clause - HAVING clause - ... as "MGMT CLASS without OBJECTS" from mgmtclasses where class_name not in (select distinct class_name fro... select distinct node_name,class_name from backups where node_name='NODE' select distinct node_name,class_name from archives where node_name='NODE'</file> === Hibás PRIVATE volume
TSM napi riport shell szkript @shell:riportok
39 Találatok, Utolsó módosítás:
as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 24 hours an... 024/1024/1024 as dec(8,2)) as \"GB\" FROM summary WHERE end_time>current_timestamp-24 hours and activity<... cc_time)) as \"LAST SEEN\" from EVENTS a, nodes b where (a.scheduled_start >=current_timestamp - 3 days) ... 4/1024 AS DEC(10,2)) AS \"Rec. MB\" FROM sessions WHERE SESSION_TYPE='Node' and (current_timestamp - star
TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
14 Találatok, Utolsó módosítás:
))/1024/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hours and activity... as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours a... es/1024/1024/1024 as DEC(8,2)) as GB FROM summary WHERE activity='FULL_DBBACKUP' AND current_timestamp - ... MSS)\", affected, number, successful FROM summary WHERE activity='EXPIRATION' AND entity IS NULL AND curr
TSM Cirkuláris Másolatkészítő szkript @shell
12 Találatok, Utolsó módosítás:
t ====== A primary pool-okat, amiket a PRIM_POOL_WHERE változóban megadott SQL feltétellel definiálunk, ... NFINITERUN=true REFRESHRATE=30 #MINUTES PRIM_POOL_WHERE="stgpool_name like '%_T' and stgpool_name like '%... POOL_NUM=`$DSMADMC "select count(*) from stgpools where ${PRIM_POOL_WHERE} and POOLTYPE='PRIMARY'" | sed 's/[^0-9]*//'` $DSMADMC "select stgpool_name from stgp
TSM Auto Deployment planner szkript @shell
10 Találatok, Utolsó módosítás:
NAME,FILESPACE_NAME,HL_NAME,LL_NAME FROM ARCHIVES WHERE NODE_NAME LIKE 'IBM_CLIENT_DEPLOY%' and TYPE='FIL... UERY_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_DEPLOY' AND SET_NAME='ACT
TSM node replikacios iranyt forgato szkript @shell:replikacio
10 Találatok, Utolsó módosítás:
delim" SQL_REPLNODES="select node_name from nodes where REPL_STATE='ENABLED' order by node_name" white=$(... REPL_MODE=`$DSMADMC1 "select REPL_MODE from nodes where node_name=upper('$NODE')"` # Ha nem olyan modban... e [[ $($DSMADMC1 "select session_id from sessions where CLIENT_NAME='$NODE' and SESSION_TYPE='Node'" | eg... [[ $($DSMADMC1 "select process_num from processes where STATUS like '%$NODE%'" | egrep -v 'AN[SR]'| wc -l
TSM drive usage riport @shell:riportok
10 Találatok, Utolsó módosítás:
ommadel "select distinct library_name from drives where online='YES'") bold=$(tput bold) ... dataonly=y -commadel "select count(*) from drives where online='YES' and library_name='${LIBRARY}'") # Mi... t(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}')) as d... ) END as dec(5,2))) /60*100 as USAGE from summary where ACTIVITY='TAPE MOUNT' and library_name='${LIBRARY
Technikai poolokat, vezérlő szkripteket kialakító szkript @shell
8 Találatok, Utolsó módosítás:
-dataonly=y "select DEVCLASS_NAME from devclasses where library_name='$DR_LIBRARY'" printf ": "; read DR_... r=2 recl=100 maxscr=' || maxscratch from stgpools where stgpool_name like '%$SUFFIX'" echo # Éles poolró... '$DR_SUFFIX NEXTSTG='''' HI=100\"' from stgpools where stgpool_name like '%$SUFFIX'" echo "upd scr ${LIB... | '$DR_SUFFIX ACCESS=UNAVAILABLE\"' from stgpools where stgpool_name like '%$SUFFIX'" | sed 's/ *$//' ech
TSM Smart Replicator @shell:replikacio
7 Találatok, Utolsó módosítás:
NUM=`$DSMADMC "select count(node_name) from nodes where repl_state='ENABLED' and repl_mode in ('SEND','SY... ^0-9]*//'` $DSMADMC "select node_name from nodes where repl_state='ENABLED' and repl_mode in ('SEND','SY... if [ $($DSMADMC "select count(*) from processes where status like '% $NODE.%'") -eq 0 ] && [ "$(echo $E... EPLNUM=$($DSMADMC "select count(*) from processes where process='Replicate Node'" | sed 's/[^0-9]//g')
TSM kliens riport shell szkript @shell:riportok
3 Találatok, Utolsó módosítás:
okból veszi, aminek a formátuma: email cím; (sql WHERE feltétel az events, mint "e" táblából) order by <... tatus,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.scheduled_start ... cc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=current_timestamp - 3 days)
Egy node adott objektumának kikeresése, van-e, melyik szalagon van @shell:riportok
2 Találatok, Utolsó módosítás:
_NAME, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" ech... d, FILESPACE_NAME, HL_NAME, LL_NAME from archives where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" </f
DB2 I/O rebalance-t végző szkript @shell
1 Találatok, Utolsó módosítás:
lect substr(tbspace,1,20) from syscat.tablespaces where tbspacetype='D'" | while read TBS; do # Vagy: db2
TSM ütemezés átnevező szkript (asszociációk megmaradnak) @shell
1 Találatok, Utolsó módosítás:
y -displ=tabl "select node_name from associations where domain_name=upper('$DOMAIN') and schedule_name=up
VMware image mentések riportja @shell:riportok
1 Találatok, Utolsó módosítás:
RVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNODE' and hl_name like '\\$VM_NAME
Szebb 'q session' kimenet @shell:riportok
1 Találatok, Utolsó módosítás:
only=y -commadel -displ=list -se=$TSMSERVER "$SQL WHERE SESSION_TYPE='Node'" | awk -F',' '{printf "%10s