Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Space requirement estimates based on user-specified values

Standard space-estimation tools use IBM default DDL values for object attributes when calculating estimates.

In contrast, the Simple Space Estimation (SSE) feature allows you to replace those defaults with values that are specific to your objects. DASD MANAGER PLUS, Catalog Manager, and Change Manager support this feature.

Note

You do not need to run BMCSTATS before using SSE.

For example, for a non-partitioned table space estimate, you can change the bolded fields on the panel displayed in Catalog Manager. SSE then estimates how much space will be required if you reorganize the table space. SSE displays estimates for the entire table space in the Estimated box on the right, and table-level estimates at the bottom of the panel.

For a description of each field that accepts user-specified values, see the online Help.

Tablespace Estimation panel

              ACNZTBS2                       Tablespace Estimation           Row 1 to 1 of 1
COMMAND ===>                                                   SCROLL===> PAGE
                                                                             
Type data and press Enter.                                                     
                                                    |------- Estimated -------|
  Pagesize . . . . .   16 (4,8,16,32)               | Pages  . . . .        6 |
  Segsize  . . . . .    4 (0-64)                    | Space (Trks) .        2 |
  Maxrows  . . . . .  255 (0-255)                   | Space (KB) . .       96 |
  Dssize . . . . . .    1                           | Extents  . .          1 |
  Pctfree  . . . . .    0 (0-99)                    | Data Sets  . . .      0 |
  Freepage . . . . .    0 (0-255)                   |-------------------------|
  Compress . . . . .    N (Y or blank)                                         
  Priqty . . . .     2000               Alloc Unit . . . .    T (T or C)       
  Secqty . . . .      100               Device Type. . .   3390                
                                                                              
Tables: Enter I to Insert, R to Repeat, or D to Delete a line.                 
                                                                              
          Avg Row                                        ----- Estimated -----
Cmd       Length        #Rows                            Rows/Page  Pages      
-------------------------------------------------------------------------------
                   0               1                            0

This section contains the following topics:

Related topic

Creating-objects

 

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