IBM 000-8697 User Manual

Operating OnLine

All options and parameters except -o and -m are required. The following
example creates a mirrored dbspace dbspce5. An offset of 5,000 KB is
specified.

tbspaces -c -d dbspce5 -p /dev/rsd1f -o 5000
 -m /dev/rsd2a 5000

The dbspace you intend to drop must be unused. (It is not sufficient for the
dbspace to be empty of data.) Execute tbcheck -pe to verify that no tables or
logs are residing in the dbspace.

You cannot drop the root dbspace.

After you drop a dbspace, the newly freed chunks are available for
reassignment to other dbspaces or blobspaces.

If you drop a dbspace that is mirrored, you also drop the dbspace mirrors.

If you want to drop only the dbspace mirrors, turn off mirroring. This drops
the dbspace mirrors and frees the chunks for other uses.

If you are logged in as user informix, you can drop the dbspace from within

DB-M

onitor or from the command line. If you are logged in as root, you must

use the command-line option.

You can drop a dbspace while OnLine is in online mode.

From within

DB-M

onitor, select the Dbspaces menu, Drop option to

drop a dbspace.

Use the

RETURN

key or arrow keys to scroll to the dbspace you want

to drop and press

CTRL-B

 or

F3

. You are asked to confirm that you

want to drop the dbspace.