HP 3000 Manuals

Estimating the Number of Transactions [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation


ALLBASE/SQL Database Administration Guide

Estimating the Number of Transactions 

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.
[REV BEG]

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.[REV END]



MPE/iX 5.5 Documentation