Multiple Client Applications

Sometimes, two or more client/server applications may use the same database server. You will need to configure the server differently depending on whether the applications are used at the same time.

If your vendors supply configuration guidelines for Server configuration parameters, you will need to adjust your configuration based on these guidelines.


If the applications run concurrently (that is, if two or more applications are using the database server at the same time) ...
You should configure the server by adding together all the recommended values for each parameter. For example, if one application vendor suggests Performance Tuning \| Number of Input/Output Threads should be set to 4, and another application vendor suggests this parameter should be set to 8, then you should set it to 12. If the default value is higher than the sum of the recommended settings, then do not change the default value.
Do not add up the recommended values for any buffer size settings, or log file size settings. Use the largest recommended setting. Again, do not change the default if it is larger than any vendor recommendation.


If the applications do not run concurrently (that is, if only one application is running at any given point in time) ...
You should configure the server by using the largest recommended value for each parameter. For example, if one application vendor suggests Performance Tuning \| Number of Input/Output Threads should be set to 4, and another application vendor suggests this parameter should be set to 8, then you should set it to 8. If the default value is higher than the largest recommended setting, then do not change the default value.

Settings Affected by Multiple Applications

Most server settings are not affected when you are running multiple applications. This section explains the settings that may need to be adjusted for multiple applications.

Compatibility | Create File Version

Some applications may require that new files be created with version 7.x file format, while other applications may require version 8.x file format (the default).

These applications can run concurrently only if new files are not created during run time. There is no way to toggle the setting back and forth for each application, unless you wish to do it by hand or write a program to do so using the Distributed Tuning Objects.

If the applications do not create new files during runtime, then this setting is not relevant for multiple applications.

Data Integrity | Transaction Durability

Some applications may require durable transactions, while others may not. If you have two application vendors recommending different values for this parameter, then you should set it to On. Generally, having transaction durability turned on does not affect applications that do not use transactions, but will incur a performance penalty.