473,388 Members | 1,426 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

How many tcp ports does DB2 use?


Folks,

How many tcp ports does DB2 server use?

I installed UDB 8.2 on a AIX system and created several instances.
I used consecutive ports for each instance, but when I look at
/etc/services file, it seems that db2icrt command adds 4 ports for each
server.

Example:
I created several instances as follows:

Instance Name Port
----------------------
dbap11 50018
dba2test 60000
dba2prod 60001
Nov 12 '05 #1
2 2510
Ian
Hemant Shah wrote:
Folks,

How many tcp ports does DB2 server use?

I installed UDB 8.2 on a AIX system and created several instances.
I used consecutive ports for each instance, but when I look at
/etc/services file, it seems that db2icrt command adds 4 ports for each
server.

[...]

I had created and instance, and decided that I need to change the name,
so I dropped it, but the entries in /etc/services file is still there.

DB2_dba2tst 60036/tcp
DB2_dba2tst_1 60037/tcp
DB2_dba2tst_2 60038/tcp
DB2_dba2tst_END 60039/tcp


These other ports are created if you have installed DB2 UDB ESE. They
are only used if you are using the database partitioning feature (DPF)
-- the fast communications manager uses these ports for inter-partition
communication.

Nov 12 '05 #2
While stranded on information super highway Ian wrote:
Hemant Shah wrote:
Folks,

How many tcp ports does DB2 server use?

I installed UDB 8.2 on a AIX system and created several instances.
I used consecutive ports for each instance, but when I look at
/etc/services file, it seems that db2icrt command adds 4 ports for each
server.

[...]
>
I had created and instance, and decided that I need to change the name,
so I dropped it, but the entries in /etc/services file is still there.

DB2_dba2tst 60036/tcp
DB2_dba2tst_1 60037/tcp
DB2_dba2tst_2 60038/tcp
DB2_dba2tst_END 60039/tcp


These other ports are created if you have installed DB2 UDB ESE. They
are only used if you are using the database partitioning feature (DPF)
-- the fast communications manager uses these ports for inter-partition
communication.


I do not use partitioning feature, so, I could modify the /etc/services file
and remove these entries so that I do not get confused reading output
of netstat, etc. commands.

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tech Witch | last post by:
Does anyone know of a quick reference I could provide to the it security folks at my work that outlines what file extensions, ports, and dll's sql server uses? They've gone hog wild with...
4
by: M. Raab | last post by:
i have written an application that utilizes serail ports. In order not to have to reinvent code, I decided to use John Hind's sample code that he presented in MSDN magazine last year (Serial Comm:...
3
by: andyI | last post by:
Where do I find information on how to address and pass data to and from the serial ports and USB ports in VB. VB6 supports the serial ports easily but I see no reference to using the USB ports....
7
by: TClancey | last post by:
Hi. I have an app that is going to connect to several virtual com ports, although the system will see them as 'real'. How can I list the installed com ports on the system? I've found...
3
by: Mugunth | last post by:
Hi, I've a strange problem with serial port class of .NET Framework 2.0 I use com0com (Null Modem COM Port emulator) to emulate a virtual port. This application creates virtual com port pairs...
11
by: kudruu | last post by:
Hi, I am trying to find a way to populate a list of active Com ports on a computer. There may be around 30 on one computer and all connected to different Buses but I am looking for one in...
3
by: kudruu | last post by:
Hi, I tried posting this in comp.lang.C but need more specific help using winAPI. I am trying to find a way to populate a list of active Com ports on a computer. There may be around 30 on one...
1
by: DR | last post by:
What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro? When I attach to remote process a connection shows up...
3
by: }{ | last post by:
I have an app that reads a character string on com 1, waits for a signal (any ascii char) on com 2, then outputs the string on com 2. I seem to have a problem with the timing. It just so happens...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.