Mas DB2 Notes: Remote connection - Cataloging a TCP/IP node from a client using the CLP

[db2inst1@unica12-1-rhel79 ~]$ . ~/sqllib/db2profile

[db2inst1@unica12-1-rhel79 ~]$ db2

Command Line Processor for DB2 Client 11.1.0

You can issue database manager commands and SQL statements from the command

prompt. For example:

db2 => connect to sample

db2 => bind sample.bnd

For general help, type: ?.

For command help, type: ? command, where command can be

the first few keywords of a database manager command. For example:

? CATALOG DATABASE for help on the CATALOG DATABASE command

? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside

interactive mode, all commands must be prefixed with 'db2'.

To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => catalog tcpip4 node database-rhel79 remote 192.168.0.52 server 50000

SQL0104N An unexpected token "database-rhel79" was found following "NODE".

Expected tokens may include: "<node-name>". SQLSTATE=42601

db2 => catalog tcpip node db2node remote database-rhel79 server 50000

DB20000I The CATALOG TCPIP NODE command completed successfully.

DB21056W Directory changes may not be effective until the directory cache is

refreshed.

db2 => catalog database unicadb at node db2node

DB20000I The CATALOG DATABASE command completed successfully.

DB21056W Directory changes may not be effective until the directory cache is

refreshed.

db2 => connect to unicadb user uc

Enter current password for uc:

Database Connection Information

Database server = DB2/LINUXX8664 11.1.0

SQL authorization ID = UC

Local database alias = UNICADB

db2 =>

Mas DB2 Notes