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
<UnwiredPlatform_Installdir>\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.