ASA Database Administration Guide
Connecting to a Database
Connection parameters
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 example, if you are using the Java features of Adaptive Server Anywhere, you should provide additional cache memory on the StartLine (START) connection parameter. The following sample set of embedded database connection parameters describes a connection that may use Java features:
DBF=path\asademo.db dbn=Sample ENG=Sample Server uid=DBA pwd=SQL Start=dbeng9 -c 8M