Many backup and
recovery task require that you connect to a database using various command line tools. These
tools use a connection string that defines connection variable values required for a given
database.
Use the guidelines in the table to construct your connection string,
and follow the recommendations in this topic. Before entering a connection string, use
dbisql to verify that you can connect to the database
with it. You can find dbisql in the SMP_HOME\Servers\SQLAnywhere12\BINXX
folder.
- Use this syntax to construct a connection string:
dbn=DBNAME;uid=DBUSER;pwd=DBPWD;links=tcpip(DoBroadcast=NO;VerifyServerName=NO;host=DBHOST;port=DBPORT)
| Variable |
Value |
|---|
| DBNAME |
- For the cache database – use default.
- For the cluster database – use clusterdb.
- For the monitoring database – use monitordb.
- For the domain database – use domainlogdb.
|
| DBUSER |
The name of database administrator user (by default,
dba) . |
| DBPWD |
The password of the database administrator user (by default,
sql). |
| DBHOST |
The host name or IP address of the data tier computer. |
| DBPORT |
The port number of the database. The following list identifies
default database ports. Ports may have changed; use the appropriate
port values for your production environment.- For a single-node complete data tier installation – 5200.
- For the cache database (cluster) – 5200.
- For the cluster database (cluster) – 5300.
- For the monitoring database (cluster) – 5400.
- For the domain database (cluster) – 5400.
|
- Test the
connection:
dbisql -c connection-string
For example, you can access the cache on the data tier installed in a cluster
environment with:
dbisql -c
"dbn=default;uid=dba;pwd=sql;links=tcpip(DoBroadcast=NO;VerifyServerName=NO;host=localhost;port=5200)"
If you see a text entry window for entering SQL commands, then the connection string
is valid; you can exit the program and use the connection string in all required command
line utilities. A window that prompts for more connection parameters indicates that the
connection string is invalid. Review the syntax and try again.