RE: Problems with nodes

RE: Problems with nodes

 

  

Not quite but close enough.

[Email Address Removed] /db2/db2vsa3
$ db2 get dbm cfg | grep -i svcename
TCP/IP Service name (SVCENAME) = DB2_db2vsa3
[Email Address Removed] /db2/db2vsa3
$
DB2_db2vsa3 60000/tcp
DB2_db2vsa3_1 60001/tcp
DB2_db2vsa3_2 60002/tcp
DB2_db2vsa3_END 60003/tcp
(this is from a search for DB2 on /etc/services)

And yes,

$ db2set -all
[i] DB2COMM=tcpip
[Email Address Removed] /db2/db2vsa3
$

Please don't tell me it's upper and lower case causing the problem, or
rather, if it IS, please tell me and I can increase my loathing of this
fiddly platform tenfold :-S

Thanks Daniel.

Aurora

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

so a db2 get dbm cfg | grep -i svcename shows 60000

and a db2set -all shows DB2COMM=TCPIP ?

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]




"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x45868964.[Email address protected]
11/22/2007 01:51 PM

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

Subject
RE: Problems with nodes






In the DB2 Server server, yes, I have checked, we have a name and a
port.

On the DB2 client side, we have no entries in the /etc/services file for
the Server instance, just like in the rest of the clients (which work).

My command to catalog the node at the client side is:

$ db2 catalog TCPIP NODE ND18VSA3 remote hqadbd18.ctr.nestle.com SERVER
60000

I am pretty certain that there is a problem with this - only, I really
cannot for the life of me find out what...

What is DB2COMM? I mean, where do I check, on the client or server side,
please? I have no value for it on ANY of my clients...

I know I sound stupid, I am afraid AIX is my bane...

Thanks.

Aurora

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

So the svcename is 60000 , correct ?





"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x74955088.[Email address protected]
11/22/2007 12:55 PM

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

Subject
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



---------------------------------------------------------------------
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