Multiple choice technology databases

A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?

  1. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446

  2. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446

  3. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1

  4. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The CATALOG TCPIP NODE command syntax is CATALOG TCPIP NODE REMOTE SERVER . The local node name (mydb2srv) is an alias you create - it is not the remote hostname. Option B correctly specifies mydb2srv as the local node name and myhost as the remote system. Options A and C incorrectly use the remote hostname as the local node name. Option D incorrectly uses the IP address instead of the port number for the SERVER parameter.

Keep practicing — related questions