IBM Support

50 DB2 Nuggets #43 : Techtip - Does Replication Center use db2dsdriver.cfg file?

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>
 

 

image
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

image


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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 node:http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001944.html?cp=SSEPGG_10.1.0%2F3-6-2-4-17&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.

 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141378