IBM 000-8697 Server User Manual


 
Operating OnLine 3-91
Drop a Blobspace
From the Command Line
From the command line, execute the tbspaces utility with the following
options and parameters:
All options and parameters except -o and -m are required. The following
example creates a mirrored blobspace blobsp3 with a blobpage size of 10 KB,
where OnLine page size is 2 KB. An offset of 200 KB for the primary and
mirror chunks is specified.
tbspaces -c -b blobsp3 -g 5 -p /dev/rsd1f -o 200
-m /dev/rsd2a 200
Drop a Blobspace
The blobspace you intend to drop must be unused. (It is not sufficient for the
blobspace to be empty of blobs.) Execute tbcheck -pe to verify that no table
is currently storing data in the blobspace.
After you drop the blobspace, the newly freed chunks are available for
reassignment to other dbspaces or blobspaces.
If you drop a blobspace that is mirrored, you also drop the blobspace mirrors.
If you want to drop only the blobspace mirrors, turn off mirroring. This drops
the blobspace mirrors and frees the chunks for other uses.
-c creates a new blobspace.
-b blobspace specifies a blobspace name.
-g page_unit specifies the blobpage-size parameter (number of OnLine
pages).
-p pathname specifies the explicit pathname of a primary chunk: either a
raw device or a UNIX file.
-o offset specifies the raw device offset in kilobytes, if appropriate.
-m indicates blobspace mirroring and is followed by both
pathname and offset, if appropriate, for the blobspace mirror.