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
ZDT/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 |