RE: Problems with nodes

RE: Problems with nodes

 

  

Daniel,

I am reading in the manual that "If a port number is specified, no
service name needs to be specified in the local TCP/IP services file. "
- in fact, I have checked the file on the client server for other
applications, which work, and there are no entries for the server in any
of them.

Thanks.

Aurora

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x15460860.[Email address protected]
Sent: 22 November 2007 18:50
To: LazyDBA Discussion
Subject: RE: Problems with nodes

make sure that the value in svcename has an entry in the /etc/services
file on both client and server.(and its 60000)






"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x2601196.[Email address protected]
11/22/2007 11:36 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Problems with nodes






Right, I did so - now I get a different error:

[Email Address Removed] /db2/db2insv1
$ db2 connect to VDSA3DK1
SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "141.122.64.158". Communication function
detecting the error: "connect". Protocol specific error code(s): "78",
"*",
"*". SQLSTATE=08001
[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 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

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x14179444.[Email address protected]
Sent: 22 November 2007 17:32
To: LazyDBA Discussion
Subject: RE: Problems with nodes

logoff , login you may have the directory cached.






"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x18941066.[Email address protected]
11/22/2007 10:49 AM

To
"LazyDBA Discussion" <[Email address protected] cc

Subject
RE: Problems with nodes






Hi Daniel,

Sorry I should have specified - this is an AIX system, not windows.

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x11664981.[Email address protected]
Sent: 22 November 2007 16:40
To: LazyDBA Discussion
Subject: Re: Problems with nodes

Logoff and login back in and try again.






"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x70346954.[Email address protected]
11/22/2007 09:38 AM

To
"LazyDBA Discussion" <[Email address protected] cc

Subject
Problems with nodes






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
$


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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