Managing tablespaces and tables

A database tablespace consists of tablespace containers. Within those tablespace containers are the database tables that consume the space assigned to that tablespace. Depending on your database management needs, you can work with the tablespaces in your databases.

You can use PATROL for DB2 UDB to create a new tablespace or quiesce a tablespace. You can also disable or enable discovery of tablespaces from the database icon menu, which resets the discovery option set for tablespaces in the SETUP menu.

Table management tasks include reorganizing tables, running statistics on a table, and running the import, export, and load utilities.

Note

You cannot manage SMS tablespaces for remote databases. For more information about remote databases, see Remote database discovery in DB2 UDB EE.

To manage tablespaces

  1. Right-click on the DB2 database icon and select Database Administration > Tablespace Mgmt.
  2. select one of the following commands from the submenu:
    • Tablespace Discovery
    • Create Tablespace
    • List Tablespaces
    • List Tablespace Containers
    • Quiesce Tablespaces

To add containers and configure tablespace recovery for a tablespace

Right-click on a tablespace object icon and select one of the following commands to manage the tablespace containers:

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

To manage tables in a database

  1. Right-click the DB2 database icon and select Database Administration > Table Mgmt.
  2. select one of the following commands to manage tables:
    • List Tables
    • Reorganize Check
    • Reorganize Table
    • Run Statistics
    • Import Data
    • Export Data
    • Load Data

Note

When importing or loading data, you must know the file name, the file type and node location of the data source, and the name of the table in which the data will be put. Run the List Tables command to view table names. Refer to the online Help for more information about running these commands.

Tip

When exporting data, ensure that the file system to which you are exporting data has enough space to handle the data.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*