IVTPTU - Physical Tape Usage File
The Physical Tape Usage file contains detailed physical tape drive activity and usage statistics for distributed VTSs (standalone, UI, and secondary).
micsrm140
The IVTPTU file is created from statistics in SMF type 94 subtype 1 records.
At the DETAIL and DAYS timespans, the file provides hourly physical tape drive statistics at the Physical Tape Drive Type (IVTDCI) level.
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.IVTPTU Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL | N/A | | | | | DAYS |SYSID IVTCMPID IVTTYPE IVTVLS IVTDCI | | |YEAR MONTH DAY HOUR | | | | | WEEKS |SYSID IVTCMPID IVTTYPE IVTVLS IVTDCI | | |YEAR WEEK ZONE HOUR | | | | | MONTHS |SYSID IVTCMPID IVTTYPE IVTVLS IVTDCI | | |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 or not.
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 IVTDCI - Physical Tape Drive Device Class .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 Retained Data Elements .D....E PTUPDI - Physical Drives Installed Accumulated Data Elements .DWM..E PTUPDW - Data Written to Physical Media (MB) .DWM..E PTUPDWP - Data Written to Primary Pool (MB) .DWM..E PTUPDWS - Data Written to Secondary Pool (MB) .DWM..E PTUPMIG - Physical Migrate (Copy) Mounts .DWM..E PTUPMTM - Total Physical Mount Time .DWM..E PTUPREC - Physical Reclaim Mounts .DWM..E PTUPSDE - Physical Secure Data Erase Mounts .DWM..E PTUPSTG - Physical Stage (Recall) Mounts .DWM..E PTUSPCM - Sum of Avg Physical Drives Concur Mounte .DWM..E PTUSPDA - Sum of Physical Drives Available .DWM..E PTUTPM - Total Physical Mounts Minimum Data Elements .DWM..E PTUMNPCM - Min Physical Drives Concur Mounted .DWM..E PTUMNPDA - Min Physical Drives Available .DWM..E PTUMNPMT - Min Physical Mount Time Maximum Data Elements .DWM..E PTUMXPCM - Max Physical Drives Concur Mounted .DWM..E PTUMXPDA - Max Physical Drives Available .DWM..E PTUMXPMT - Max Physical Mount Time Derived Data Elements .DWM..E PTUAVPCM - Avg Physical Drives Concur Mounted .DWM..E PTUAVPDA - Avg Physical Drives Available .DWM..E PTUAVPM - Avg Physical Mounts .DWM..E PTUAVPMT - Avg Physical Mount Time .DWM..E PTUAVPW - Avg Data Written to Physical Media (MB) .DWM..E PTUAVPWP - Avg Data Written to Primary Pool (MB) .DWM..E PTUAVPWS - Avg Data Written to Secondary Pool (MB)
For a detailed description of individual data dictionary elements, see VTS Physical Drive Activity File (IVTPTU).
Usage Considerations
This section identifies any special considerations or techniques related to using the IVTPTU file.
The overall physical tape drive statistics for distributed VTSs (standalone, UI, and secondary) are contained in the VTS Distributed Library Activity (IVTVDL) file.
The IVTPTU file contains a further breakdown of physical tape usage by Physical Tape Drive Type (IVTDCI). This file is only created for VTSs that are operating at the IBM function code F/C 4001 level.
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 IVTPTU file, show the quantity of physical mounts (total and by type), and the total, MIN, MAX, and AVG mount times for each hour of the day.Generate a single page for each distributed VTS (UI, secondary, and standalone).DATA; SET &pIVTd..IVTPTU01; DATE=DATEPART(ENDTS) ; FORMAT DATE DATE8. ; * ; PROC PRINT LABEL ; PAGEBY IVTVLS ; BY IVTCMPID IVTTYPE IVTVLS DATE ; ID HOUR ; VAR PTUTPM PTUPSTG PTUPMIG PTUPREC PTUPSDE PTUPMTM PTUMXPMT PTUMNPMT PTUAVPMT ; TITLE1 'Daily Physical Mounts and Times by HOUR' ; RUN ;