SVTVGR - Virtual Tape Volume Migrate Request File

At the DETAIL timespan, the Virtual Tape Volume Migrate Request File describes the event where a virtual tape volume is requested to be migrated to a multivolume cartridge.
micsrm140
The Virtual Tape Volume Migrate Request File is derived from the VTSS user SMF record, subtype 18. This record is produced for every virtual tape volume that is migrated to real tape.
The SVTVGR file contains interesting metrics pertaining to the migration reason and the elapsed time since the virtual volume was last mounted on a virtual tape drive (ie; disk buffer residency time). Also, the file can be used to determine migration durations, frequency of migrations, and migrated data volume.

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.
SVTVGR Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL |SYSID VTSSID VTSSMCL VTSSSCL YEAR | | |MONTH DAY HOUR ENDTS | | | | | DAYS |SYSID VTSSID VTSSMCL VTSSSCL YEAR | | |MONTH DAY HOUR | | | | | WEEKS |SYSID VTSSID VTSSMCL VTSSSCL YEAR | | |WEEK ZONE HOUR | | | | | MONTHS |SYSID VTSSID VTSSMCL VTSSSCL YEAR | | |MONTH ZONE | | | | | YEARS | N/A | | | | +---------+-------------------------------------------------+ | TABLES | N/A | +---------+-------------------------------------------------+ Generation Date: Tue, May 12, 2009
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 table below identifies data elements contained in this file.
GENERATION DATE: Tue, Jun 11, 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 XDW...E HOUR - Hour of Day XD.M..E MONTH - Month of Year XDWM..E SYSID - System Identifier XDWM..E VTSSID - VTSS ID XDWM..E VTSSMCL - VTV Management Class XDWM..E VTSSSCL - MVC Storage Class 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 ENDTS - End Time Stamp XDWM..E ORGSYSID - Originating System Identification XDWM..E STARTTS - Start Time Stamp X.....E SVTVTVPT - VTV Partition on MVC X.....E VTSSAID - Actual Volser from Vol1 Label X.....E VTSSCTP - Cartridge Type X.....E VTSSMID - MVC Volser ID X.....E VTSSRADR - RTD MVS Address X.....E VTSSRCID - RTD Channel Interface ID X.....E VTSSRID - RTD Device ID X.....E VTSSRLOC - RTD Location Name X.....E VTSSRTYP - RTD Device Type X..... VTSSSNS - RTD Sense Data XDWM..E VTSSTPX - TapePlex Name X.....E VTSSVID - VTV Volser ID Retained Data Elements X.....E VGRMET - Migrate End Timestamp X.....E VGRMST - Migrate Start Timestamp X.....E VGRMTP - Migrate Request Type X.....E VGRNPO - Next MVC Position (Block Id) X.....E VGRTIM - Last Time VTV Mount on VTD X.....E VGRVPO - VTV Position on the MVC (Block Id) Accumulated Data Elements XDWM..E VGRBCM - Virtual Tape Bytes Migrated XDWM..E VGRCOUNT - Total VTVs Migrated XDWM..E VGRMSZ - Uncompressed Size of the VTV (Bytes) XDWM..E VGRMTA - Total Migrate Requests (Auto) XDWM..E VGRMTC - Total Migrate Requests (Consolidate) XDWM..E VGRMTD - Total Migrate Requests (Demand) XDWM..E VGRMTI - Total Migrate Requests (Immediate) XDWM..E VGRMTM - Migrate Time XDWM..E VGRMTOTH - Total Migrate Requests (Other) XDWM..E VGRMTR - Total Migrate Requests (Reclaim) XDWM..E VGRMTX - Total Migrate Requests (Export) XDWM..E VGRRTDER - RTD Error count XDWM..E VGRSCTPO - Other Cartridge Migrate Requests XDWM..E VGRSECT - 800MB (E) Cartridge Migrate Requests XDWM..E VGRSSCT - 400MB (S) Cartridge Migrate Requests XDWM..E VGRS2GB - 2000MB Cartridge Migrate Requests XDWM..E VGRS4GB - 4000MB Cartridge Migrate Requests Minimum Data Elements XDWM..E VGRMNMTM - Min Migrate Time Maximum Data Elements XDWM..E VGRMXMTM - Max Migrate Time Derived Data Elements XDWM..E VGRAVMTM - Avg Migrate Time XDWM..E VGRPCERR - Pct RTD Migrate Errors XDWM..E VGRPCMTA - Pct Migrate Request (Auto) XDWM..E VGRPCMTC - Pct Migrate Request (Consolidate) XDWM..E VGRPCMTD - Pct Migrate Request (Demand) XDWM..E VGRPCMTI - Pct Migrate Request (Immediate) XDWM..E VGRPCMTO - Pct Migrate Request (Other) XDWM..E VGRPCMTR - Pct Migrate Request (Reclaim) XDWM..E VGRPCMTX - Pct Migrate Request (Export)
For a detailed description of individual data dictionary elements, see Virtual Tape Volume Migrate Activity File (SVTVGR).

Usage Considerations

The SVTVGR file and Virtual Tape Volume Recall Activity (SVTVRR) file contain data useful for hourly trend analysis.
Sometimes, migrations occur immediately after VTV is created. In other cases, policies delay migration until certain criteria are met. For example, delaying migrations during peak batch activity times or until the disk buffer approaches full capacity.

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 examples, a database identifier of P is used. The identifier is installation-dependent, so you should find out what the identifiers are at your installation.
  • Generate a report displaying VTV migration activity by hour.
    %LET BY = SYSID VTSSID VTSSSCL HOUR; %LET BREAK = HOUR; PROC SORT DATA=&psvtd..SVTVGR01 OUT=VGR; BY &BY; RUN; DATA VGR2; SET VGR; VGRMSZ=VGRMSZ/(1024*1024); %VGRSUM(SUMBY=&BY, SUMBREAK=&BREAK); RUN; PROC PRINT DATA=VGR2 LABEL NOOBS; BY SYSID VTSSID; VAR SYSID VTSSID VTSSSCL HOUR VGRCOUNT VGRAVMTM VGRMXMTM VGRMTA VGRMTI VGRMTD VGRMTR VGRMTC VGRMTX VGRMSZ; FORMAT VGRMSZ COMMA12.2; LABEL VGRMSZ='Uncompressed Size of VTV (MB)'; TITLE 'VTV Migration Activity'; RUN;
    Note:
    Drop storage class from the BY and VAR statements to get gross mounts by SYSID and VTSSID.