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
