Create Table Space: Allocation panel

You use the Create Table Space: Allocation panel to specify information to define the data set and space allocation for the table space to be created.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)           Create Table Space: Allocation

 Dataset Parameters:
 VCAT name . . . . . . .              (for user defined data sets only)
 Storage group name  . .            + (only if VCAT name omitted)

 Space Requirements (Only if Storage Group Name specified):
    Primary space  . . .            KB
    Secondary space  . .            KB

 Free Space and Rows per Data Page:
    Free pages . . . . .            (0,255 inclusive, default value is 0)
    Free space . . . . .            (0-99 inclusive, default value is 5)
    Maximum rows per page           (1-255 inclusive, default value is 255)



 Command ===>                                                                 
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
VCAT name
Specifies the first data set for the table space is managed by the user.
Storage group name
Specifies Db2® defines and manages the data sets for the table space.
Primary space
Specifies the minimum primary space allocation for a Db2® managed data set.
Secondary space
Specifies the minimum secondary space allocation for a Db2® managed data set.
Free pages
Specifies how often to leave a page of free space when the table space or partition is loaded or reorganized.
Free space
The total amount of unused space in a page.
Maximum rows per page
Specifies the maximum number of rows that Db2® considers placing on each data page.

Parent panels

Child panels

None.

Related tasks