Re: How to retireve port number on which a sybase db server is running?
- From: Nikhil <Nikhil@xxxxxxx>
- Date: Sat, 05 Jan 2008 23:59:20 +0530
Gans wrote:
Hi,
I completely missed the fact that we use Sybase iAnywhere (version 9
and 10 used to be called as ASA earlier) and not Sybase ASE. In this
context here is what describes the scenario what we have and what we
need.
We run Sybase DB Server in Network Mode (communication happens over
TCP/IP) and we have app talking to this DB Server. Right now app
starts the DB Server at a particular fixed port and always and who
ever needs to ping the DB Server can directly ping at that portno
because it is hard-coded per release and is know to every client.
Now we are changing this port where DB Server needs to be started to a
Dynamic port, as result of this we need following information
1. Is there anyway, if DB Server is running on a particular machine M1
(who's IP is known) we can get Portno where this DB server is running
we know the server name also. And note that even if it stores port nos
in a table we don't have much use unless there is an api which takes
DB Server Name and Machine to get the port no where it is running
because to connect to DB and start queering we need to know which port
the DB server is running.
2. Can Sybase iAnywhere server listen on a dynamic tcp port number for
communicating with the applications? To explain further on this, the
startup string for the server we are using is "..... -x
tcpip(BroadcastListener=NO;port=10280)". Here as you can see we are
specifying the tcp port number that Sybase DBServer should listen on.
Is it possible instead of us giving a fixed port number but Sybase to
listen on a dynamically generated port number (generated by itself)
and then let the application know of this number somehow? Does this
feature exists already?
3) Is there a way to query a running Sybase ASA server about what is
its listening TCP port?
4) Before Sybase ASA server listens on the port, is it possible for
any plug-in DLL to intervene and provide a dynamically generated tcp
port for it to listen on? Just a variation on question 2) to see
whether we can do something.
Kindly request you to help with these questions.
Thanks
Shreyas
On Dec 26, 5:00 pm, Gans <shreyasgan...@xxxxxxxxx> wrote:Alright thanks a lot.
Will get back if i need further assistance.
Best Regards
Shreyas
On Dec 26, 3:24 pm, Manish Negandhi <negandhi.man...@xxxxxxxxx> wrote:
Could you direct me to specific documents which you know may be useful?http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.tabl...
-HTH
Manish Negandhi
[TeamSybase Intern]
if the backend OS is Unix, can commands like netstat, lsof etc be used to determine the port number of the running process right ?
.
- Prev by Date: Re: How to retireve port number on which a sybase db server is running?
- Next by Date: Sybase ASE and High Ports
- Previous by thread: Re: How to retireve port number on which a sybase db server is running?
- Next by thread: Index on Date Column for select today
- Index(es):
Relevant Pages
|
|
