HVTGCC - Hnode Grid Cluster Activity File

The Hydra Grid Cluster Activity file contains statistics on the volume of data copied to and read from another cluster's cache, and tape mounts in the remote cluster on behalf of the current cluster.
micsrm140
The Hydra Grid Cluster Activity file is derived from the IBM Virtualization Engine TS7700 Series Statistical Data, Hnode Grid Historical Record. This record is produced every 15 minutes.

File Organization

The table below identifies data elements by which the file is sequenced and summarized in each timespan. N/A indicates that the file is not supported in a timespan. At the DETAIL level, data is sequenced but not summarized.
The timespans in which a file is supported are defined by each installation when
MICS
is installed. Therefore, this table has been generated as part of the installation process to accurately reflect the
MICS
system at your installation.
HVTGCC Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL |SYSID HVTGRID HVTCLID HVTNODE HVTDCL | | |YEAR MONTH DAY HOUR ENDTS | | | | | DAYS |SYSID HVTGRID HVTCLID HVTNODE HVTDCL | | |YEAR MONTH DAY HOUR | | | | | WEEKS |SYSID HVTGRID HVTCLID HVTNODE HVTDCL | | |YEAR WEEK ZONE HOUR | | | | | MONTHS |SYSID HVTGRID HVTCLID HVTNODE HVTDCL | | |YEAR MONTH ZONE | | | | | YEARS | N/A | | | | +---------+-------------------------------------------------+ | TABLES | N/A | +---------+-------------------------------------------------+ Generation Date: Thu, Apr 1, 2010
This file was generated with ESSENTIAL=ALL option in effect. All data elements that are defined in the file are generated.
This file was generated with DERIVED=DEFault option in effect. The complex definition of the DERIVED option controls whether the data elements are kept on the file on auxiliary storage.

Data Elements List

The following table identifies data elements that are contained in this file.
GENERATION DATE: Thu, Apr 1, 2010 Note: Essential data elements are identified by an "E" under the Timespan asterisk (*) column. Time- Data Data Element Span * Element Description (LABEL) ------- -------- ---------------------------------------- Sequence/Summary Data Elements XD....E DAY - Day of Month XDW...E HOUR - Hour of Day XDWM..E HVTCLID - Cluster ID XDWM..E HVTDCL - Distributed Cluster Number XDWM..E HVTGRID - Grid Composite ID XDWM..E HVTNODE - Node ID XD.M..E MONTH - Month of Year XDWM..E SYSID - System Identifier XDW...E WEEK - Week of Year XDWM..E YEAR - Year of Century XDWM..E ZONE - Time Zone Common Data Elements XD....E DAYNAME - Name of Day of Week XDWM..E DURATION - Recording Interval Time XDWM..E ENDTS - End Time Stamp XDWM..E HVTDLSN - Distributed Library Sequence Number XDWM..E HVTMODEL - Node Machine Model XDWM..E HVTMTYPE - Node Machine Type XD....E HVTRVN - Record Version Number XDWM..E HVTSN - Node Serial Number XDWM..E HVTVECD - VE Code Level XDWM..E INTERVLS - Number of Recording Intervals XD....E ORGSYSID - Originating System Identification XDWM..E STARTTS - Start Time Stamp Accumulated Data Elements XDWM..E GCCDCP - Total I/O Data Copied (MB) XDWM..E GCCDTI - Data Trans from Other Cluster (MB) XDWM..E GCCDTR - Data Trans to Other Cluster (MB) XDWM..E GCCLMC - Logical Mounts to Other Cluster XDWM..E GCCRRO - Data Trans Remote Read Operation (MB) XDWM..E GCCRWO - Data Trans Remote Write Operation (MB) Maximum Data Elements XDWM..E GCCMXDCP - Max Data Copied (MB) Derived Data Elements XDWM..E GCCAVDCP - Avg Data Copied per Interval (MB) XDWM..E GCCAVDTI - Avg Data Trans from Other Cluster (MB) XDWM..E GCCAVDTR - Avg Data Trans to Other Cluster (MB) XDWM..E GCCAVLMC - Avg Logical Mounts to Other Cluster XDWM..E GCCAVRRO - Avg Data Trans Remote Read Opr (MB) XDWM..E GCCAVRWO - Avg Data Trans Remote Write Opr (MB) XDWM..E GCCPSDCP - Data Copied per Second (MB)
For a detailed description of individual data dictionary elements, see Hydra Hnode Grid Cluster Activity (HVTGCC).

Usage Considerations

None

Retrieval Examples

In the examples, a SAS macro variable is used to specify the DDname part of the
MICS
file name. These macro variables are a standard part of
MICS
and are available for all files. The macro variable name has the form &diiit, where d is the database identifier, iii is the information area name, and t is the timespan. For the example, a database identifier of P is used. The identifier is installation-dependent, so you should find out what the identifiers are at your installation.
  • Using the most recent DAYS timespan HVTGCC file, display the total megabytes of data transferred between clusters in the grid.
    DATA; SET &pHVTd..HVTGCC01; DATE=DATEPART(ENDTS) ; FORMAT DATE DATE8. ; * ; PROC TABULATE ; BY DATE; CLASS HVTCLID HVTDCL HOUR ; VAR GCCDCP ; TABLE HVTCLID, HVTDCL*GCCDCP / RTS=20; TITLE 'Total I/O Between Clusters in Grid'; RUN;