Hi guys,

Am trying to replicate an instance on a new server, and in the DB2
application client server, I am having problems with cataloguing the
node - I have catalogued the new node but am having problems connecting
to the db.

Here is my output - does it give you any ideas on what I have done wrong
please?

Thanks in advance.

Aurora



$ db2 list db directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = VDSA3CH1
Database name = VDSA3CH1
Node name = ND18VSA3
Database release level = a.00
Comment =
Directory entry type = Remote
Authentication = SERVER_ENCRYPT
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = VDSA3DK1
Database name = VDSA3DK1
Node name = ND18VSA3
Database release level = a.00
Comment =
Directory entry type = Remote
Authentication = SERVER_ENCRYPT
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

[Email Address Removed] /db2/db2insv1
$ db2 connect to VDSA3DK1
SQL1097N The node name was not found in the node directory.
SQLSTATE=42720
[Email Address Removed] /db2/db2insv1
$ db2 list node directory

Node Directory

Number of entries in the directory = 2

Node 1 entry:

Node name = DOCEURV
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 160.213.137.155
Service name = 50000

Node 2 entry:

Node name = ND18VSA3
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = hqadbd18.ctr.nestle.com
Service name = 60000

[Email Address Removed] /db2/db2insv1
$

DB2 & UDB email list listserv db2-l LazyDBA home page