HVTHCL - Hydra Cloud Pool Activity File
The Hydra Cloud Pool Activity file contains statistics for the amount of object data in the cloud pool, including statistics for read, write, delete, and look-up activity in this platform.
micsrm140
The information in the HVTHCL file is obtained from the Hnode Cloud Historical Record, type 35, from the BVIR extract.
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.HVTHCL Sort Sequence and Data Granularity
+-------------+---------------------------------------------+ | HVTHCL | | | DETAIL |SYSID HVTGRID HVTCLID HCLID HCLNIKNM | | |YEAR MONTH DAY HOUR ENDTS | | +---------------------------------------------+ | DAYS |SYSID HVTGRID HVTCLID HCLID HCLNIKNM | | |YEAR MONTH DAY HOUR | | +---------------------------------------------+ | WEEKS |SYSID HVTGRID HVTCLID HCLID HCLNIKNM | | |YEAR WEEK ZONE HOUR | | +---------------------------------------------+ | MONTHS |SYSID HVTGRID HVTCLID HCLID HCLNIKNM | | |YEAR MONTH ZONE | | +---------------------------------------------+ | YEARS |* N/A * | + - - - - - - +---------------------------------------------+ | TABLES |* N/A * | +-------------+---------------------------------------------+
Generation Date: Fri, May 7, 2021
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. Whether data elements are kept on the file on auxiliary storage or not is controlled by the complex definition of the DERIVED option
Data Elements List
The following table identifies data elements contained in this file.
GENERATION DATE: Fri, May 7, 2021 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 XDWM..E HCLID - Cloud Pool ID XDWM..E HCLNIKNM - Cloud Pool Nickname XDW...E HOUR - Hour of Day XDWM..E HVTCLID - Cluster ID XDWM..E HVTGRID - Grid Composite 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 HCLDCT24 - # Objects Eligible for Delete in 24 Hrs XDWM..E HCLDCT36 - # Objects Eligible for Delete in 36 Hrs XDWM..E HCLDCT48 - # Objects Eligible for Delete in 48 Hrs XDWM..E HCLDCT6 - # Objects Eligible for Delete in 6 Hrs XDWM..E HCLDCT72 - # Objects Eligible for Delete in 72 Hrs XDWM..E HCLDSZ24 - Size Obj Elig Del in 24 Hrs (GB) XDWM..E HCLDSZ36 - Size Obj Elig Del in 36 Hrs (GB) XDWM..E HCLDSZ48 - Size Obj Elig Del in 48 Hrs (GB) XDWM..E HCLDSZ6 - Size Obj Elig Del in 6 Hrs (GB) XDWM..E HCLDSZ72 - Size Obj Elig del in 72 Hrs (GB) XDWM..E HCLOBDEL - # Objects Deleted From Cloud Pool XDWM..E HCLOBJCT - Sum of # Objects in Cloud Pool XDWM..E HCLOBJRT - # Retained Objects in Cloud Pool XDWM..E HCLOBJSZ - Size of Objects in Cloud Pool (GB) XDWM..E HCLOBLKU - # Object Look-ups in Cloud Pool XDWM..E HCLOBRCT - # Objects Read in Cloud Pool XDWM..E HCLOBRSZ - Size of Objs Read in Cloud Pl (KB) XDWM..E HCLOBWCT - # Objects Written to Cloud Pool XDWM..E HCLOBWSZ - Size of Objs Written to Cloud Pl (KB) X.....E HCLRTDUR - # Days to Retain Version of Data XDWM..E HCLRTNSZ - Size of Retained Objs in Cloud Pl (GB) XDWM..E HCLSTRO - # Intervals Pool in Read Only State XDWM..E HCLSTRW - # Intervals Pool in Read/Write State Derived Data Elements XDWM..E HCLAVD24 - Avg # Objects Elig for Delete in 24 Hrs XDWM..E HCLAVD36 - Avg # Objects Elig for Delete in 36 Hrs XDWM..E HCLAVD48 - Avg # Objects Elig for Delete in 48 Hrs XDWM..E HCLAVD6 - Avg # Objects Elig for Delete in 6 Hrs XDWM..E HCLAVD72 - Avg # Objects Elig for Delete in 72 Hrs XDWM..E HCLAVOBJ - Avg # Objects in Cloud Pool XDWM..E HCLAVODL - Avg # Objects Deleted From Cloud Pool XDWM..E HCLAVOLU - Avg # Object Look-ups in Cloud Pool XDWM..E HCLAVORD - Avg # Objects Read in Cloud Pool XDWM..E HCLAVORT - Avg # Retained Objects in Cloud Pool XDWM..E HCLAVOSZ - Avg Size of Objs in Cloud Pool (GB) XDWM..E HCLAVOWT - Avg # Objects Written to Cloud Pool XDWM..E HCLAVRSZ - Avg Size of Obj Read in Cloud Pl (KB) XDWM..E HCLAVS24 - Avg Size Obj Elig del in 24 Hrs (GB) XDWM..E HCLAVS36 - Avg Size Obj Elig del in 36 Hrs (GB) XDWM..E HCLAVS48 - Avg Size Obj Elig del in 48 Hrs (GB) XDWM..E HCLAVS6 - Avg Size Obj Elig del in 6 Hrs (GB) XDWM..E HCLAVS72 - Avg Size Obj Elig del in 72 Hrs (GB) XDWM..E HCLAVTSZ - Avg Size of Rtnd Objs in Cloud Pool (GB) XDWM..E HCLAVWSZ - Avg Size of Obj Wrttn in Cloud Pl (KB)
Usage Considerations
This section identifies any special considerations or techniques related to using the HVTHCL file:
None
Retrieval Examples
- Use the most recent DAYS timespan HVTHCL file and display the number of volumes (physical and logical) and the megabytes of data that were exported and imported.The display is by HOUR by cluster. This may or may not be a routine activity. If not, this data can be trended using longer term data from the weeks or months timespans.DATA; SET &pHVTd..HVTHCL01; DATE=DATEPART(ENDTS) ; FORMAT DATE DATE8. ; * ; PROC PRINT LABEL ; PAGEBY HVTCLID ; BY HVTCLID HCLNIKNM DATE; ID HOUR VAR HCLAVOBJ HCLAVORT HCLAVOWT HCLAVORD HCLAVODL HCLAVOLU HCLAVOSZ HCLAVTSZ HCLAVWSZ HCLAVRSZ ; TITLE1 'Daily I/O Cloud Pool Activity by HOUR' ; RUN ; * ; PROC PRINT LABEL ; PAGEBY HVTCLID ; BY HVTCLID HCLNIKNM DATE; ID HOUR VAR HCLAVOSZ HCLAVTSZ HCLAVWSZ HCLAVRSZ ; TITLE1 'Daily I/O Cloud Pool Activity by HOUR' ; RUN ;