Managing tablespaces

In a partitioned database environment, you can work with the tablespaces for an entire database or with individual tablespaces on a specific node. See Managing database partitions at the node for more information. Additionally, some tasks are completed from the tablespace object icon menu. Use the following procedures to manage DB2 tablespaces for an entire database, for a node partition, or for a selected tablespace object.

To enable tablespace discovery for the current database

1. Right-click on the database icon and select Database Administration > Tablespace Mgmt > Tablespace Discovery.
2. Select one of the following options:
   • Discover only DMS tablespaces
   • Discover all tablespaces
   • Do not discover any tablespaces
   • Discover tablespaces on nodes selected in Configure KM Defaults
      If you select Do not discover any tablespaces, any selection that you had previously made for the Discover tablespaces on nodes selected in Configure KM Defaults are removed from the KM discovery list.
      The discovery action that you select occurs when the next discovery cycle runs. To force start a discovery cycle, right-click on the computer host icon and select Utilities > Patrol > Force Discovery.

To create a tablespace for a database across all partitions

1. Right-click on the database icon and select Database Administration > Tablespace Mgmt > Create Tablespace.
2. In the window that appears, enter a name for the tablespace and for the tablespace file name, select the table and tablespace type, and provide any other necessary information.

To run the List Tablespaces and List Tablespace Containers command

1. Right-click on the database partition icon and select Database Administration > Tablespace Mgmt.
2. select the appropriate command:
   • List Tablespaces

   • List Tablespace Containers

     Note

     You can also list tablespace containers from the menu of a tablespace icon. By doing so, you circumvent selecting a tablespace from a list and go directly to the Tablespace Container Information window.

To quiesce a tablespace

This task executes only on tablespaces on a single node.

1. Right-click on a selected database partition icon and select Database Administration > Tablespace Mgmt> Quiesce Tablespaces.
2. In the window that appears, enter the table name, and select one of the following quiesce modes:
   • SHARE protects the table from updates; the KM allows other share requests for the table or tablespace.
   • INTENT TO UPDATE prevents any access to the table or tablespace.
   • EXCLUSIVE prevents any other access to the table or tablespace.
   • RESET resets the state of the tablespace to normal.

To add a tablespace container and configure tablespace recovery

Right-click on the tablespace object icon in the database object window and select any of the following commands:

• Add Tablespace Container
• Config PctPagesUsed Recovery
• List Tablespace Containers

For more information about configuring recovery actions when space limitations for a tablespace are exceeded, see Configuring PctPagesUsed to recover automatically from an alarm.