Advantage Server Configuration Utility

 

How To Calculate Database Settings

Number of Connections

This is the total number of CAPITAL applications that will connect to the server at any one time. There are four primary CAPITAL applications:

    CAPWIN.EXE

    INSTWIN.EXE

    GLWIN.EXE

    VB.EXE

A user may potentially operate one or more of these applications in a typical work session. Allowance should therefore be made for a minimum of 4 connections per user.

A second factor to consider is that one or more users may wish to run the CAPITAL software as more than one session. For example, the CAPWIN.EXE may be opened twice, once with an invoice open, and a second copy running a report.

It is therefore suggested that the calculation for the Number of Connections setting should be at least:

Number of users x 4 x 2

If users are likely to exceed this value, it should be increased. For example, if many users open the CAPWIN.EXE program 3 or 4 times, the calculation should be increased. For example:

Number of users x 4 x 3

generate/mistake.gifIf one or more Advantage applications attempt to connect to the Advantage Database Server than there are number of connections configured, the Advantage application that is attempting to connect will receive a 7033 error, Connection Table Full, until a connection becomes available. For example, if the Advantage Database Server is configured for a maximum of 100 connections, all 100 connections are currently being taken up by Advantage applications that are connected one or more times to the Advantage Database Server, and a new or existing Advantage application attempts to connect to the Advantage Database Server, that connect request will fail with a 7033 error.

Number of Work Areas

This is the number of work areas required by each session. It is recommended that this be set to 100 per connection. So the calculation would be:

Number of users x 100

generate/mistake.gifIf an Advantage application attempts to open a table on the Advantage Database Server, and the configured number of work areas have already been used, the Advantage application which is attempting to open that table will receive a 7004 error, Maximum number of work areas exceeded, until a work area "element" becomes available. For example, if the Advantage Database Server is configured for a maximum of 500 work areas, 500 tables instances (whether the same table or multiple tables) are already currently open by existing Advantage applications via the Advantage Database Server, and a new or existing Advantage application attempts to open a table (whether it is a table already open or not), that table open request will fail with a 7004 error.

Number of Tables

For CAPITAL 7.3 this should be set to 150.

generate/mistake.gifIf an Advantage application attempts to open a table on the Advantage Database Server that has not yet been opened by any Advantage application, and the configured number of tables has already been opened, the Advantage application that is attempting to open that table will receive a 7005 error, Maximum number of tables exceeded, until a table "element" becomes available. For example, if the Advantage Database Server is configured for a maximum of 50 concurrently open tables, 50 distinct tables are already currently open with the Advantage Database Server, and a new or existing Advantage application attempts to open a table that has not yet been opened by the Advantage Database Server, that table open request will fail with a 7005 error.

Number of Index Files

For CAPITAL 7.3 this should be set to 150.

generate/mistake.gifIf an Advantage application attempts to open an index file on the Advantage Database Server that has not yet been opened by any Advantage application, and the configured number of index files have already been opened, the Advantage application that is attempting to open that index file will receive a 7006 error, Maximum number of index files exceeded, until an index file "element" becomes available. For example, if the Advantage Database Server is configured for a maximum of 50 concurrently open index files, 50 distinct index files are already currently open with the Advantage Database Server, and a new or existing Advantage application attempts to open an index file that has not yet been opened by the Advantage Database Server, that index file open request will fail with a 7006 error.

Number of Data Locks

For CAPITAL 7.3 this should be set to 40 x the number of connections. For example, if 20 connections have been specified the calculation would be:

20 x 40 = 160

generate/mistake1.gifIf an Advantage application attempts to obtain a record, table, or index lock, and the configured number of data locks have already been used, the Advantage application which is attempting to get the lock will receive a 7007 error, Maximum number of locks exceeded, until a lock "element" becomes available. For example, if the Advantage Database Server is configured for a maximum of 5000 concurrent data locks, 5000 data locks are already in use by the Advantage Database Server, and a new or existing Advantage application attempts to lock a record, table, or index, that lock request will fail with a 7007 error. Data locks take very little memory. Setting this value to a very high number should not require much server RAM to be used.

 

04/05/2005


C:\FORHELP5\htmlgifs\home.gif