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:riportok:gather_data [2017/05/18 15:34] – ↷ Page moved from shell:gather_data to shell:riportok:gather_data adminshell:riportok:gather_data [2022/09/05 11:18] – admin
Sor 20: 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 71: Sor 72:
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q stg" > ${OUTPUT_DIR}/${HOST}_q_stg.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q stg" > ${OUTPUT_DIR}/${HOST}_q_stg.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q stg f=d" > ${OUTPUT_DIR}/${HOST}_q_stg_fd.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q stg f=d" > ${OUTPUT_DIR}/${HOST}_q_stg_fd.out
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q stgpooldir f=d" > ${OUTPUT_DIR}/${HOST}_q_stgpooldir_fd.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q sch" > ${OUTPUT_DIR}/${HOST}_q_sch.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q sch" > ${OUTPUT_DIR}/${HOST}_q_sch.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q sch f=d" > ${OUTPUT_DIR}/${HOST}_q_sch_fd.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q sch f=d" > ${OUTPUT_DIR}/${HOST}_q_sch_fd.out
Sor 80: Sor 82:
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q n" > ${OUTPUT_DIR}/${HOST}_q_node.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q n" > ${OUTPUT_DIR}/${HOST}_q_node.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q n f=d" > ${OUTPUT_DIR}/${HOST}_q_node_fd.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q n f=d" > ${OUTPUT_DIR}/${HOST}_q_node_fd.out
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q replnode" > ${OUTPUT_DIR}/${HOST}_q_replnode_fd.out
  
     echo "TSM-es SELECT-eket futtatok..."     echo "TSM-es SELECT-eket futtatok..."