Connection parameters often provide more than one way of accomplishing a given task. This is particularly the case with embedded databases, where the connection string starts a database server. For example, if your connection starts a database, you can specify the database name using the DatabaseName (DBN) connection parameter or using the DatabaseSwitch (DBS) parameter.
Here are some recommendations and notes for situations where connection parameters conflict:
Specify database files using DBF You can specify a database file on the StartLine (START) parameter or using the DatabaseFile (DBF) connection parameter (recommended).
Specify database names using DBN You can specify a database name on the StartLine (START) parameter, the DatabaseSwitch (DBS) connection parameter, or using the DatabaseName (DBN) connection parameter (recommended).
Use the Start parameter to specify cache size Even though you use the DatabaseFile (DBF) connection parameter to specify a database file, you may still want to tune the way in which it starts. You can use the StartLine (START) connection parameter to do this. For recommended parameters, see “Required command-line options”.
For example, you may need to provide additional Catalog cache memory on the StartLine (START) connection parameter, as in the following sample set of embedded database connection parameters, where the default Catalog cache size for Windows, 32M, is increased to 48M:
DBF=path\asiqdemo.db DBN=Sybase IQ Demo ENG=Sample Server UID=DBA PWD=SQL Start=start_asiq -c 48M -gd all -gp 4096
