db2_remote [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== DB2 Remote nodes/databases ======
===== Data Server Driver =====
**Set path to data server drive cfg file (db2dsdriver.cfg) :**
<sxh bash>
db2set DB2DSDRIVER_CFG_PATH=<PATH>
</sxh>

**Export current DS catalog into cfg :**
<sxh bash>
db2dsdcfgfill -i <INSTANCE> -o </OUTPUT>
</sxh>

===== Client connections =====

**Export/import client-to-server configuration : **
<sxh bash>
db2cfexp
db2cfimp
</sxh>

**Check cataloged nodes :**
<sxh bash>
db2 list node directory
</sxh>

**Catalog remote node :**
<sxh bash>
db2 catalog tcpip node <NODENAME> remote <HOSTNAME> server <PORT/SERVICE>
</sxh>

**Uncatalog remote node :**
<sxh bash>
db2 uncatalog node <NODENAME>
</sxh>

**Catalog remote database :**
<sxh bash>
db2 catalog db <REMOTEDB> [as <ALIAS>] at node <NODENAME>
</sxh>

**Uncatalog remote database :**
<sxh bash>
db2 uncatalog db <REMOTEDB|ALIAS>
</sxh>

**Windows ODBC :**
<sxh bash>
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>
</sxh>