4.8.4 Setting the MAXGTT, MAXBUFTYPE, and MAXBUFSTYPE Parameters
You must increase the value of the MAXGTT
parameter
if the product of multiplying the number of clients in the system
times the percentage of time they are committing a transaction is
close to 100. This may require a great number of clients, depending
on the speed of commit. If you increase MAXGTT
, you
must also increase TLOGSIZE
accordingly for every
machine. You must set MAXGTT
to 0
for
applications that do not use distributed transactions.
You can limit the number of buffer types and subtypes allowed in
the application with the MAXBUFTYPE
and
MAXBUFSTYPE
parameters, respectively. The current
default for MAXBUFTYPE
is 16. Unless you are creating
many user-defined buffer types, you can omit
MAXBUFTYPE
. However, if you intend to use many
different VIEW
subtypes, you may want to set
MAXBUFSTYPE
to exceed its current default of
32
.
Parent topic: Enhancing Efficiency with Application Parameters