Stage 5: Database Connection Information
Some products require you to supply database connection information during installation. Sample URL formats for that driver are shown in the product panels. Keep in the mind the following:
Many products use the DataDirect Connect JDBC 5.1 driver. For information about options supported by this driver, see DataDirect Connect for JDBC User's Guide and Reference 5.1 in the Software AG_directory/_documentation directory or on the Software AG Documentation Web site.
If you are using the installer GUI mode, for ease of use, the database connection values you enter on one panel are reflected on the next as you go forward through the installer the first time.
Use the DataDirect Connect connection option MaxPooledStatements=35 on all database URLs except those for Trading Networks. This connection option improves performance by caching prepared statements. (Trading Networks caches its prepared statements using its own pooling mechanism).
If the database user and password do not yet exist, specify the database user and password you will create after installation. You can use one database user for multiple database components, or you can use a different database user for each database component.
For DB2, if the product will connect to a schema other than the default schema for the specified database user, you must specify these connection options in the database URL, where AlternateID is the name of the default schema that is used to qualify unqualified database objects in dynamically prepared SQL statements:
;AlternateId=schema;
"InitializationString=(SET CURRENT PATH=current_path,schema)";
MaxPooledStatements=35