3-92 IBM Informix OnLine Database Server Administrator’s Guide

Change the Number of Buffers in the Pool

Ifyou are logged in as user informix, you can drop a blobspace 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 blobspace while OnLine is in online mode.
From DB-Monitor
1. Fromwithin DB-Monitor, 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 pressCTRL-B or F3. You are asked to confirm that
you want to drop the blobspace.
From the Command Line
From the command line, execute thetbspaces utility with the following
option and parameter:
The following example drops a blobspaceblobsp3 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
asBUFFERS in the configuration file.
Youcan 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).
The maximum number of buffers is 32,000. The minimum number is four
buffers per user process (USERS).
Ifyou are logged in as user informix, you can make this change from within
DB-Monitoror 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.