Altering a table space

Use this notebook to modify a table space at the current server. The current table space name appears in the Table space name field on the Table Space page. Many of the options are presented here for information only.

Authorities and privileges

To alter a table space:

  1. Open the Alter Table Space window.

  2. Specify the optional properties for this table space.

  3. Specify the appropriate information to manage this table space . This information describes the data set and space management.

  4. If you selected to alter a partitioned table space, select the Partition Management tab to modify the optional properties of each partition.

Related information

Specifying properties

Use this page of the notebook to modify the properties of the space.

  1. Optional: Specify a different buffer pool name. The name must identify an active buffer pool.

  2. Change the lock size to be used within this table space.

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

  4. Optional: Type 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. For table spaces defined as large object table spaces (LOB), the value of MAXROWS must be zero.

  5. Select whether to change a maximum size for each partition or dataset (DSSIZE). This is only applicable for LOB table spaces.

  6. Select whether to use the default CLOSE rule.

  7. This is applicable only for partitioned table spaces. Select to use selective partition locking (SPL) when locking a partitioned table space (LOCKPART YES). Cannot be altered.

  8. This is applicable only for LOB table spaces. Select the check box to record Write changes to a LOB column in a LOB table space to the log. You cannot use this if the auxiliary table in the table space stored a LOB column that is greater than 1 gigabyte. For LOB table spaces, recording column changes to the log is the default. Cannot be altered.

  9. Select the check box to allow DB2 to choose where to locate data inserted by the INSERT statement in the table space based on available space. This is invalid for LOB table spaces.

  10. In the CCSID field, specify which of the compatible default coded character set identifiers (CCSIDs) you want to use. The available CCSIDs define either a Euro symbol or a codepoint such as the International Currency Symbol (ICS). All databases and all table spaces within an encoding scheme (EBCDIC or ASCII) should be altered at the same time. Once you have changed the value, you cannot alter this field again. See the DB2 UDB for OS/390 Version 6 Installation Guide for a table of compatible CCSIDs for both encoding schemes.

[ 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.

  9. Select to decide whether DB2 tracks modified pages in the space map pages of the table space or partition. If you choose to let DB2 track changes, you could see some improvement in the performance of incremental image copies. If you clear the check box, DB2 uses the LRSN value in each page to determine whether a page has been changed. This should not be used for a LOB table space.

[ 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 defined in the table space. The number of partitions displayed corresponds to the number of partitions defined when you created the table space.
  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.

[ Return to main task ]