meta data for this page
  •  

Különbségek

A kiválasztott változat és az aktuális verzió közötti különbségek a következők.

Összehasonlító nézet linkje

Előző változat mindkét oldalonElőző változat
Következő változat		Előző változat
Következő változatKövetkező változat mindkét oldalon
shell:gather_data [2016/05/18 13:43] – adminshell:riportok:gather_data [2021/10/07 18:11] – admin
Sor 10: Sor 10:
 TSMPASS=report TSMPASS=report
 TSMSERVER=tsm  # dsm.sys servername XXX TSMSERVER=tsm  # dsm.sys servername XXX
 +INAKTIV_NODE_NAPSZAM=32
 #************** konfig vege  ************************************# #************** konfig vege  ************************************#
  
Sor 19: Sor 20:
 # Az elmuĂlt 7 nap adatmozgasai # Az elmuĂlt 7 nap adatmozgasai
 SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) as DOMAIN,substr(summary.activity,1,15) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by substr(end_time,1,10),domain_name,summary.activity order by date,activity,domain_name asc" SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) as DOMAIN,substr(summary.activity,1,15) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by substr(end_time,1,10),domain_name,summary.activity order by date,activity,domain_name asc"
 +# Node-ok méretei
 SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_mb, sum(distinct oc.num_files) as NUM_FILES,count(distinct vu.volume_name) as tapes 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 order by 2 desc" SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_mb, sum(distinct oc.num_files) as NUM_FILES,count(distinct vu.volume_name) as tapes 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 order by 2 desc"
 # Adatbazis mentesek futasi ideje elmult 30 napban: # Adatbazis mentesek futasi ideje elmult 30 napban:
Sor 33: Sor 35:
 SQL9="SELECT substr(o.stgpool_name,1,25) as STGPOOL_NAME,substr(case when s.devclass='DISK'  then s.devclass else s.devclass || ' (' || d.devtype || ')' end,1,25) as DEVCLASS ,substr(d.library_name,1,20) as LIBRARY_NAME,CAST(FLOAT(SUM(o.logical_mb))/1024/1024 AS DEC(6,2)) as TB FROM stgpools 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.stgpool_name" SQL9="SELECT substr(o.stgpool_name,1,25) as STGPOOL_NAME,substr(case when s.devclass='DISK'  then s.devclass else s.devclass || ' (' || d.devtype || ')' end,1,25) as DEVCLASS ,substr(d.library_name,1,20) as LIBRARY_NAME,CAST(FLOAT(SUM(o.logical_mb))/1024/1024 AS DEC(6,2)) as TB FROM stgpools 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.stgpool_name"
 # Inaktiv node-ok # 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_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_timestamp)-days(lastacc_time)) as LAST_ACCESS  from nodes no where no.node_name=oc.node_name)>30 GROUP BY oc.node_name order by last_access"+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(lastac 
 +c_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_timestamp 
 +)-days(lastacc_time)) as LAST_ACCESS  from nodes no where no.node_name=oc.node_name)>$INAKTIV_NODE_NAPSZAM GROUP BY oc.node_name order by last_access" 
 +SQL11="select no.domain_name, count(no.node_name) as inactive_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.lastacc_time)) \> $INAKTIV_NODE_NAPSZAM group by no.domain_name"
  
 if [[ $1 != "-t" && $1 != "-o" ]]; then if [[ $1 != "-t" && $1 != "-o" ]]; then
Sor 77: Sor 83:
  
     echo "TSM-es SELECT-eket futtatok..."     echo "TSM-es SELECT-eket futtatok..."
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL1 > ${OUTPUT_DIR}/${HOST}_SQL1.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL1 > ${OUTPUT_DIR}/${HOST}_Elmult_7_nap_aktivitasa.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL2 > ${OUTPUT_DIR}/${HOST}_SQL2.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL2 > ${OUTPUT_DIR}/${HOST}_Elmult_7_nap_adatmozgasai.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL3 > ${OUTPUT_DIR}/${HOST}_SQL3.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL3 > ${OUTPUT_DIR}/${HOST}_Node-ok_meretei.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL4 > ${OUTPUT_DIR}/${HOST}_SQL4.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL4 > ${OUTPUT_DIR}/${HOST}_DB_mentesek_futasi_idoi.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL5 > ${OUTPUT_DIR}/${HOST}_SQL5.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL5 > ${OUTPUT_DIR}/${HOST}_Expire_Invetory-k_futasi_idoi.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL6 > ${OUTPUT_DIR}/${HOST}_SQL6.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL6 > ${OUTPUT_DIR}/${HOST}_Storage_poolok_helyfoglalasa.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL7 > ${OUTPUT_DIR}/${HOST}_SQL7.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL7 > ${OUTPUT_DIR}/${HOST}_Teljes_szerveren_tarolt_adatmennyisegek.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL8 > ${OUTPUT_DIR}/${HOST}_SQL8.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL8 > ${OUTPUT_DIR}/${HOST}_Kliensek_szama_platformonkent.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL9 > ${OUTPUT_DIR}/${HOST}_SQL9.out +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL9 > ${OUTPUT_DIR}/${HOST}_Storage_poolok_parameterei.out 
-    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL10 > ${OUTPUT_DIR}/${HOST}_SQL10.out+    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL10 > ${OUTPUT_DIR}/${HOST}_Inaktiv_node-ok_listaja_merettel.out 
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL11 > ${OUTPUT_DIR}/${HOST}_Inaktiv_node-ok_szama.out
 fi fi
  
Sor 94: Sor 101:
  prtconf > ${OUTPUT_DIR}/${HOST}_prtconf.out  prtconf > ${OUTPUT_DIR}/${HOST}_prtconf.out
  ifconfig -a > ${OUTPUT_DIR}/${HOST}_ifconfig-a.out  ifconfig -a > ${OUTPUT_DIR}/${HOST}_ifconfig-a.out
 + netstat -nr > ${OUTPUT_DIR}/${HOST}_netstat-nr.out
  lsdev -Cc disk > ${OUTPUT_DIR}/${HOST}_lsdev_disk.out  lsdev -Cc disk > ${OUTPUT_DIR}/${HOST}_lsdev_disk.out
  lsdev -Cc tape > ${OUTPUT_DIR}/${HOST}_lsdev_tape.out  lsdev -Cc tape > ${OUTPUT_DIR}/${HOST}_lsdev_tape.out
Sor 100: Sor 108:
  lslpp -l > ${OUTPUT_DIR}/${HOST}_lslpp.out  lslpp -l > ${OUTPUT_DIR}/${HOST}_lslpp.out
  lsvg > ${OUTPUT_DIR}/${HOST}_lsvg.out  lsvg > ${OUTPUT_DIR}/${HOST}_lsvg.out
 +        lsvg | xargs lsvg > ${OUTPUT_DIR}/${HOST}_lsvg-all.out
 +        lsvg | xargs lsvg -l > ${OUTPUT_DIR}/${HOST}_lsvg-l.out
 +        lsvg | xargs lsvg -p > ${OUTPUT_DIR}/${HOST}_lsvg-p.out
  lsps -s > ${OUTPUT_DIR}/${HOST}_lsps.out  lsps -s > ${OUTPUT_DIR}/${HOST}_lsps.out
  oslevel -s > ${OUTPUT_DIR}/${HOST}_oslevel.out  oslevel -s > ${OUTPUT_DIR}/${HOST}_oslevel.out
Sor 112: Sor 123:
  cat /proc/version > ${OUTPUT_DIR}/${HOST}_version.out  cat /proc/version > ${OUTPUT_DIR}/${HOST}_version.out
         ifconfig -a > ${OUTPUT_DIR}/${HOST}_ifconfig-a.out         ifconfig -a > ${OUTPUT_DIR}/${HOST}_ifconfig-a.out
 + netstat -nr > ${OUTPUT_DIR}/${HOST}_netstat-nr.out
  lspci -vvknnqq > ${OUTPUT_DIR}/${HOST}_lspci.out  lspci -vvknnqq > ${OUTPUT_DIR}/${HOST}_lspci.out
  lvs > ${OUTPUT_DIR}/${HOST}_lvs.out   lvs > ${OUTPUT_DIR}/${HOST}_lvs.out