Filter
Top Products
Operating OnLine 3-99
Drop a Dbspace
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
Drop a Dbspace
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.
Preliminary Considerations
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-Monitor 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 DB-Monitor
1. From within DB-Monitor, select the Dbspaces menu, Drop option to
drop a dbspace.
2. 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.