SVTVXR - Virtual Tape Volume Delete Request File

At the DETAIL timespan, the Virtual Tape Volume Delete Request File provides information about virtual tape volume delete requests. It is derived from the VTSS user SMF record, subtype 15. This record is produced for each virtual tape volume that is deleted from the disk buffer.
micsrm140
At the DETAIL timespan, the Virtual Tape Volume Delete Request File provides information about virtual tape volume delete requests. It is derived from the VTSS user SMF record, subtype 15. This record is produced for each virtual tape volume that is deleted from the disk buffer.

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.
SVTVXR Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL |SYSID VTSSID VTSSMCL YEAR MONTH | | |DAY HOUR ENDTS | | | | | DAYS |SYSID VTSSID VTSSMCL YEAR MONTH | | |DAY HOUR | | | | | WEEKS |SYSID VTSSID VTSSMCL YEAR WEEK | | |ZONE HOUR | | | | | MONTHS |SYSID VTSSID VTSSMCL 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, May 12, 2009 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 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 VTSSCTP - Cartridge Type X.....E VTSSVID - VTV Volser ID Retained Data Elements X.....E VXRLRI - Last Residency Indicator X.....E VXRLTR - Time VTV Last Referenced X.....E VXRRSN - VTV Delete Reason Code X.....E VXRTIM - VTV Creation Time Accumulated Data Elements XDWM..E VXRAGE - Age of VTV Since Creation XDWM..E VXRCON - VTV Consolidated Count XDWM..E VXRCOUNT - Total VTVs Deleted XDWM..E VXRDSC - VTV Deleted on Scratch Count XDWM..E VXRDSU - VTV Deleted by DELETSCR Count XDWM..E VXRIMP - VTV Deleted by Import Count XDWM..E VXRLAGE - Age of VTV Since Last Used XDWM..E VXRLRC - Last Residency Create Count XDWM..E VXRLRR - Last Residency Recall Count XDWM..E VXRMPR - VTV Previously Migrated Count XDWM..E VXRNMM - VTV Migrated then Deleted Count XDWM..E VXROLD - VTV Invalid VTV Version Count XDWM..E VXRSCTPO - Other Cartridge Delete Requests XDWM..E VXRSECT - 800MB (E) Cartridge Delete Requests XDWM..E VXRSPR - VTV Reclaimed Count XDWM..E VXRSSCT - 400MB (S) Cartridge Delete Requests XDWM..E VXRS2GB - 2GB Cartridge Delete Requests XDWM..E VXRS4GB - 4GB Cartridge Delete Requests Minimum Data Elements XDWM..E VXRMNAGE - Min Age of VTV Since Creation XDWM..E VXRMNLAG - Min Age of VTV Since Last Used Maximum Data Elements XDWM..E VXRMXAGE - Max Age of VTV Since Creation XDWM..E VXRMXLAG - Max Age of VTV Since Last Used Derived Data Elements XDWM..E VXRAVAGE - Avg Age of VTV Since Creation XDWM..E VXRAVLGE - Avg Age of VTV Since Last Used
For a detailed description of individual data dictionary elements, see Virtual Tape Volume Delete Activity File (SVTVXR).

Usage Considerations

The SVTVXR file contains interesting metrics regarding the reason for deletion, to the delete reasons, age of the deleted virtual tape volume, and whether the deleted volume was in the disk buffer since creation, or had been recalled.

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 virtual tape deletion activity, average age of the VTV and the reason for deletion.
    %LET BY = SYSID VTSSID VTSSMCL HOUR; %LET BREAK = HOUR; PROC SORT DATA=&psvtd..SVTVXR01 OUT=VXR; BY &BY; RUN; DATA VXR2; SET VXR; %VXRSUM(SUMBY=&BY, SUMBREAK=&BREAK); RUN; PROC PRINT DATA=VXR2 LABEL NOOBS; BY SYSID VTSSID; VAR SYSID VTSSID VTSSMCL HOUR VXRCOUNT VXRAVAGE VXRNMM VXRMPR VXRSPR VXRCON VXROLD VXRDSC VXRIMP VXRDSU; TITLE 'VTV Deletion Activity';
    Note:
    Drop management class from the BY and VAR statements to get gross mounts by SYSID and VTSSID.