Table of Contents

DB2 Remote nodes/databases

Data Server Driver

Set path to data server drive cfg file (db2dsdriver.cfg) : 

db2set DB2DSDRIVER_CFG_PATH=<PATH>

Export current DS catalog into cfg : 

db2dsdcfgfill -i <INSTANCE> -o </OUTPUT>

Client connections

Export/import client-to-server configuration : 

db2cfexp
db2cfimp

Check cataloged nodes : 

db2 list node directory

Catalog remote node : 

db2 catalog tcpip node <NODENAME> remote <HOSTNAME> server <PORT/SERVICE>

Uncatalog remote node : 

db2 uncatalog node <NODENAME>

Catalog remote database : 

db2 catalog db <REMOTEDB> [as <ALIAS>] at node <NODENAME>

Uncatalog remote database : 

db2 uncatalog db <REMOTEDB|ALIAS>

Windows ODBC : 

db2cli writecfg add -dsn <DSNNAME> -database <DBNAME> -host <HOSTNAME/IP> -port <PORT/SERVICE>
db2cli registerdsn -add -dsn <DSNNAME> -system
db2cli validate -dsn <DSNNAME> -connect -user <USER> -passwd <PASSWORD>