Create Table Space panel

You use the Create Table Space panel to create a new table space.

Panel and field definitions

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

 Table Space Definition:
    Name . . . . . . . . . . . .          (required)
    Database . . . . . . . . . .          (optional)
    Buffer pool  . . . . . . . .          (optional: BPn,BP8Kn,BP16Kn,BP32Kn)

 Table Space Creation:
    Creation Options
    1  1. Table space type                (optional, usually needed)
       2. Table space allocation          (optional, usually needed)
       3. Data storage options            (optional)
       4. Locking options                 (optional)
       5. Data sharing options            (optional)
       6. Partitions                      (partitioned table spaces only)
       7. Create the table space



 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel
Name
The name of the table space you want to create.
Database
The name of the database in which the table space is to be created.
Buffer pool
The name of the buffer pool to be used for the table space.
Creation Options
Specify the number of the creation option you want to use:
1. Table space type
To specify information to define the type of table space to be created. Displays the Create Table Space: Type panel.
2. Table space allocation
To specify information to define the data set and space allocation for the table space to be created. Displays the Create Table Space: Allocation panel.
3. Data storage options
To specify information to define data storage options for the table space to be created. Displays the Create Table Space: Data Storage Options panel.
4. Locking options
To specify information to define the locking options for the table space to be created. Displays the Create Table Space: Locking Options panel.
5. Data sharing options
To specify information to define the data sharing options for the table space to be created. Displays the Create Table Space: Data Sharing Options panel.
6. Partitions
To specify information to define the partitions for a partitioned table space to be created. Displays the Create Table Space: Define Partitions panel.
7. Create the table space
When you have finished specifying details for the table space to be created, select this creation option to create the table space.

Parent panels

Child panels

To display this panel… Use/do this
Create Table Space: Type panel Creation option 1
Create Table Space: Allocation panel Creation option 2
Create Table Space: Data Storage Options panel Creation option 3
Create Table Space: Locking Options panel Creation option 4
Create Table Space: Data Sharing Options panel Creation option 5
Create Table Space: Define Partitions panel Creation option 6

Related tasks