By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Logon

P: n/a
I'm ashamed to ask this question because I did it before, but have not
done it in a few years.

For a brand new database, client server, V8.2, Win32, I need to connect
all clients to the server.

I forgot how, and the documentation doesn't help.

For the command on the client: CATALOG TCPIP NODE x REMOTE y, SERVER z

x = NODE NAME. How do I find it?
y = REMOTE IP ADDRESS. Is that the address of the server on which DB2
server is located?
z = PORT NUMBER. I have no idea how to find that.

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
28******@gmail.com wrote:
I'm ashamed to ask this question because I did it before, but have not
done it in a few years.

For a brand new database, client server, V8.2, Win32, I need to connect
all clients to the server.

I forgot how, and the documentation doesn't help.

For the command on the client: CATALOG TCPIP NODE x REMOTE y, SERVER z

x = NODE NAME. How do I find it?
y = REMOTE IP ADDRESS. Is that the address of the server on which DB2
server is located?
z = PORT NUMBER. I have no idea how to find that.


x - any name you choose; it will be used in next step;
y - fully qualified host name or ip address where DB2 resides;
z - service name or port number DB2 is listening on for incoming connections;

Note that z must match DBM configuration parameter SVCENAME. If using service
name - this is the name of the DB2 listening service defined in
C:\WINDOWS\SYSTEM32\DRIVERS\ETC
Example:

On Database server called myhost.mydomain.com:

Fragment of services file:

....
db2c_DB2 50000/tcp
db2c_DB2CTLSV 50001/tcp
db2icserver 51000/tcp
db2hpudm2 54002/tcp

DB2_DB2 60000/tcp
DB2_DB2_1 60001/tcp
DB2_DB2_2 60002/tcp
DB2_DB2_END 60003/tcp

DB2_DB2CTLSV 60004/tcp
DB2_DB2CTLSV_1 60005/tcp
DB2_DB2CTLSV_2 60006/tcp
DB2_DB2CTLSV_END 60007/tcp
....

Fragment of Database Manager configuration:

....

NetBIOS Workstation name (NNAME) =

TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
....
This concludes server configuration. To manually configure client to connect to
database SAMPLE on this server, you do:

CATALOG TCPIP NODE mynode REMOTE myhost.mydomain.com SERVER 50000
or
CATALOG TCPIP NODE mynode REMOTE myhost.mydomain.com SERVER db2c_DB2
if you modified services file on CLIENT to reflect db2c_DB2 service - same way
as on server;

CATALOG DB SAMPLE AT NODE mynode AUTHENTICATION SERVER;
Of course instead of learning those details you could use configuration wizard -
DB2 Configuration Assistant - invoke db2ca from command prompt

Jan M. Nelken


Nov 12 '05 #2

P: n/a
Thanks, Jan.

SS

Nov 12 '05 #3

P: n/a
Woops! I have installed Run Time Client on a new machine. Installed
8.1, updated to 8.2, and installed Fixpak 9a.

No command db2ca -- ?

SS

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.