DB2 Remote nodes/databases

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>

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>