Operating OnLine 3-99

Drop a Dbspace

All options and parameters except -o and -m are required. The following
example creates a mirrored dbspacedbspce5. 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
dbspaceto 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.
Ifyou want to drop only the dbspace mirrors, turn off mirroring. This drops
the dbspace mirrors and frees the chunks for other uses.
Ifyou are logged in as user informix, you can drop the dbspace from within
DB-Monitoror 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 withinDB-Monitor, select the Dbspaces menu, Drop option to
drop a dbspace.
2. Usethe RETURN key or arrow keys to scroll to the dbspace you want
to drop and pressCTRL-B or F3. You are asked to confirm that you
want to drop the dbspace.