Monday, October 17, 2011

How to connect remote Database in DB2



Here we will see how to to connect to remote database in DB2.
Step: 1 Check for Node catalog
db2 list node directory
Step:2 Check for Database catalog
db2 list database directory
Step:3 Create Catalog for the remote node
db2 catalog tcpip node <nodeName> remote <Remote IP Address> server <port number>
Step: 4 create Catalog for the remote database
db2 catalog database <databaseName> at node <nodeName>
Step: 5 Display the newly cataloged node
db2 list node directory
Step 6: Display newly cataloged database
db2 list database directory
Now remote database is ready to access!

No comments:

Post a Comment