IVTVPS - Volume Pool Statistics File
The Volume Pool Statistics file contains detailed cartridge utilization and volume count statistics for distributed VTSs (standalone, UI, and secondary).
micsrm140
The IVTVPS file is created from statistics in SMF type 94 subtype 2 records.
At the DETAIL and DAYS timespans, the file provides hourly cartridge statistics at the Volume Pool Identifier (IVTVPN) 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.IVTVPS Sort Sequence and Data Granularity
+---------+-------------------------------------------------+ |Timespan | Level of Data Granularity | +---------+-------------------------------------------------+ | | | | DETAIL | N/A | | | | | DAYS |SYSID IVTCMPID IVTTYPE IVTVLS IVTVPN | | |YEAR MONTH DAY HOUR | | | | | WEEKS |SYSID IVTCMPID IVTTYPE IVTVLS IVTVPN | | |YEAR WEEK ZONE HOUR | | | | | MONTHS |SYSID IVTCMPID IVTTYPE IVTVLS IVTVPN | | |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 .DWM..E IVTVPN - Volume Pool Identifier .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 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 VPSBPMI0 - Scratch Pool Media ID 0 .D....E VPSBPMI1 - Scratch Pool Media ID 1 .D....E VPSBPMI2 - Scratch Pool Media ID 2 .D....E VPSBPMI3 - Scratch Pool Media ID 3 .D....E VPSLRTS - Last Reconcile Timestamp .DWM..E VPSMI0 - Media Identifier 0 .DWM..E VPSMI1 - Media Identifier 1 .D....E VPSMNVP - Maximum Number of Volume Pools .DWM..E VPSPDCI - Pool Tape Drive Device Class .DWM..E VPSPPP - Physical Pool Properties .DWM..E VPSPPPB1 - Physical Props (1st Media to Borrow) .DWM..E VPSPPPB2 - Physical Props (2nd Media to Borrow) .DWM..E VPSPPPRA - Physical Props (Returns Allowed) .DWM..E VPSRPLA - Days Since Last Access (Policy Value) .DWM..E VPSRPLDI - Days Since Last Inval (Policy Value) .DWM..E VPSRPLW - Days Since Last Written (Policy Value) .DWM..E VPSRPMAD - Min Active Data Percent (Policy Value) .DWM..E VPSRPN - Reclamation Pool .DWM..E VPSVPRTP - Volume Pool Reclaim Threshold Percentage Accumulated Data Elements .DWM..E VPSAAOFP - Sum Avg Age Full Stacked Vols .DWM..E VPSAAORD - Sum Avg Age Residual Stacked Vols .DWM..E VPSADIVP - Active Data in Volume Pool (GB) .DWM..E VPSALVIP - Active Logical Volumes in Pool .DWM..E VPSBPSC0 - Scratch Stacked Vols - Media 0 .DWM..E VPSBPSC1 - Scratch Stacked Vols - Media 1 .DWM..E VPSBPSC2 - Scratch Stacked Vols - Media 2 .DWM..E VPSBPSC3 - Scratch Stacked Vols - Media 3 .DWM..E VPSDWTP - Data Written to the Pool (MB) .DWM..E VPSPBPS0 - Borrowed Private Stacked Vols Media 0 .DWM..E VPSPBPS1 - Borrowed Private Stacked Vols Media 1 .DWM..E VPSPBSS0 - Borrowed Scratch Stacked Vols Media 0 .DWM..E VPSPBSS1 - Borrowed Scratch Stacked Vols Media 1 .DWM..E VPSPSPS0 - Static Private Stacked Vols Media 0 .DWM..E VPSPSPS1 - Static Private Stacked Vols Media 1 .DWM..E VPSPSSS0 - Static Scratch Stacked Vols Media 0 .DWM..E VPSPSSS1 - Static Scratch Stacked Vols Media 1 .DWM..E VPSSDVTO - Sum Total Volumes With Active Data .DWM..E VPSSDV00 - Sum Vols With 0% to 5% Active Data .DWM..E VPSSDV05 - Sum Vols With > 5% to 10% Active Data .DWM..E VPSSDV10 - Sum Vols With > 10% to 15% Active Data .DWM..E VPSSDV15 - Sum Vols With > 15% to 20% Active Data .DWM..E VPSSDV20 - Sum Vols With > 20% to 25% Active Data .DWM..E VPSSDV25 - Sum Vols With > 25% to 30% Active Data .DWM..E VPSSDV30 - Sum Vols With > 30% to 35% Active Data .DWM..E VPSSDV35 - Sum Vols With > 35% to 40% Active Data .DWM..E VPSSDV40 - Sum Vols With > 40% to 45% Active Data .DWM..E VPSSDV45 - Sum Vols With > 45% to 50% Active Data .DWM..E VPSSDV50 - Sum Vols With > 50% to 55% Active Data .DWM..E VPSSDV55 - Sum Vols With > 55% to 60% Active Data .DWM..E VPSSDV60 - Sum Vols With > 60% to 65% Active Data .DWM..E VPSSDV65 - Sum Vols With > 65% to 70% Active Data .DWM..E VPSSDV70 - Sum Vols With > 70% to 75% Active Data .DWM..E VPSSDV75 - Sum Vols With > 75% to 80% Active Data .DWM..E VPSSDV80 - Sum Vols With > 80% to 85% Active Data .DWM..E VPSSDV85 - Sum Vols With > 85% to 90% Active Data .DWM..E VPSSDV90 - Sum Vols With > 90% to 95% Active Data .DWM..E VPSSDV95 - Sum Vols With > 95% to 100% Active Data .DWM..E VPSTOBPS - Scratch Stacked Vols .DWM..E VPSTOPBP - Total Borrowed Private Stacked Vols .DWM..E VPSTOPBS - Total Borrowed Scratch Stacked Vols .DWM..E VPSTOPSP - Total Static Private Stacked Vols .DWM..E VPSTOPSS - Total Static Scratch Stacked Vols Maximum Data Elements .DWM..E VPSMXOFP - Max Age of Full Stacked Vols .DWM..E VPSMXORD - Max Age of Residual Stacked Vols Derived Data Elements .DWM..E VPSAVATO - Avg Total Volumes with Active Data .DWM..E VPSAVA00 - Avg Vols With 0% to 5% Active Data .DWM..E VPSAVA05 - Avg Vols With > 5% to 10% Active Data .DWM..E VPSAVA10 - Avg Vols With > 10% to 15% Active Data .DWM..E VPSAVA15 - Avg Vols With > 15% to 20% Active Data .DWM..E VPSAVA20 - Avg Vols With > 20% to 25% Active Data .DWM..E VPSAVA25 - Avg Vols With > 25% to 30% Active Data .DWM..E VPSAVA30 - Avg Vols With > 30% to 35% Active Data .DWM..E VPSAVA35 - Avg Vols With > 35% to 40% Active Data .DWM..E VPSAVA40 - Avg Vols With > 40% to 45% Active Data .DWM..E VPSAVA45 - Avg Vols With > 45% to 50% Active Data .DWM..E VPSAVA50 - Avg Vols With > 50% to 55% Active Data .DWM..E VPSAVA55 - Avg Vols With > 55% to 60% Active Data .DWM..E VPSAVA60 - Avg Vols With > 60% to 65% Active Data .DWM..E VPSAVA65 - Avg Vols With > 65% to 70% Active Data .DWM..E VPSAVA70 - Avg Vols With > 70% to 75% Active Data .DWM..E VPSAVA75 - Avg Vols With > 75% to 80% Active Data .DWM..E VPSAVA80 - Avg Vols With > 80% to 85% Active Data .DWM..E VPSAVA85 - Avg Vols With > 85% to 90% Active Data .DWM..E VPSAVA90 - Avg Vols With > 90% to 95% Active Data .DWM..E VPSAVA95 - Avg Vols With > 95% to 100% Active Data .DWM..E VPSAVOFP - Avg Age of Full Stacked Vols .DWM..E VPSAVORD - Avg Age of Residual Stacked Vols .DWM..E VPSPCD00 - Pct Vols With 0% to 5% Active Data .DWM..E VPSPCD05 - Pct Vols With > 5% to 10% Active Data .DWM..E VPSPCD10 - Pct Vols With > 10% to 15% Active Data .DWM..E VPSPCD15 - Pct Vols With > 15% to 20% Active Data .DWM..E VPSPCD20 - Pct Vols With > 20% to 25% Active Data .DWM..E VPSPCD25 - Pct Vols With > 25% to 30% Active Data .DWM..E VPSPCD30 - Pct Vols With > 30% to 35% Active Data .DWM..E VPSPCD35 - Pct Vols With > 35% to 40% Active Data .DWM..E VPSPCD40 - Pct Vols With > 40% to 45% Active Data .DWM..E VPSPCD45 - Pct Vols With > 45% to 50% Active Data .DWM..E VPSPCD50 - Pct Vols With > 50% to 55% Active Data .DWM..E VPSPCD55 - Pct Vols With > 55% to 60% Active Data .DWM..E VPSPCD60 - Pct Vols With > 60% to 65% Active Data .DWM..E VPSPCD65 - Pct Vols With > 65% to 70% Active Data .DWM..E VPSPCD70 - Pct Vols With > 70% to 75% Active Data .DWM..E VPSPCD75 - Pct Vols With > 75% to 80% Active Data .DWM..E VPSPCD80 - Pct Vols With > 80% to 85% Active Data .DWM..E VPSPCD85 - Pct Vols With > 85% to 90% Active Data .DWM..E VPSPCD90 - Pct Vols With > 90% to 95% Active Data .DWM..E VPSPCD95 - Pct Vols With > 95% to 100% Active Data
For a detailed description of individual data dictionary elements, see VTS Volume Pool Statistics File (IVTVPS).
Usage Considerations
This section identifies any special considerations or techniques related to using the IVTVPS file.
The overall physical cartridge usage and availability statistics for distributed VTSs (standalone, UI, and secondary) are contained in the VTS Distributed Library Activity (IVTVDL) file.
The IVTVPS file contains a further breakdown of physical cartridge usage and availability by by Volume Pool Identifier (IVTVPN). This file is only created for VTSs that are operating at the IBM function code F/C 4001 level and have activated IBM Outboard Policy Management.
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 plot showing the quantity of physical cartridges at each of 20 bracketed percent utilization levels for each volume pool with active cartridges.Use the data from the last hour of the most recent DAYS timespan data. Only include volume pools with active cartridges.Use an array and a DO loop with 20 iterations to access the 20 VPSSDVnn data elements. An equation is used to convert the DO loop variable (I) to grab every 5th element in array, which corresponds to the VPSSDVnn data element names.DATA; SET &pIVTd..IVTVPS01; DATE=DATEPART(ENDTS) ; FORMAT DATE DATE8. ; LABEL VOLCOUNT="Cartridge Count" ; LABEL AVAL="Percent Cartridge Utilization" ; ARRAY BUCKETS {96} VPSSDV00-VPSSDV95 ; IF HOUR=23 ; IF VPSSDVTO GT 0 ; DO I=1 TO 20 ; VOLCOUNT=BUCKETS(((I-1)*5)+1); /*1st, 5th, 10th, etc.*/ AVAL=PUT((I*5-5),2.) ; /*00, 05, 10, 20, etc.*/ OUTPUT ; END ; * ; PROC SORT ; BY IVTVLS IVTTYPE IVTVPN ; * ; PROC CHART ; BY IVTVLS IVTTYPE IVTVPN ; VBAR AVAL / SUMVAR=VOLCOUNT DISCRETE; TITLE1 'Physical Cartridge PCT Utilization Distribution'; RUN;