As the number of users accessing the
DBEnvironment increases, you should increase the number of
concurrent transactions allowed. The maximum
should be set slightly higher than the number of
expected users because
ALLBASE/SQL may start a second transaction on the user's behalf when
executing data definition statements such as CREATE.
Set the maximum to twice the number of users if you expect to be
doing a lot of data definition.
The minimum number of transactions is 2,
and the default value is 50.
There is no limit on the number of transactions
you can request.
You can temporarily override the number of transactions
with the START DBE statement. The ALTDBE command in SQLUtil
allows you to permanently change the
maximum number of transactions.