IBM 000-8697 User Manual
3-92
IBM Informix OnLine Database Server Administrator’s Guide
Change the Number of Buffers in the Pool
If you are logged in as user informix, you can drop a blobspace 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 blobspace while OnLine is in online mode.
From DB-Monitor
1.
From within
DB-M
onitor, Select the Dbspaces menu, Drop option to
drop a blobspace.
2.
Use the
RETURN
key or Arrow keys to scroll to the blobspace you
want to drop and press
CTRL-B
or
F3
. You are asked to confirm that
you want to drop the blobspace.
From the Command Line
From the command line, execute the tbspaces utility with the following
option and parameter:
option and parameter:
The following example drops a blobspace blobsp3 and its mirrors:
tbspaces -d blobsp3
Change the Number of Buffers in the Pool
The number of regular page buffers in the shared-memory pool is specified
as
as
BUFFERS
in the configuration file.
You can make this change while OnLine is in online mode, but it will not take
effect until you reinitialize shared memory (take OnLine offline and then to
quiescent or online mode).
effect until you reinitialize shared memory (take OnLine offline and then to
quiescent or online mode).
The maximum number of buffers is 32,000. The minimum number is four
buffers per user process (
buffers per user process (
USERS
).
If you are logged in as user informix, you can make this change from within
DB-M
onitor or from the command line. If you are logged in as root, you must
use the command-line option.
-d blobspace
specifies the blobspace to be dropped.