Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create database Link

Status
Not open for further replies.
sivasivasivasivasiva

sivasivasivasivasiva

Programmer
Dec 16, 2003
5
HK
Hello,
We have tablename called "T1" in two different db2 database servers.Structure and creator of the table is same in both databases.
1) One server is our live system.(say "LIVE1")
2) Another server is our archieve database which is in the remote location.(say "LIVE2")
We want to fetch all the records from "LIVE1"."T1" and "LIVE2"."T1".

The sql query would be like this.
Select * from "LIVE1"."T1"
union
Select * from "LIVE2"."T1".

Is there any command like "CREATE DATABASE LINK" in Oracle in db2 v8.1?
Regards,
Shiva
 
Sort by date Sort by votes
Yes Greg..But this is a different task.I have checked the link which you posted in the previous post.
That link is not working.
I am getting the following message.

Our apologies...


The document you requested does not exist on this server or cannot be served.

Please double check the URL or use the search function on this page to find what you are looking for.

If you know you have the correct URL but are encountering an error, please let our Webmaster know at Thank you.

404 Not Found

Regards,
Shiva
 
Upvote 0 Downvote
In that message, the location name is the servername or ip address of the other dbname.Both are not working.I am very new to DB2 and i cannot able to find more about DDF also.

Regards,
Shiva
 
Upvote 0 Downvote
DDF is distributed data facility ... You will have to configure this if you want DB2 on mainframe to talk with other DB2s on the network ... Ask you DBA or System programeer for more information ...

HTH

Sathyaram

For db2 resoruces visit More DB2 questions answered at
 
Upvote 0 Downvote
This is only applicable for MVS (Mainframe).If the db is not in mainframe, in that case if we want to talk to another db2 server, what should we do?

Regards,
Shiva
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
358
handle907
handle907
ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
217
ColeFern
ColeFern
Khaleel2408
  • Locked
  • Question
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client
Replies
0
Views
206
Khaleel2408
Khaleel2408
jayanthsid
  • Locked
  • Question
Will Decode function works in IBM DB2 Database?
Replies
1
Views
131
fredericofonseca
fredericofonseca
jpotucek
  • Locked
  • Question
Recovering a Dropped Database
Replies
0
Views
77
jpotucek
jpotucek

Part and Inventory Search

Sponsor

Back
Top