472,137 Members | 1,549 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,137 software developers and data experts.

Error SQL0104N on very simple client setup. Help.


In my setup, DB2 server is installed on a Windows box "test16"
and "SAMPLE" database has been loaded.

Now, on a clean Windows machine (test15), I installed DB2 client
From the instructions on the net, the first thing I must do on the

client machine (test15) is to catalog the tcpip node.

db2 => catalog tcpip node db2test16 remote test16 server 50000

If I do that, I am getting the following error:

SQL0104N An unexpected token "db2test16" was found
following "NODE". Expected tokens may include:
"<node-name>". SQLSTATE=42601

Can someone please tell me if there is another step that I missed?

The network connectivity is okay. I can ping between test16 and test15.

Thank you in advance for your help.


Nov 12 '05 #1
2 5745

Your nodename (db2test16) should be lessthan or equal to 8chars

Nov 12 '05 #2

Thank you for your help. That fixed the problem.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Brian Tkatch | last post: by
1 post views Thread by vkalvakota | last post: by
2 posts views Thread by ray well | last post: by
3 posts views Thread by =?Utf-8?B?eWtmZmM=?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.