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.