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
sql [2025/05/21 13:23] – [Hibakereséshez] adminsql [2026/01/22 11:24] (aktuális) – admin
Sor 46: Sor 46:
 === Problémás, nem kivett szalagok === === Problémás, nem kivett szalagok ===
  
-  select substr(v.stgpool_name,1,15) as stgpool_name, substr(v.devclass_name,1,10) as devclass_name, substr(v.volume_name,1,8) as volume_name, v.pct_utilized, substr(v.status,1,10) as status, substr(v.access,1,11) as access, coalesce(cast(lv.home_element as varchar(20)), 'not in libvolumes') as home_element from volumes v left join (select volume_name, home_element from (select volume_name, home_element, row_number() over (partition by volume_name order by volume_name) as rn from libvolumes) as ranked where rn = 1) lv on lv.volume_name = v.volume_name where v.access != 'READWRITE' and v.stgpool_name not like 'OFF_%'+  select substr(v.volume_name,1,8) as volume_name, substr(v.stgpool_name,1,15) as stgpool_name, substr(v.devclass_name,1,10) as devclass_name, v.pct_utilized, substr(v.status,1,10) as status, substr(v.access,1,11) as access, coalesce(cast(lv.home_element as varchar(20)), 'not in libvolumes') as home_element from volumes v left join (select volume_name, home_element from (select volume_name, home_element, row_number() over (partition by volume_name order by volume_name) as rn from libvolumes) as ranked where rn = 1) lv on lv.volume_name = v.volume_name where v.access != 'READWRITE' and v.stgpool_name not like 'OFF_%'
  
 === TSM szerver crash időpontok keresése actlog szünetek alapján === === TSM szerver crash időpontok keresése actlog szünetek alapján ===
Sor 299: Sor 299:
   db2 "select (select nodename from nodes where nodeid=s.nodeid),hladdress,lladdress from schedule_node_addresses s"   db2 "select (select nodename from nodes where nodeid=s.nodeid),hladdress,lladdress from schedule_node_addresses s"
   db2 connect reset   db2 connect reset
 +
 +==== Library újradefiniálás ====
 +
 +  select substr('del path ' || SOURCE_NAME || ' ' || DESTINATION_NAME || ' SRCT=' || SOURCE_TYPE || ' DESTT=' || DESTINATION_TYPE || case when DESTINATION_TYPE='DRIVE' then ' LIBRARY=' || LIBRARY_NAME end,1,100) from paths
 +  select 'del dr ' || LIBRARY_NAME || ' ' || DRIVE_NAME from drives
 +  select 'def dr ' || LIBRARY_NAME || ' ' || DRIVE_NAME from drives
 +  select substr('def path ' || SOURCE_NAME || ' ' || DESTINATION_NAME || ' SRCT=' || SOURCE_TYPE || ' DESTT=' || DESTINATION_TYPE || case when DESTINATION_TYPE='DRIVE' then ' LIBRARY=' || LIBRARY_NAME end || ' DEVI=' || DEVICE,1,120) from paths
  
 ==== Front-End licenszelés ==== ==== Front-End licenszelés ====