Tablespaces


The Tablespaces option screen displays when you select option 2 from the Object Selection menu. It lets you specify whether you want to create, alter, drop, or model a tablespace.

Tablespaces Option Screen

image2021-3-10_15-41-34.png

OPTION

Specify the letter representing the activity you want to perform:

C

Create a table space.

A

Alter a table space.

D

Drop a table space.

M

Model a table space and create a new tablespace.

Specify Tablespace Information: (* or pattern for list) Area

Database Name

Specify the name of the database in which the tablespace resides. You can also specify a generic name with * (asterisk), or a pattern. This displays a Tablespace Selection window, from which you can select a specific object.

Tablespace Name

Specify the name of the tablespace you want to create, alter, drop, or model. You can also specify a generic name with * (asterisk), or a pattern. This displays a Tablespace Selection window, from which you can select a specific object.

Important

When you press Enter from the Tablespaces screen, or from the Tablespace Selection window, File-AID for Db2 Object Administration displays. Refer to File-AID for Db2 Object Administration User Reference for information.

 

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