Calculate Space Requirements for Tablespaces

The Space Calculator facility can calculate the primary and secondary space quantities needed for your tablespaces and eliminates time-consuming calculations. This is especially important for users who want to calculate the space needed for segmented tablespaces and for multiple tables within one tablespace.
carcudb2
The Space Calculator facility can calculate the primary and secondary space quantities needed for your tablespaces and eliminates time-consuming calculations. This is especially important for users who want to calculate the space needed for segmented tablespaces and for multiple tables within one tablespace.
Multiple table calculations require an average row size to calculate accurately the total space needed for non-segmented tablespaces. The average row size approximates multiple tables' row length to compensate for the rows being interleaved on one page.
You can create a new stand-alone tablespace space strategy that saves space requirements for a tablespace or edit an existing space strategy as needed. If the tablespace is partitioned, space calculations can be made on each partition.
Follow these steps:
  1. Do
    one
    of the following:
    • Type
      SS
      (Space Calculator) in the Option field on the CA Database Management Solutions for DB2 for z/OS main menu and press Enter.
    • Type
      SSC
      on the command line from any product and press Enter.
    The SpaceCalc Strategy Select panel appears.
  2. Do
    one
    of the following:
    • Type
      CT
      , the name of the strategy, and the name of the tablespace on the create line (first) to create a new stand-alone tablespace strategy.
    • Press Enter to see a list of existing strategies and then type
      E
      next to a strategy you want to edit.
    Press Enter.
    The Tablespace Strategy panel appears.
    This panel has the same fields as the Tablespace Alter, Tablespace Create, and Tablespace Template panels that can be accessed from CA RC/Migrator and CA RC/Update. 
  3. Type
    S
    next to a tablespace and specify a VCAT or storage group name in the VCAT or Stogroup fields, and press Enter.
    The Space Calculation panel appears. The name of the tablespace and the number of the partition appear on the first line. The control parameters default to the values last used on the Tablespace Create and Table Alter panels.
  4. Edit the control parameters and the table information fields as needed and press Enter. All fields must contain a value before the Space Calculator can calculate the results.The space requirements for the tablespace or partition are calculated and the Space Calculator fills in the columns for each table included in the tablespace.
  5. (Optional) Type
    E
    (explode) next to a table or multiple tables to view detailed information about the selected tables and press Enter.
    Detailed statistics for the selected table or tables appear on the Space Calculation panel. Multiple commands are processed in the order they appear on the Space Calculation panel.
    The statistics shown are applicable only for the selected table. 
  6. Type
    T
    (totals) on the command line and press Enter.
    The calculated results for the tablespace appear in the Space Statistics section on the Space Calculation panel.
    Totals for segmented tablespaces are calculated based on the minimum or maximum number of segments needed for the given number of rows, cylinders, or tracks as specified in the Qty Type field on the Space Calculation panel. The totals for non-segmented tablespaces are calculated based on the average row size. 
  7. Press F3 (End) when you have completed your calculations.
    The calculations are used for the selected tablespace or partition.
    If you accessed the Space Calculator from CA RC/Migrator or CA RC/Update, you are returned to the tablespace panel you were at in the product. The calculations are updated on the panel and the information is used for the selected tablespace or partition.
    You cannot change the values of an actual catalog object or the associated actualized space strategy. If you make and save changes to the statistics, an object-linked space strategy is created. 
  8. Type
    S
    and an eight-character strategy name in the SSTRAT field to save the strategy and press Enter.
    You can enter the name of a new strategy or reference an existing (previously saved) strategy. When a new space strategy is created, the strategy name or object link name is put into this field.The SpaceCalc Strategy Save panel appears.
  9. Press Enter to save the strategy with the specified attributes.
    The strategy is saved, the action code of the SSTRAT field is reset to N, and you are returned to the Space Calculation panel.