RE: Problems with nodes

RE: Problems with nodes

 

  

Hello Daniel, and all,

Thanks for the help you have given me and for listening to my moaning
rants about evil AIX...

It seems after all that the firewall is the culprit - that is despite
the fact that I had been assured that the ports had been opened etc.

Have a nice weekend everyone.

Aurora

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x21419835.[Email address protected]
Sent: 23 November 2007 14:25
To: LazyDBA Discussion
Subject: RE: Problems with nodes


i would go back and make sure the client has that exact same
/etc/services as the server and.






"Dell Anno Aurora Emanuela BUSSIGNY Contractor for NBS IS/IT "
<db2udbdba-ezmlmshield-x64457239.[Email address protected]
11/23/2007 04:55 AM

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

Subject
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



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