ASA Database Administration Guide
  Connecting to a Database
    Connection parameters

Connection parameter tips

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