IVTIEX - VTS Import/Export File
The VTS Import/Export file contains statistics relating to the import and export of physical cartridges and logical volumes for distributed VTSs (standalone, UI, and secondary). The IVTIEX file is created from statistics in SMF type 94 subtype 1 records.
micsrm140
The VTS Import/Export file contains statistics relating to the import and export of physical cartridges and logical volumes for distributed VTSs (standalone, UI, and secondary). The IVTIEX file is created from statistics in SMF type 94 subtype 1 records.
At the DETAIL and DAYS timespans, the file provides hourly import and export statistics for each distributed VTS.
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.IVTIEX Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL | N/A | | | | | DAYS |SYSID IVTCMPID IVTTYPE IVTVLS YEAR | | |MONTH DAY HOUR | | | | | WEEKS |SYSID IVTCMPID IVTTYPE IVTVLS YEAR | | |WEEK ZONE HOUR | | | | | MONTHS |SYSID IVTCMPID IVTTYPE IVTVLS 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 .D....E DAY - Day of Month .DW...E HOUR - Hour of Day .DWM..E IVTCMPID - Composite Library Association .DWM..E IVTTYPE - VTS Type .DWM..E IVTVLS - VTS Library Sequence Number .D.M..E MONTH - Month of Year .DWM..E SYSID - System Identifier .DW...E WEEK - Week of Year .DWM..E YEAR - Year of Century .DWM..E ZONE - Time Zone Common Data Elements .D....E DAYNAME - Name of Day of Week .DWM..E DURATION - Recording Interval Time .DWM..E ENDTS - End Time Stamp .DWM..E INTERVLS - Number of Recording Intervals .DWM..E IVTLMAN - System-Managed Tape Library Manufacturer .DWM..E IVTLMODL - System-Managed Tape Library Model .DWM..E IVTLPLNT - System-Managed Tape Library Plant .DWM..E IVTLTYPE - System-Managed Tape Library Type .DWM..E IVTPNM - Product Name .D....E IVTRVN - Version Number .D....E IVTSMFTM - Write to SMF Timestamp .DWM..E IVTSNO - System-Managed Tape Library Seq Number .DWM..E IVT4001 - F/C 4001 Indicator .D....E ORGSYSID - Originating System Identification .DWM..E STARTTS - Start Time Stamp .D....E SUBSYSID - JES Execution Subsystem ID Accumulated Data Elements .DWM..E IEXDE - Data Exported (MB) .DWM..E IEXDI - Data Imported (MB) .DWM..E IEXDME - Data Moved During Export (MB) .DWM..E IEXDMI - Data Moved During Import (MB) .DWM..E IEXLVE - Logical Volumes Successfully Exported .DWM..E IEXLVI - Logical Volumes Successfully Imported .DWM..E IEXPVE - Phys Volumes w/Exported Logical Vols .DWM..E IEXPVI - Phys Volumes Processed During Import Derived Data Elements .DWM..E IEXAVLVE - Avg Size Logical Volume Exported (MB) .DWM..E IEXAVLVI - Avg Size Logical Volume Imported (MB)
For a detailed description of individual data dictionary elements, see VTS Import/Export Statistics File (IVTIEX).
Usage Considerations
This section identifies any special considerations or techniques related to using the IVTIEX file.
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.- Using the most recent DAYS timespan IVTIEX display physical and logical volume import and export activity for each distributed VTS (UI, secondary, and standalone).Summarize the data by date, and generate a single page per DATE, with one line for each distributed VTS (UI, secondary, and standalone).DATA; %LET BY=%IEXSEQ(TS=DAYS) ; %LET SUMBY=DAY ; %LET BREAK=DAY ; * ; DATA; SET &pIVTd..IVTTCA01; DATE=DATEPART(ENDTS) ; FORMAT DATE DATE8. ; %IEXSUM ; * ; PROC SORT ; BY DATE ; * ; PROC PRINT LABEL ; BY DATE ; PAGEBY DATE ; ID IVTCMPID IVTVLS IVTTYPE ; VAR IEXPVI IEXLVI IEXDI IEXDMI IEXPVE IEXLVE IEXDE IEXDME ; TITLE1 'Overall Daily Import/Export Stats per VTS' ; RUN ;