Volume free space detail report


Use this procedure to create a report that provides additional information about volumes that are candidates for new table spaces and index spaces.

Important

This report lists only volumes named for the STOGROUP and stored in the SYSIBM.SYSVOLUMES catalog table. It will not provide volume analysis for SMS-managed storage groups defined with an asterisk (*) or SMS constructs.

Related topics

To create a volume free space detail report

  1. Access the Volume Free Space Detail panel as follows:
    1. On the DASD MANAGER PLUS main menu, select Reports and press Enter.
    2. On the Report Selection menu, select Space Allocation Reports and press Enter.
    3. On the Space Allocation Reports Selection menu, select Volume Free Space Detail (Real Time) and press Enter.

      Volume Free Space Detail panel

      DEMO ----------------------------- VOLUME FREESPACE DETAIL --------------------
      COMMAND ===>                                                                  
                                                                                    
      The fields below determine the list of objects the report will use. Type       
      the full or wild card name of the objects, then press Enter                    
                                                                                    
       Stogroup name ...............                                                 
       Volume name .................                                                 
                                                                                    
       Where                                                                         
        Cylinders needed >=......... 0                                               
                                                                                    
       Batch Report : N (Y/N)
  2. Specify one of the following options:
    • In the Stogroup name field, type the name of the storage group to display statistics for all volumes in a storage group. You can also type a wildcard pattern.
    • In the Volume name field, type its serial number to display statistics for a particular volume. You can also type a wildcard pattern.
  3. In the Cylinders needed >= field, type a minimum number of cylinders to display volumes having a specified number of free cylinders.
  4. In the Batch Report field, type Y in the field and press Enter to produce the report in batch.One of the following events happens:

    • If you specified Y in the Batch Report field, the product produces JCL in a temporary data set when you exit the report dialog, and a prompt panel gives you the option to edit and submit the JCL.
    • If you specified N in the Batch Report field, the following appears.

    Volume Free Space Detail report

                       B M C   S O F T W A R E,   I N C.
        *****  D A S D   M A N A G E R   P L U S   F O R   D B 2  *****  Vvv.rr.mm

     Time . . . . . . . . .: 12:55:41 AM  Friday, <Month> dd, yyyy
     DB2 ID . . . . . . . .: DEMO
     DB2 Version. . . . . .: vvrr
     Current Function Level: VvvRrMmmm        Catalog Level . . . . .: VvvRrMmmm
     Highest Active Level  : VvvRrMmmm        Previous Function Level: VvvRrMmmm
     SPE Level. . . . . . .:
     User . . . . . . . . .: MVSTYG


                              Volume Free Space Detail
                                                         --Largest Extent--
     Volume  Dev     Alloc         Free        Addt'l              Addt'l
     Name    Type    Space    %    Cyls    %   Tracks   %  Cyls    Tracks
     ------  ----  -------   ---  -----   ---  ------  --  ------  ------
     AZU001  3390     3336 -  99      2 -   1      4 -  0      1      0
     AZU002  3390     3338 - 100      0 -   0     15 -  1      0      6
     AZU003  3390     3338 - 100      0 -   0     68 -  1      0     13
     AZU004  3390     3338 - 100      0 -   0     77 -  1      0     12
     AZU005  3390     3338 - 100      0 -   0     46 -  1      0     10
     AZU006  3390     3336 -  99      2 -   1     42 -  1      2      0
     AZU007  3390     3338 - 100      0 -   0     41 -  1      0      9
     AZU008  3390     3336 -  99      2 -   1      5 -  0      2      0
     AZU009  3390     3336 -  99      2 -   1      4 -  0      2      0
     AZU010  3390     3285 -  98     53 -   1     10 -  0      9      0
     AZU011  3390     3338 - 100      0 -   0     11 -  0      0      6
     AZU012  3390     3338 - 100      0 -   0     36 -  1      0     12
     AZU013  3390     3338 - 100      0 -   0      2 -  0      0      2
     AZU014  3390     3338 - 100      0 -   0     14 -  0      0      9
     AZU015  3390     3338 - 100      0 -   0      5 -  0      0      5
     AZU016  3390     3338 - 100      0 -   0     39 -  1      0     14
     AZU017  3390     3336 -  99      2 -   1     20 -  1      2      0
     AZU018  3390     3338 - 100      0 -   0      7 -  0      0      4
     AZU019  3390     3338 - 100      0 -   0     38 -  1      0     14
     AZU020  3390     3313 -  99     25 -   1      5 -  0     25      0
     AZU021  3390     3338 - 100      0 -   0     26 -  1      0     14
     AZU022  3390     3336 -  99      2 -   1      5 -  0      2      0
     AZU023  3390     3273 -  98     65 -   1     92 -  1     12      0

    Because of rounding, in some cases percentage values might add up to slightly more or less than 100 percent.

    The Volume Free Space Detail report contains the fields described in the following table.

    Volume Free Space Detail report fields

    Field Name

    Description

    Volume Name

    Volume serial number of the DASD volume

    Dev Type

    Type of DASD volume, for example, 3380 or 3390

    Alloc Space

    Space that has been allocated on the volume

    %

    Percentage of allocated space that has been used

    Free Cyls

    Number of unused cylinders on the volume

    %

    Percentage of free cylinders that has not been used

    Addt’l Tracks

    Total number of free tracks

    %

    Percentage of free tracks in cylinders that has not been used

    Largest Extent

    Largest free extent, calculated on a cylinder boundary

    • Cyls is the number of cylinders in the largest free extent.
    • Addt’l Tracks is the number of free tracks before or after the last cylinder boundary in the contiguous block of space.





 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*