SQL Anywhere for Linux - dbsrv9 and its ports

Author

dbsrv9 and its ports

Server Admin

2005-04-05, 8:03 pm

Hello Everyone -

I am searching for clarification on the ports used by dbsrv9. I am aware of
the default port 2638 when you start one dbsrv9 instance.

Here is my situation.

We run a RedHat Linux environment with SQL Anywhere Studio 9.0. We have a
CPU license agreement for that machine. We are currently running a
webapplication - App1 - on that server. We recently finished a second web
application - App2 - that we now want to deploy on the same server.

I used the command line "dbsrv9 -n DevSrv /path/DB1.db /path DB2.db -qw -ud"
to start the database server and allow access to the databases.

When starting with the above command line it loads the dbsrv9 daemon just
fine with the default 2638 port.

My question: Do both (DB1 and DB2) listen on the 2638 port? Our
applications require a jdbc connection with user/passwd and port
information. When I use port 2638 I am only able to connect to DB1. In
other words, does dbsrv9 use one port for multiple databases loaded?

Is it a good idea to run a second instance of dbsrv9 on a different port,
like 2639? Using the command line "dbsrv9 -x tcpip(ServerPort=263
9)? I have
a hard time to believe this would be the case.

What is the best way to start the dbsrv9 daemon with multiple databases? We
anticipate running about 10 separate DBs on one server.

Help would be much appreciated.

Thank you

Martin

Reg Domaratzki $iAnywhere Solutions$

2005-04-05, 8:03 pm

The database server listens on port 2638 for connections on both databases.
If you want to connect to a database other than the default database, you
need to specify the ServiceName option in our connection URL. See the
following :

ASA Programming Guide
JDBC Programming
Using the jConnect JDBC driver
Supplying a URL for the server
Specifying a database on a server

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Server Admin" < sybase@businesscontr
ols.com> wrote in message
news:41c089e7$1@foru
ms-1-dub...
> Hello Everyone -
>
> I am searching for clarification on the ports used by dbsrv9. I am aware
of
> the default port 2638 when you start one dbsrv9 instance.
>
> Here is my situation.
>
> We run a RedHat Linux environment with SQL Anywhere Studio 9.0. We have a
> CPU license agreement for that machine. We are currently running a
> webapplication - App1 - on that server. We recently finished a second web
> application - App2 - that we now want to deploy on the same server.
>
> I used the command line "dbsrv9 -n DevSrv /path/DB1.db /path
DB2.db -qw -ud"
> to start the database server and allow access to the databases.
>
> When starting with the above command line it loads the dbsrv9 daemon just
> fine with the default 2638 port.
>
> My question: Do both (DB1 and DB2) listen on the 2638 port? Our
> applications require a jdbc connection with user/passwd and port
> information. When I use port 2638 I am only able to connect to DB1. In
> other words, does dbsrv9 use one port for multiple databases loaded?
>
> Is it a good idea to run a second instance of dbsrv9 on a different port,
> like 2639? Using the command line "dbsrv9 -x tcpip(ServerPort=263
9)? I
have
> a hard time to believe this would be the case.
>
> What is the best way to start the dbsrv9 daemon with multiple databases?
We
> anticipate running about 10 separate DBs on one server.
>
> Help would be much appreciated.
>
> Thank you
>
> Martin
>
>

Sponsored Links