| Author |
Message |
Larry
*nix forums Guru
Joined: 20 Feb 2005
Posts: 325
|
 Posted: Tue Feb 08, 2005 11:27 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
You would need to set up Federated Support using nicknames. See the DB2
UDB Federated Systems Guide and the CREATE WRAPPER, CREATE SERVER,
CREATE NICKNAME etc. commands in the Command Reference.
Larry Edelstein
Nick Palmer wrote:
| Quote: | Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two
DB2 databases and I need to get access to the tables in one from the other.
In Oracle I would just create a DB Link between the two instances. Is such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
|
|
| Back to top |
|
 |
Nick Palmer
*nix forums beginner
Joined: 17 May 2005
Posts: 5
|
| Posted: Wed Feb 09, 2005 2:59 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Larry,
Thanks for the information. Thats exactly what I was looking for.
Nick
"Larry" <larry@nospam.net> wrote in message
news:gVcOd.2707$NH5.1188@fe08.lga...
| Quote: | You would need to set up Federated Support using nicknames. See the DB2
UDB Federated Systems Guide and the CREATE WRAPPER, CREATE SERVER,
CREATE NICKNAME etc. commands in the Command Reference.
Larry Edelstein
Nick Palmer wrote:
Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have
two
DB2 databases and I need to get access to the tables in one from the
other.
In Oracle I would just create a DB Link between the two instances. Is
such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
|
|
| Back to top |
|
|
Thiru
*nix forums addict
Joined: 20 May 2005
Posts: 80
|
| Posted: Thu Feb 10, 2005 5:45 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Hi,
Machine 1
---------
ip: 10.10.60.3
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : WinXP(Sp2)
Machine 2:
----------
ip: 10.10.60.16
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : Win2k Professional
Can you guys help me establishing db link between these 2 system. I
want to access machine 2 from machine 1..
Advance Thx,
Thiru
WantedToBeDBA. |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Thu Feb 10, 2005 6:15 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"WantedToBeDBA" <WantedToBeDBA@gmail.com> wrote in message
news:e6babb47.0502092245.16531e54@posting.google.com...
| Quote: | Hi,
Machine 1
---------
ip: 10.10.60.3
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : WinXP(Sp2)
Machine 2:
----------
ip: 10.10.60.16
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : Win2k Professional
Can you guys help me establishing db link between these 2 system. I
want to access machine 2 from machine 1..
Advance Thx,
Thiru
WantedToBeDBA.
|
1. Open the DB2 Command Window on machine 1 (the one without db2 prompt).
See DB2 Command Line Tools.
2. db2 catalog tcpip node machine2 remote 10.10.60.16 server 50000
3. db2 catalog db sample as sample2 at node machine2
4. db2 connect to sample2 user xxxxxx (or open Control Center)
Notes:
a) In step 2 "machine2" can be any name you want to identify the DB2
instance on that machine
b) better to use host-name instead of IP addresses in step 2, assuming you
can ping it with host-name
c) In step 4, xxxxx is the user id authorized to connect to database on
machine 2. DB2 will prompt for your password.
Please send $15.00 to paypal account m0002a@yahoo.com |
|
| Back to top |
|
|
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Thu Feb 10, 2005 6:35 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
WantedToBeDBA wrote:
| Quote: | Hi,
Machine 1
---------
ip: 10.10.60.3
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : WinXP(Sp2)
Machine 2:
----------
ip: 10.10.60.16
DB2 V8.1 installed.
Database Name : sample
Running port : 50000(default)
OS : Win2k Professional
Can you guys help me establishing db link between these 2 system. I
want to access machine 2 from machine 1..
|
Exactly which step is causing you problems? What is the problem (exact
error message would be very helpful)?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena |
|
| Back to top |
|
|
Mark B. Townsend
*nix forums beginner
Joined: 14 Jun 2005
Posts: 3
|
| Posted: Thu Feb 10, 2005 2:50 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark A wrote:
| Quote: |
1. Open the DB2 Command Window on machine 1 (the one without db2 prompt).
See DB2 Command Line Tools.
2. db2 catalog tcpip node machine2 remote 10.10.60.16 server 50000
3. db2 catalog db sample as sample2 at node machine2
4. db2 connect to sample2 user xxxxxx (or open Control Center)
|
Does this set up the equivalent to DB links however ? For instance, can
the user now 'connect' to the sample database on machine1, and issue a
query against a table that is in sample database on machine2 ? Surely
something else is needed to define/share the meta data between the two
data dictionaries ? |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Thu Feb 10, 2005 4:11 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark B. Townsend wrote:
| Quote: | Mark A wrote:
1. Open the DB2 Command Window on machine 1 (the one without db2 prompt).
See DB2 Command Line Tools.
2. db2 catalog tcpip node machine2 remote 10.10.60.16 server 50000
3. db2 catalog db sample as sample2 at node machine2
4. db2 connect to sample2 user xxxxxx (or open Control Center)
Does this set up the equivalent to DB links however ? For instance, can
the user now 'connect' to the sample database on machine1, and issue a
query against a table that is in sample database on machine2 ? Surely
something else is needed to define/share the meta data between the two
data dictionaries ?
Mark, |
check the rest of the thread where wrappers, nicknames, etc are debated.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Thu Feb 10, 2005 5:44 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"Mark B. Townsend" <Mark.Townsend@oracle.com> wrote in message news:4ILOd.29
| Quote: |
Does this set up the equivalent to DB links however ? For instance, can
the user now 'connect' to the sample database on machine1, and issue a
query against a table that is in sample database on machine2 ? Surely
something else is needed to define/share the meta data between the two
data dictionaries ?
|
That would require setting up federated support with wrappers and aliases.
But the post just said that he wanted to connect to the sample database on
machine 2 from machine 1. For that, I provided everything he needs.
If he also wants to connect to the sample database on machine 1, and then
access the data on another database (local or remote) without connected to
the other database, then federated support is needed. |
|
| Back to top |
|
|
Mark Townsend
*nix forums Guru Wannabe
Joined: 02 Apr 2005
Posts: 213
|
| Posted: Fri Feb 11, 2005 12:58 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark A wrote:
| Quote: |
But the post just said that he wanted to connect to the sample database on
machine 2 from machine 1. For that, I provided everything he needs.
|
He used the term db link so I'm assuming he does want full federated
support. I know I'd be interested in seeing the steps involved in
setting up a federated environment |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Fri Feb 11, 2005 1:48 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"Mark Townsend" <markbtownsend@comcast.net> wrote in message
news:vsKdnajBrNWjjJHfRVn-og@comcast.com...
| Quote: | Mark A wrote:
But the post just said that he wanted to connect to the sample database
on
machine 2 from machine 1. For that, I provided everything he needs.
He used the term db link so I'm assuming he does want full federated
support. I know I'd be interested in seeing the steps involved in
setting up a federated environment
I charge $25 for that one. Send me the money at paypal account |
m0002a@yahoo.com and I will tell you how it is done. |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
|
| Back to top |
|
|
Larry
*nix forums Guru
Joined: 20 Feb 2005
Posts: 325
|
| Posted: Fri Feb 11, 2005 3:40 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Does IBM have anyone who hangs out on comp.databases.oracle.server and
asks people what the steps are to do things in Oracle?
Larry Edelstein
Serge Rielau wrote:
|
|
| Back to top |
|
|
Thiru
*nix forums addict
Joined: 20 May 2005
Posts: 80
|
| Posted: Fri Feb 11, 2005 4:12 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Hi,
I have istalled DB2 V8.1 ESE in WinXp. When i create the wrapper it
say db2net8.dll is missing? How to solve this issue??
Thiru.
WantedToBeDBA. |
|
| Back to top |
|
|
Jan M. Nelken
*nix forums Guru Wannabe
Joined: 26 May 2005
Posts: 126
|
| Posted: Fri Feb 11, 2005 4:55 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Thiru wrote:
| Quote: | Hi,
I have istalled DB2 V8.1 ESE in WinXp. When i create the wrapper it
say db2net8.dll is missing? How to solve this issue??
Thiru.
WantedToBeDBA.
|
From the documentation:
The relational wrappers are a part of ***DB2 Information Integrator*** that is
used with DB2 Universal Database(TM) for Linux, UNIX(R), and Windows(R) and DB2
Universal Database Enterprise Server Edition.
Relational wrappers are wrappers for non-IBM relational databases. In DB2
Universal Database Version 8, relational wrappers are required if you want to
access data that is stored in Microsoft(R) SQL Server, ODBC, Oracle, Sybase, and
Teradata data sources.
Access to data that is stored in IBM(R) databases (DB2 Universal Database and
Informix(R)) is built into DB2 Universal Database for Linux, UNIX, and Windows.
Did you acquired and installed DB2 Information Integrator (currently named
Websphere Information Integrator)?
Jan M. Nelken |
|
| Back to top |
|
|
Jonathan Leffler
*nix forums beginner
Joined: 22 Mar 2005
Posts: 24
|
| Posted: Fri Feb 11, 2005 5:14 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Larry wrote:
| Quote: | Does IBM have anyone who hangs out on comp.databases.oracle.server and
asks people what the steps are to do things in Oracle?
|
Serge is sometimes seen over there; me too, very occasionally.
| Quote: | Serge Rielau wrote:
Mark Townsend wrote:
Mark A wrote:
But the post just said that he wanted to connect to the
sample database on machine 2 from machine 1. For that, I
provided everything he needs.
He used the term db link so I'm assuming he does want full
federated support. I know I'd be interested in seeing the steps
involved in setting up a federated environment
There is quite a bit of good reading on developerWorks. [...]
|
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
