473,320 Members | 1,862 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,320 software developers and data experts.

Problem setting up new instance.


Folks,

I am having hard time figuring out the problem I have with setting up new
DB2 instance. This is 22nd instance I am creating on the server and I
have never encounterd this problem. My server and client (2 different
systems) are running AIX 5.3 and DB2 8.2.

On server I have created instance as follows:

# ./db2icrt -a client -p 60085 -u db2fenc1 -s ese db2inst22
DBI1070I Program db2icrt completed successfully.

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60085

I grant connect priviledge to public.

When I check /etc/services I see following:

DB2_db2inst22 60084/tcp
DB2_db2inst22_1 60085/tcp
DB2_db2inst22_2 60086/tcp
DB2_db2inst22_END 60087/tcp
Why does the first entry start with one port less than what I specified?
What are other ports used for?

When I check the entries for one of the other instance the entries start
with the port number specified on create instance statement:

DB2_db2inst21 60080/tcp
DB2_db2inst21_1 60081/tcp
DB2_db2inst21_2 60082/tcp
DB2_db2inst21_END 60083/tcp

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60080
I catalog node and database on the client system, but when I try to connect
to the database I get following error:

$ db2 connect to mydb
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.90.10.125". Communication function
detecting the error: "connect". Protocol specific error code(s): "79", "*",
"*". SQLSTATE=08001
errno 79 -Connection refused.

netstat command on server shows that it is listening to the port:

# netstat -an | grep 60085
tcp4 0 0 *.60085 *.* LISTEN

On server and client DB2COMM is set to tcpip

$ db2set
DB2COMM=tcpip
I have setup 21 other instances on the server and some of them are cataloged
on the same client as above, but I do not have any problem with them.

What am I missing?

Thanks
--
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.
Apr 5 '07 #1
6 6530
Did you remember to open the new ports on the server's firewall?

Phil Sherman
Hemant Shah wrote:
Folks,

I am having hard time figuring out the problem I have with setting up new
DB2 instance. This is 22nd instance I am creating on the server and I
have never encounterd this problem. My server and client (2 different
systems) are running AIX 5.3 and DB2 8.2.

On server I have created instance as follows:

# ./db2icrt -a client -p 60085 -u db2fenc1 -s ese db2inst22
DBI1070I Program db2icrt completed successfully.

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60085

I grant connect priviledge to public.

When I check /etc/services I see following:

DB2_db2inst22 60084/tcp
DB2_db2inst22_1 60085/tcp
DB2_db2inst22_2 60086/tcp
DB2_db2inst22_END 60087/tcp
Why does the first entry start with one port less than what I specified?
What are other ports used for?

When I check the entries for one of the other instance the entries start
with the port number specified on create instance statement:

DB2_db2inst21 60080/tcp
DB2_db2inst21_1 60081/tcp
DB2_db2inst21_2 60082/tcp
DB2_db2inst21_END 60083/tcp

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60080
I catalog node and database on the client system, but when I try to connect
to the database I get following error:

$ db2 connect to mydb
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.90.10.125". Communication function
detecting the error: "connect". Protocol specific error code(s): "79", "*",
"*". SQLSTATE=08001
errno 79 -Connection refused.

netstat command on server shows that it is listening to the port:

# netstat -an | grep 60085
tcp4 0 0 *.60085 *.* LISTEN

On server and client DB2COMM is set to tcpip

$ db2set
DB2COMM=tcpip
I have setup 21 other instances on the server and some of them are cataloged
on the same client as above, but I do not have any problem with them.

What am I missing?

Thanks

Apr 5 '07 #2
While stranded on information super highway Phil Sherman wrote:
Did you remember to open the new ports on the server's firewall?

Phil Sherman
This is on internal network and there is no firewall involved.
>

Hemant Shah wrote:
>Folks,

I am having hard time figuring out the problem I have with setting up new
DB2 instance. This is 22nd instance I am creating on the server and I
have never encounterd this problem. My server and client (2 different
systems) are running AIX 5.3 and DB2 8.2.

On server I have created instance as follows:

# ./db2icrt -a client -p 60085 -u db2fenc1 -s ese db2inst22
DBI1070I Program db2icrt completed successfully.

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60085

I grant connect priviledge to public.

When I check /etc/services I see following:

DB2_db2inst22 60084/tcp
DB2_db2inst22_1 60085/tcp
DB2_db2inst22_2 60086/tcp
DB2_db2inst22_END 60087/tcp
Why does the first entry start with one port less than what I specified?
What are other ports used for?

When I check the entries for one of the other instance the entries start
with the port number specified on create instance statement:

DB2_db2inst21 60080/tcp
DB2_db2inst21_1 60081/tcp
DB2_db2inst21_2 60082/tcp
DB2_db2inst21_END 60083/tcp

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60080
I catalog node and database on the client system, but when I try to connect
to the database I get following error:

$ db2 connect to mydb
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.90.10.125". Communication function
detecting the error: "connect". Protocol specific error code(s): "79", "*",
"*". SQLSTATE=08001
errno 79 -Connection refused.

netstat command on server shows that it is listening to the port:

# netstat -an | grep 60085
tcp4 0 0 *.60085 *.* LISTEN

On server and client DB2COMM is set to tcpip

$ db2set
DB2COMM=tcpip
I have setup 21 other instances on the server and some of them are cataloged
on the same client as above, but I do not have any problem with them.

What am I missing?

Thanks

--
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.
Apr 5 '07 #3

This is strange. I manually edited the /etc/services file on the server
and changed the port numbers as follows:
DB2_db2inst22 60085/tcp
DB2_db2inst22_1 60086/tcp
DB2_db2inst22_2 60087/tcp
DB2_db2inst22_END 60088/tcp

and now I am able to connect to the database.

I am not sure why the db2icrt command adds entry that starts with one port
number less than what was specified on the command line.

What are the other three ports used for?

Thanks.

While stranded on information super highway Hemant Shah wrote:
>
Folks,

I am having hard time figuring out the problem I have with setting up new
DB2 instance. This is 22nd instance I am creating on the server and I
have never encounterd this problem. My server and client (2 different
systems) are running AIX 5.3 and DB2 8.2.

On server I have created instance as follows:

# ./db2icrt -a client -p 60085 -u db2fenc1 -s ese db2inst22
DBI1070I Program db2icrt completed successfully.

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60085

I grant connect priviledge to public.

When I check /etc/services I see following:

DB2_db2inst22 60084/tcp
DB2_db2inst22_1 60085/tcp
DB2_db2inst22_2 60086/tcp
DB2_db2inst22_END 60087/tcp
Why does the first entry start with one port less than what I specified?
What are other ports used for?

When I check the entries for one of the other instance the entries start
with the port number specified on create instance statement:

DB2_db2inst21 60080/tcp
DB2_db2inst21_1 60081/tcp
DB2_db2inst21_2 60082/tcp
DB2_db2inst21_END 60083/tcp

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60080
I catalog node and database on the client system, but when I try to connect
to the database I get following error:

$ db2 connect to mydb
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.90.10.125". Communication function
detecting the error: "connect". Protocol specific error code(s): "79", "*",
"*". SQLSTATE=08001
errno 79 -Connection refused.

netstat command on server shows that it is listening to the port:

# netstat -an | grep 60085
tcp4 0 0 *.60085 *.* LISTEN

On server and client DB2COMM is set to tcpip

$ db2set
DB2COMM=tcpip
I have setup 21 other instances on the server and some of them are cataloged
on the same client as above, but I do not have any problem with them.

What am I missing?

Thanks
--
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.
--
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.
Apr 5 '07 #4
Ian
Hemant Shah wrote:
Folks,

I am having hard time figuring out the problem I have with setting up new
DB2 instance. This is 22nd instance I am creating on the server and I
have never encounterd this problem. My server and client (2 different
systems) are running AIX 5.3 and DB2 8.2.

On server I have created instance as follows:

# ./db2icrt -a client -p 60085 -u db2fenc1 -s ese db2inst22
DBI1070I Program db2icrt completed successfully.

$ db2 get dbm cfg | grep SVC
TCP/IP Service name (SVCENAME) = 60085

I grant connect priviledge to public.

When I check /etc/services I see following:

DB2_db2inst22 60084/tcp
DB2_db2inst22_1 60085/tcp
DB2_db2inst22_2 60086/tcp
DB2_db2inst22_END 60087/tcp
These ports are used by the FCM for inter-partition communication.

Generally this only applies to systems that use DPF. However, you
should not use these for the client connection port, it's a bad
practice -- because if you do start using DPF, you'll have to make
changes to either the client connection port or change these entries.

I usually have 5 ports on a system that uses DPF with 4 partitions per
server:

db2cdb2inst22 50084/tcp # DB2 Client Communication
DB2_db2inst22 60084/tcp # DB2 FCM
DB2_db2inst22_1 60085/tcp # DB2 FCM
DB2_db2inst22_2 60086/tcp # DB2 FCM
DB2_db2inst22_END 60087/tcp # DB2 FCM
One other note: db2icrt does not add these entries to /etc/services
-- they must have been added earlier, either by hand or by db2setup.

Apr 6 '07 #5
Ian wrote:
One other note: *db2icrt does not add these entries to /etc/services
-- they must have been added earlier, either by hand or by db2setup.
Actually, db2icrt does add the FCM ports to /etc/services.
Apr 6 '07 #6
Ian
Darin McBride wrote:
Ian wrote:
>One other note: db2icrt does not add these entries to /etc/services
-- they must have been added earlier, either by hand or by db2setup.

Actually, db2icrt does add the FCM ports to /etc/services.
Really? In DB2 v8.2? When did that start?
Apr 6 '07 #7

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

Similar topics

5
by: Hari | last post by:
Guys please help me to solve this strange problem what Iam getting as follows.. Trying to instantiate a global instance of a template class as follows :- when i build this code with debug and...
15
by: Ron L | last post by:
We are working on a distributed VB.Net application which will access a SQL database located on a known server. Each client will run on the user's local machine. To implement this, we are trying...
1
by: rory | last post by:
Have the following setting in my app.config: <setting name="Scenes" serializeAs="Xml"> <value> <ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"...
18
by: Daniel | last post by:
Hey guys I have an instance of an object say: List<Object> myList = new List<Object>(); Object myObject = new Object(); myObject.PositionVector = new Vector3(10,10,10); ...
5
by: Frank Swarbrick | last post by:
Has anyone come upon this problem? My DB2/LUW 9.1 database seems to be both "started and not started". Check out the following: C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample SQL1032N ...
8
by: =?Utf-8?B?T2xpdmllciBHSUw=?= | last post by:
Hello, I try to convert a volume stored as a string value in an XML file into a Decimal object. The volume is stored with comma as decimal separator ("210,12") according to french habits. To be...
5
by: Nightfall | last post by:
Dear friends, consider the following scenario, in Visual Studio 2005 and C# - I create a ASP.NET web service ("server") with a class MyClass and a WebMethod SomeMethod() - I create a client...
5
by: jbenner | last post by:
I have opened a PMR for this with IBM, and am not asking for advice from the DB2 DBA community. I am posting this as an FYI that DB2 Health Monitor, even at the latest version of DB2, still can cause...
2
by: d-42 | last post by:
Hi, I'm pretty sure I've just got a Marshalling problem, but I'm completely stumped. If there is a better newsgroup to post this in, please point me towards it. First I'm trying to use...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.