Description of the DB2 database catalog. DB2 database cataloguing description [db2inst2 @ localhost ~] $ Db2catalogtcpipnodenode_247remote108.88.3.247server50000DB20000ICATALOGTCPIPNODE command is successfully completed. DB21056W until the definition of the DB2 database is refreshed
[Db2inst2 @ localhost ~] $ Db2 catalog tcpip node node_247 remote 108.88.3.247 server 50000
The DB20000I catalog tcpip node command is successfully completed.
DB21056W does not take effect until the directory cache is refreshed.
[Db2inst2 @ localhost ~] $ Db2 catalog db ptsdb as ptsdb247 at node node_247
The DB20000I catalog database command is successfully completed.
DB21056W does not take effect until the directory cache is refreshed.
Db2inst2 @ localhost ~] $ Db2 list db directory
Database 4 entries:
Database alias = PTSDB247
Database name = PTSDB
Node name = NODE_247
Database release level = d.00
Note =
Directory entry type = Remote
Directory database partition number =-1
Backup Server host name =
Backup Server port number =
[Db2inst2 @ localhost ~] $ Db2 connect to ptsdb user administrator
Enter the current password of administrator:
Database Connection information
Database server = DB2/NT 9.5.7
SQL authorization id = ADMINIST...
Local database alias = PTSDB
Table/View mode type creation time
-----------------------------------------------------------------------------
Tank administrator t 2015-09-08-17.44.59.243001
1 record selected.
Usage [db2inst2 @ localhost ~] $ Db2 catalog tcpip node node_247 remote 108.88.3.247 server 50000 DB20000I catalog tcpip node command is successfully completed. DB21056W until refreshing...