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
shell:riportok:gather_data [2017/05/18 15:34] – ↷ Page moved from shell:gather_data to shell:riportok:gather_data adminshell:riportok:gather_data [2023/03/24 16:53] (aktuális) – admin
Sor 14: Sor 14:
  
 HOST=$(hostname) HOST=$(hostname)
-DSMADMCOPTS="-se=$TSMSERVER"+DSMADMCOPTS="-se=$TSMSERVER" # -dataonly=y"
  
 # Az elmult 7 nap aktivitasa tipusonken:t # Az elmult 7 nap aktivitasa tipusonken:t
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 30: Sor 31:
 SQL7="SELECT CAST(FLOAT(SUM(backup_mb))/1024 as DEC(8,0)) as BACKUP_GB, CAST(FLOAT(SUM(backup_copy_mb))/1024 as DEC(8,0)) as BACKUP_COPY_GB, CAST(FLOAT(SUM(archive_mb))/1024 as DEC(8,0)) as ARCHIVE_GB, CAST(FLOAT(SUM(archive_copy_mb))/1024 as DEC(8,0)) as ARCHIVE_COPY_GB, CAST(FLOAT(SUM(total_mb))/1024 as DEC(8,0)) as TOTAL_GB from auditocc" SQL7="SELECT CAST(FLOAT(SUM(backup_mb))/1024 as DEC(8,0)) as BACKUP_GB, CAST(FLOAT(SUM(backup_copy_mb))/1024 as DEC(8,0)) as BACKUP_COPY_GB, CAST(FLOAT(SUM(archive_mb))/1024 as DEC(8,0)) as ARCHIVE_GB, CAST(FLOAT(SUM(archive_copy_mb))/1024 as DEC(8,0)) as ARCHIVE_COPY_GB, CAST(FLOAT(SUM(total_mb))/1024 as DEC(8,0)) as TOTAL_GB from auditocc"
 # Kliensek darabszama platformonkent # Kliensek darabszama platformonkent
-SQL8="SELECT platform_name,COUNT(*) as COUNT FROM nodes GROUP BY platform_name"+SQL8="SELECT platform_name,COUNT(*) as COUNT FROM nodes where locked='NO' GROUP BY platform_name"
 # Storage poolok devclass-sal, library-vel, merettel # Storage poolok devclass-sal, library-vel, merettel
 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(lastac +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)>$INAKTIV_NODE_NAPSZAM GROUP BY oc.node_name order by last_access" 
-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 +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" 
-)-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" +# Direkt tape mountok 
-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 +SQL12="select substr(message,instr(message,' ',1,6)+1,instr(message,' ',1,7)-instr(message,' ',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(message,' ',1,6)+1,1)!='/') and current_timestamp < date_time + 7 days group by substr(message,instr(message,' ',1,6)+1,instr(message,' ',1,7)-instr(message,' ',1,6)-1)" 
-) 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 64: Sor 65:
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q drive" > ${OUTPUT_DIR}/${HOST}_q_drive.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q drive" > ${OUTPUT_DIR}/${HOST}_q_drive.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q drive f=d" > ${OUTPUT_DIR}/${HOST}_q_drive_fd.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q drive f=d" > ${OUTPUT_DIR}/${HOST}_q_drive_fd.out
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q fi" > ${OUTPUT_DIR}/${HOST}_q_fi.out
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q fi f=d" > ${OUTPUT_DIR}/${HOST}_q_fi_fd.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q path" > ${OUTPUT_DIR}/${HOST}_q_path.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q path" > ${OUTPUT_DIR}/${HOST}_q_path.out
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q path f=d" > ${OUTPUT_DIR}/${HOST}_q_path_fd.out     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS "q path f=d" > ${OUTPUT_DIR}/${HOST}_q_path_fd.out
Sor 71: Sor 74:
     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 84:
     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..."
Sor 93: Sor 98:
     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL10 > ${OUTPUT_DIR}/${HOST}_Inaktiv_node-ok_listaja_merettel.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     dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL11 > ${OUTPUT_DIR}/${HOST}_Inaktiv_node-ok_szama.out
 +    dsmadmc -id=$TSMUSER -pa=$TSMPASS $DSMADMCOPTS $SQL12 > ${OUTPUT_DIR}/${HOST}_Direkt_tape_mountok_szama.out
 fi fi
  
Sor 105: Sor 111:
  lsdev -Cc adapter > ${OUTPUT_DIR}/${HOST}_lsdev_adapter.out  lsdev -Cc adapter > ${OUTPUT_DIR}/${HOST}_lsdev_adapter.out
  lscfg > ${OUTPUT_DIR}/${HOST}_lscfg.out  lscfg > ${OUTPUT_DIR}/${HOST}_lscfg.out
 + lsconf > ${OUTPUT_DIR}/${HOST}_lsconf.out
  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