catalog node and DNS lookup

[Dan van Ginhoven]

Hi!

I had a node cataloged with an explict IP-address.
I tried to change to a fully qualified name but:

db2 catalog tcpip node mynode remote db2server.mycompany.biz server 50001
The catalog command was acccepted, db2 was restarted,
but when I tried to connect to a database on that node:
SQL1042C An unexpected system error occurred. SQLSTATE=58004

I then uncataloged and issued
db2 catalog tcpip node mynode remote db2server server 50001
where db2server is registrered in /etc/hosts and it worked OK.

Does DB2 not perform DNS lookup?
The client db2 is V9.1 on Linux and DNS lookups are working for other applications

/dg

[Dan van Ginhoven]

Hi!

The RTFM says about hostname:
"The hostname is the name of the node that is known to the TCP/IP network. The maximum length of the hostname is 255 characters. "
None of the examples has a fully qualified hostname, only simple ones.
On the other hand hostname of maxumum 255 characters imply that a FQ hostname should be possible.
Anyone have it working?

/dg
"Dan van Ginhoven" <da******@hotmail.comwrote in message news:Tq*****************@newsb.telia.net...

Hi!

I had a node cataloged with an explict IP-address.
I tried to change to a fully qualified name but:

db2 catalog tcpip node mynode remote db2server.mycompany.biz server 50001
The catalog command was acccepted, db2 was restarted,
but when I tried to connect to a database on that node:
SQL1042C An unexpected system error occurred. SQLSTATE=58004

I then uncataloged and issued
db2 catalog tcpip node mynode remote db2server server 50001
where db2server is registrered in /etc/hosts and it worked OK.

Does DB2 not perform DNS lookup?
The client db2 is V9.1 on Linux and DNS lookups are working for other applications

/dg