Technical Blog Post
Abstract
50 DB2 Nuggets #43 : Techtip - Does Replication Center use db2dsdriver.cfg file?
Body
Does DB2 Replication center GUI tool use db2dsdriver.cfg file?
The answer is No.
db2dsdriver.cfg does not work with Replication Center, it uses command line catalog entries, you would need to catalog the node/db manually to be able to work with Replication Center.
Here is a quick demo:
C:\Program Files\IBM\SQLLIB_01\BIN>db2level
DB21085I This instance or install (instance name, where applicable: "DB2_01")
uses "64" bits and DB2 code release "SQL10013" with level identifier
"0204010E".
Informational tokens are "DB2 v10.1.300.533", "s130918", "IP23511", and Fix
Pack "3".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB~1" with DB2 Copy Name
"DB2COPY2".
db2dsdriver.cfg entries:
<configuration>
<dsncollection>
<dsn alias="mary" name="mary" host="ts-johng.lenexa.ibm.com" port="50001">
</dsn>
</dsncollection>
<databases>
<database name="mary" host="ts-johng.lenexa.ibm.com" port="50001">
</database>
</databases>
</configuration>
So, as seen above, the db: mary from db2dsdriver.cfg was not picked up by the Replication Center. It only has the local db "test7".
I've then cataloged the db mary from command line:
C:\Program Files\IBM\SQLLIB_01\BIN>db2 catalog tcpip node node1 remote ts-johng.lenexa.ibm.com server 50001
DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is refreshed.
C:\Program Files\IBM\SQLLIB_01\BIN>db2 catalog db mary at node node1
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is refreshed.
C:\Program Files\IBM\SQLLIB_01\BIN>db2 terminate
DB20000I The TERMINATE command completed successfully.
Re-launched Replication center, I can now see database "mary" being picked up by the Replication Center.
References:
db2dsdriver.cfg: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.swg.im.dbclient.config.doc/doc/c0054555.html?cp=SSEPGG_10.1.0%2F2-0-12-5-7-0&lang=en
Catalog database: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001936.html?cp=SSEPGG_10.1.0%2F3-6-2-4-10&lang=en
Thanks for reading! Please feel free to comment if any questions.
UID
ibm11141378