many ports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yasaswi Pulavarti - 19 Nov 2004 15:13 GMT

In a given instance if there are three databases is it possible to
have a unique port for each database? Even further is it possible to
have many unique ports assigned to each database.
What are the performance implications for having a unique port or
ports assinged to each database? Is it a better idea or no or what?
Please explain.
Thanks,
Yasaswi

Reply to this Message

Norbert Munkel - 19 Nov 2004 16:14 GMT

Hello,

> In a given instance if there are three databases is it possible to
> have a unique port for each database? Even further is it possible to
> have many unique ports assigned to each database.

presuming you are talking about TCPIP-Ports.

The connection port is configured for each instance (SVCENAME) . If you
need to have different tcpip ports for each database you have to put
them into separate instances.

regards,

Norbert

Reply to this Message

Ian - 19 Nov 2004 18:51 GMT

> In a given instance if there are three databases is it possible to
> have a unique port for each database? Even further is it possible to
> have many unique ports assigned to each database.
> What are the performance implications for having a unique port or
> ports assinged to each database? Is it a better idea or no or what?

Why would you want to do this?

Reply to this Message

Yasaswi Pulavarti - 20 Nov 2004 13:44 GMT

Is there a performance benefit to assign different ports to different
databases? When SQL connections are made from applications to the
databases, if more than one database is in one instance, then all the
network traffic is going to that one instance level port, is that ok?
Please comment.
Thanks,
Yasaswi

> > In a given instance if there are three databases is it possible to
> > have a unique port for each database? Even further is it possible to
[quoted text clipped - 3 lines]
>
> Why would you want to do this?

Reply to this Message

Ian - 21 Nov 2004 02:42 GMT

> Is there a performance benefit to assign different ports to different
> databases? When SQL connections are made from applications to the
> databases, if more than one database is in one instance, then all the
> network traffic is going to that one instance level port, is that ok?
> Please comment.

It's highly unlikely that you will see an issue of contention on one
port. It is possible that a single TCP connection manager could get
swamped -- but that is why there's a registry variable (DB2TCPCONNMGRS)
that allows you to control this. I've worked on systems with thousands
of users connecting through one port without issue.

Reply to this Message