Friday, October 14, 2005

Cataloging AS/400 database on DB2 Connect

Command sequence to catalog AS/400 database in DB2 Connect:

  • db2 catalog tcpip node <node_name> remote <host_name> server <port_no>
  • db2 catalog dcs database <local_name> as <real_db_name>
  • db2 catalog database <local_name> as <alias> at node <node_name> authentication dcs

Command sequence to catalog the as/400 database that was already cataloged in DB2 Connect.

  • db2 catalog tcpip node <node_name> remote <host_name_or_address> server <port_no>*
  • db2 catalog database <local_name> as <alias> at node <node_name>

*Use the portnumber of DB2 connect not AS/400

No comments: