Creating a table space

Use this notebook to create a table space at the current server, as part of your customized tree.

Authorities and privileges

To create a table space:

  1. Open the Create Table Space window.

  2. Type the database name for your table space, or click on the push button to see a list of available database names to choose from.

  3. Enter a valid unique name for your table space. Once you have entered this name you can select OK to create your table space and exit the window.

  4. Optional: Select the type of table space that you want to create. If you select to create a nonpartitioned or segmented table space, the Partition Management tab on this notebook is not available.

  5. Specify the optional properties for this table space.
  6. Specify the appropriate information to manage this table space . This information describes the data set and space management.
  7. If you selected to define a partitioned table space, select the Partition Management tab to define the optional properties of each partition.

Related information

Specifying properties

Use this page of the notebook to describe the properties of the space.
  1. Optional: Select the buffer pool name. The name must identify an activated buffer pool.

  2. Optional:Select a lock size to be used within this table space.

  3. Optional: Select the maximum number of page or row locks that an application process can hold simultaneously in the table space.

  4. Optional: The encoding scheme or coded character set identifier (CCSID) is used for the tables stored in the table space. Select whether you want to use ASCII or EBCDIC CCSIDs.

  5. Optional: Enter a password (DSETPASS) that will be used to access system services provided by the virtual machine (VSAM, etc.).

  6. Optional: Enter the maximum number of rows that DB2 will consider placing on each data page (MAXROWS). You can enter a value from 1 to 255, or accept the default of 255.

  7. Optional: Select whether to use the default CLOSE rule.

  8. Optional: The Use selective partition locking check box is applicable only for partitioned table spaces. Check to use selective partition locking (SPL) when locking a partitioned table space (LOCKPART YES).

[Return to main task ]

Managing your space

Use this page of the notebook to define the details of the space.
  1. Optional: Select whether the data set for the table space is managed by the user (VCAT). Then select a catalog name.

  2. Optional: If data sets are not to be managed by the user, then select Managed by DB2. You can then enter the storage group name.

  3. Optional: If you selected to have data sets managed by DB2, you should enter the minimum primary space allocation (PRIQTY). This field is not applicable if you selected data set management by USER.

  4. Optional: If you selected to have data sets managed by DB2, you should enter the minimum secondary space allocation (SECQTY). This field is not applicable if you selected data set management by USER.

  5. Optional: If you selected to have data sets managed by DB2, you should select an ERASE option. This field is not applicable if you selected data set management by USER.

  6. Optional: Select to choose to manage the free space (FREEPAGE and PCTFREE) amount.

  7. The cached pages options are for group buffer pools only. This specifies what table spaces are written to the group buffer pool in a data sharing environment.

  8. Select whether to compress data in the rows or not.

[Return to main task ]

Managing your partitions (for partitioned table spaces only)

This page of the notebook gives you a table of information about each partition you define in the table space. The table has a default set of parameters for each of the partitions when it is first opened. The number of partitions displayed corresponds to the number of partitions defined on the Table Space notebook page.

  1. Click the CHANGE button to modify the properties of a partition you have selected from the table. This opens the Change Partition Management dialog.

  2. Click the Reset button to revert the properties of the selected partitions back to the state at the time you opened this window.

  3. Click the Move Up button to reorder the partitions within the table. For every click of this button, the partition is moved up, and the corresponding partition number is changed.

  4. Click the Move Down button to reorder the partitions within the table. For every click of this button, the partition is moved down, and the corresponding partition number is changed.

[ Return to main task ]