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
sql [2018/05/16 15:53] – [Hibakereséshez] adminsql [2019/09/16 15:30] – [Egyéb] admin
Sor 139: Sor 139:
  
   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   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
 +
 +===Node-ok tárolt adatmennyisége primary poolokban===
 +
 +  select NODE_NAME, case when sum(REPORTING_MB)/1024 < 1024 then sum(REPORTING_MB)/1024 || ' G' else sum(REPORTING_MB)/1024/1024 || ' T' end as PRIMARY_GB from occupancy where STGPOOL_NAME in (select STGPOOL_NAME from stgpools where pooltype='PRIMARY') group by node_name order by sum(REPORTING_MB) desc
  
 ===Inaktív node-ok, és tárolt adatmennyiségük=== ===Inaktív node-ok, és tárolt adatmennyiségük===
Sor 188: Sor 192:
 </WRAP> </WRAP>
  
 +=== Node-ok megőrzési idejei ===
 +
 +<WRAP>
 +<file>
 +select n.node_name as Node, n.domain_name as "Domain", cast((m.set_name) as char (7)) as Set, \
 +m.class_name as MgmtClass, assoc.schedule_name as "Schedule", cast((m.defaultmc) as char(6)) as Deflt, \
 +cast((verexists) as char(8)) as "VerEx", cast((verdeleted) as char(8)) as "VerDel", \
 +cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly" from nodes as n, \
 +mgmtclasses as m, bu_copygroups as c, associations as assoc where n.domain_name=m.domain_name and \
 +m.domain_name=c.domain_name and m.set_name=c.set_name and m.class_name=c.class_name \
 +and m.set_name='ACTIVE' and assoc.node_name=n.node_name order by n.node_name,n.domain_name,Set,MgmtClass
 +</file>
 +</WRAP>
 ==== Hasznos TSM SQL oldalak ==== ==== Hasznos TSM SQL oldalak ====
   * [[http://www.tsmadmin.com/p/my-sql-querries.html|TSMAdmin: My SQL queries]]   * [[http://www.tsmadmin.com/p/my-sql-querries.html|TSMAdmin: My SQL queries]]