CA MICS Tape Analyzer Option (TAP) Queries › IBM TS77xx Virtual Tape Server Queries › TS7HBA – IBM TS77xx Daily Host Channel I/O and HBA Compression Analysis › Query Defaults

Query Defaults

• HVTVAP DAYS timespan file: Cycles 01-02
  • HVTVAP file filtered to select CLUSTER 0 only
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  FICONMBS

  100
  

  TOTRATIO

  IF VAPVRW THEN TOTRATIO=ROUND((VAPCRW/VAPVRW),0.01)  ;
  ELSE TOTRATIO=0 ;