Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- ASS 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)... adatai letárolva? === <file>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> Megőrzési időkkel: SELECT DISTINCT b.NODE_NAME, b.CLASS_NAME, c.SET_NAME, c.VEREXISTS, c.VERDELETED, c.RETEXTRA, c.RETONLY
- TSM napi riport shell szkript @shell:riportok
- y='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc" SQL_UTOLSO24H_AKTIVITASAI="SELECT activity, ... BY activity" SQL_3X_MISSED="select substr(a.node_name,1,20) as \"NODE NAME\", substr(a.schedule_name,1,25) as SCHEDULE, substr(b.contact,1,20) as \"CO... ed_start >=current_timestamp - 3 days) and a.node_name=b.node_name and a.status='Missed' and a.node_name is not NULL and a.schedule_name not like 'RMAN_%%_LOG%%' and a.schedule_name not like 'SQL_%%_LOG%%' group by a.node_name, a.schedule_name, b.contact, b.lastacc_time having count(*)>=3 order by
- TSM Auto Deployment planner szkript @shell
- EPLOY_PACKAGES="SELECT DISTINCT(DESCRIPTION),NODE_NAME,FILESPACE_NAME,HL_NAME,LL_NAME FROM ARCHIVES WHERE NODE_NAME LIKE 'IBM_CLIENT_DEPLOY%' and TYPE='FILE' and ( ... ASSOCIATIONS A, CLIENT_SCHEDULES CS WHERE N.NODE_NAME=A.NODE_NAME AND A.SCHEDULE_NAME=CS.SCHEDULE_NAME AND CS.ACTION='DEPLOY'" DSMADMC="dsmadmc -id=$TSM... echo "${yel}#### $NODE ####${end}" DEPL_DOM_NAME=$($DSMADMC "select domain_name from nodes where node_name=upper('${NODE}')" | sed 's/ //g') if [[ $(e... TSCHEDULECMD='..\IBM_ANR_WIN\V${VERSIONNUM}\\${LL_NAME[$DEPL_PACK_ID]} SCHEDULE=${DEPL_SCH_NAME} DOMAIN=${DEPL_DOM_NAME} AUTODEPLOY=NOREBOOT nodeinfo=TBD' -SUB=YES -REPL
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- pes from auditocc ao JOIN occupancy oc ON ao.node_name=oc.node_name left JOIN volumeusage vu ON vu.node_name=ao.node_name group by ao.node_name,ao.total_mb or... occupancy LEFT JOIN stgpools ON occupancy.stgpool_name=stgpools.stgpool_name GROUP BY occupancy.stgpool_name, pooltype" # Teljes szerveren tarolt adatmennyise... ools s, occupancy o, devclasses d where s.stgpool_name=o.stgpool_name and s.devclass=d.devclass_name GROUP BY o.stgpool_name,s.devclass,d.devtype,d.library_name ORDER BY o.st... name" # Inaktiv node-ok SQL10="select substr(node_name,1,30) as node, (select domain_name from nodes no where no.node_name=oc.node_name),(select (days(current_timestamp)-days(lastacc_ti
- Tömeges VM létrehozó szkript @shell:oravm
- rehozó szkript ====== Minta konfig fájl: #OVS_NAME REPO_NAME POOL_NAME VM_NAME MEMORY_GB VCPU_COUNT BOOT_DISK... parametereket:" echo -e "OVS: ${grn}${OVS_NAME}${end}, Repo: ${grn}${REPO_NAME}${end}, Pool: ${grn}${POOL_NAME}${end}, VM neve: ${grn}${VM_NAME}${end}," ... sleep 15 VM_ID=$(ovm_exec "create Vm name=\"$VM_NAME\" repository=\"$REPO_NAME\" domainType=XEN_HVM_PV_DRIVERS server=\"$OVS_NAM... 2 ${end}" VNIC_ID=$(ovm_exec "create Vnic name=\"${VM_NAME}_vnic\" network=\"$NETWORK_NAME\" on Vm id=\"$VM_ID\"") [[ -z $VNIC_ID ]]
- Oracle VM CPU pin map @shell:oravm
- $PINS | sed 's/^,//') [[ $(grep -c ";$VM_NAME;$PINS" "$FULL_BACKUP_FILE") -eq 1 ]] || HIBAS_VMS="${HIBAS_VMS#,},$VM_NAME" done <<< "`$SSHC "show server name=$OVS" | grep '^.*Vm .*\[.*\]' | sort`" done <<< "`$SSHC... S=$(echo $SOR |awk -F';' '{print $1}') VM_NAME=$(echo $SOR |awk -F';' '{print $2}') VCPU... SOR |awk -F';' '{print $3}') echo -e "$VM_NAME;$VCPU_LIST" | awk -F';' '{printf "%-30s %-31s",$1
- Egy node adott objektumának kikeresése, van-e, melyik szalagon van @shell:riportok
- ektum nev (ll_name): '; read -r LL_NAME if [[ $LL_NAME ]]; then LL_NAME="and ll_name='$LL_NAME'"; fi printf 'Keresett objektum utvonal (hl_name): '; read -r HL_NAME if [[ $HL_NAME ]]; then HL_NAME="and hl_name='$HL_NAME'"; fi while [[ -z $NODE ]]; do printf 'Node neve:... displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" echo '' echo ... erverem} -id=$ID -pa=$PSW -dataonly=y -displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME from archives where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" </file>
- TSM kliens riport shell szkript @shell:riportok
- by <rendező mező> Pl: fonok@cegem.hu; (e.node_name='FONOK_SZERVERE' or e.schedule_name like 'NAPI_INCR_%') ORDER BY e.schedule_name Ha egy email címhez több sor is van, azokat külö... TSM-hez SQL_Q_FAILED_EVENTS="select substr(e.node_name,1,20) as \"NODE NAME\", e.schedule_name, cast ( SUBSTR ( CHAR ( e.actual_start ) , 1 , 19... i SQL_3X_MISSED="select substr(e.node_name,1,20) as \"NODE NAME\", substr(e.schedule_name,1,25) as SCHEDULE, substr(n.contact,1,20) as \"CO... ed_start >=current_timestamp - 3 days) and e.node_name=n.node_name and e.status='Missed' and e.node_name is not NULL and e.schedule_name not like 'RMAN_%%
- Technikai poolokat, vezérlő szkripteket kialakító szkript @shell
- 'upd scr ${LIBRARY}_OFFLINE \"UPD DR ' || library_name || ' ' || drive_name || ' ONL=N\"' from drives where library_name='${LIBRARY}'" | sed 's/ *$//' echo # ${LIBRARY} ... abl "select 'upd scr ${LIBRARY}_ONLINE \"UPD DR ' || library_name || ' ' || drive_name || ' ONL=Y\"' from drives where library_name='${LIBRARY}'" | sed 's/ *$//' </file>
- Fizikai diszkeket átnevező szkript @shell:oravm
- ate VmDiskMapping slot=$SLOT physicalDisk=\"$DISK_NAME\" name=\"${DISK_NAME}_to_${VM_NAME}\" on Vm id=\"$VM_ID\"" "Status") ... echo "$(env printf '\u2523') A $VM_NAME kesz." | tee -a $LOGFILE done ech
- VM-ek diszkjeinek listázása @shell:oravm
- DISK_FILENAME=$DISK_ID DISK_NAME=$(ovm_exec "show virtualdisk name=$DISK_ID" "[[:space:]][[:space:]]Name") DISK_REPO=$(ovm_cli "show virtu... SK_ID" "User-Friendly Name") DISK_NAME=$(ovm_exec "show physicalDisk id=$DISK_ID" "[[:space:]][[:space:]]Name") DISK_SIZE=$(ovm_exec "show phys... "Size \(GiB\)") echo "$VM" "$DISK_NAME" "[$DISK_WWN]" "${DISK_SIZE}G" "P" | awk '{printf... how PhysicalDisk id=$PHYS_DISK_ID" "User-Friendly Name") SLOT_NR=$(cat ${TMP_FILE}.1 | awk -F'=' '/S
- TSM drive usage riport @shell:riportok
- tart_time)))/1440*100/count(DISTINCT substr(drive_name,1,posstr(drive_name,' '))),5,1) as \"24H LOAD (%)\" FROM summary WHER... and end_time<date(current_timestamp) and library_name='${LIBRARY}' GROUP BY library_name" NR=0 rm -rf $TMP_FILE $TMP_FILE.2 # Matrix inic
- AIX tape device-ok átnevezése beszédesre konfig állomány alapján @shell:device_management
- }" echo "update path <SRC_NAME> <LIBR_NAME> srct=serv destt=libr device=/dev/${NEW_NAME}" >> $MACRO_TEMPL_FILE fi
- TSM node replikacios iranyt forgato szkript @shell:replikacio
- -dataonly=y -tabdelim" SQL_REPLNODES="select node_name from nodes where REPL_STATE='ENABLED' order by node_name" white=$(tput bold;tput setaf 7) # brigh... s replikacios ' ]]; then $DSMADMC1 "select node_name from nodes where REPL_STATE='ENABLED' order by node_name" > "tsm_change_repl_roles.$(date "+%Y%m%d%H%M").$... REPL_MODE2.nodes" else $DSMADMC1 "select node_name from nodes where REPL_STATE='ENABLED' and REPL_MODE='$IF_REPL_MODE' order by node_name" > "tsm_change_repl_roles.$(date "+%Y%m%d%H%M").$
- Fizikai diszkek tömeges mappelése VM(ek)hez @shell:oravm
- te VmDiskMapping slot=$SLOT physicalDisk=\"$VDISK_NAME\" name=\"${VDISK_NAME}_to_${VM_NAME}\" on Vm id=\"$VM_ID\"" "Status") [[ "$VD... end}" echo "$(env printf '\u2517') A $VM_NAME kesz." done done <<< "`cat $1 | grep -v '^#'