Problem connecting to os/390 from UDB

[riolucy]

Hello
Can anyone help with the following

I have UDB v7.2 Personal Edition with fixpack 4 installed on Windows 2000 and am trying to connect to a db2 os/390 database as the server. Previously using db2 connect 7.1 I could achieve this with fixpak 2 service level wr21250. Is there an equivalent patch/fixpak I need to install with 7.2

The error message I get when trying to log on is

The connection test failed.

[IBM][CLI Driver] SQL1097N The node name was not found in the node directory. SQLSTATE=42720

Regards
John

 

[MarcLodge]

Hi John,
Try this from IBM's website

The DB2 definition for this error is: SQL1097N The node name was not found in the node directory.

The node name associated with the database to which you want to connect must be cataloged. To catalog the node name, you must first determine the node name. To determine your required node name, from the DB2 command window, enter the command:

db2 list db directory

You are presented with a list of cataloged databases and associated node names. Select the database to which you want to connect, and note the node name associated with it. To make sure the node does not have a corrupt catalog, first uncatalog it by entering this command at the DB2 command window (where node-name is the name of your node):

db2 uncatalog node-name

Recatalog the node with this command (where node-name is the name of your node, and hostname is the name of the server on which the node resides):

db2 catalog tcpip node node-name remote hostname

Make sure you terminate DB2 and restart it. This action clears any previously cached catalog information. If your connection still does not work, reboot your system.



Hope this helps
Marc