| Author |
Message |
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 |
|
 |
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Fri Feb 11, 2005 5:53 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"Jonathan Leffler" <jleffler@earthlink.net> wrote in message
news:d3YOd.5677$mG6.3915@newsread1.news.pas.earthlink.net...
| Quote: | Larry wrote:
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.
Larry did not ask if Serge posts over there. He asked if anyone from IBM |
"asks people what the steps are to do things in Oracle." |
|
| Back to top |
|
|
Mark Townsend
*nix forums Guru Wannabe
Joined: 02 Apr 2005
Posts: 213
|
| Posted: Fri Feb 11, 2005 6:12 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?
|
Based on what I've seen of the some of the anti-Oracle competitive
material produced by IBM I would guess not. |
|
| Back to top |
|
|
Thiru
*nix forums addict
Joined: 20 May 2005
Posts: 80
|
| Posted: Fri Feb 11, 2005 8:57 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
No. We don't have licence for DB2 Information Integrator. Then i have
to try to get some trial version for practice...
Thanks,
Thiru.
WantedToBeDBA. |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Fri Feb 11, 2005 10:49 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?
On a hobby basis I do that. I don't see any harm in fostering a |
technical understanding of each others products.
I'd much rather prefer technical questions that flamewars.
We just concluded an, in parts, technical discussion of isolation levels
vs, locking and we compared Orcale Streams and DataGuard with HADR and
Q-replication in c.d.o.server.
Chere
Serge
PS: I presume you meant IBM DB2, because I'm quite certain that there
are at least as many IBM IGS/BCS folks in c.d.o.server as there are in
c.d.ibm-db2
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Fri Feb 11, 2005 4:12 pm 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?
Larry Edelstein
|
You mean like Serge and MarkA?
Seriously ... as long as it isn't trolling what's the issue? Hardly
anyone works in an environment where there is only a single database
vendor. And last time I checked software was a tool ... not a religion.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Larry
*nix forums Guru
Joined: 20 Feb 2005
Posts: 325
|
| Posted: Fri Feb 11, 2005 4:47 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Not the point, Daniel. The point is it's a bit of an annoyance to have
someone call into question what is involved with doing certain things in
one's product on an internet ng that is supposed to be dedicated to
people getting technical answers.
Larry Edelstein
DA Morgan wrote:
| Quote: | Larry wrote:
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
You mean like Serge and MarkA?
Seriously ... as long as it isn't trolling what's the issue? Hardly
anyone works in an environment where there is only a single database
vendor. And last time I checked software was a tool ... not a religion. |
|
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Fri Feb 11, 2005 5:08 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
DA Morgan wrote:
| Quote: | Larry wrote:
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
You mean like Serge and MarkA?
To the best of my knowledge Mark A. Isn't an IBM employee. |
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
Mark Townsend
*nix forums Guru Wannabe
Joined: 02 Apr 2005
Posts: 213
|
| Posted: Sat Feb 12, 2005 1:30 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Larry wrote:
| Quote: | The point is it's a bit of an annoyance to have
someone call into question what is involved with doing certain things in
one's product on an internet ng that is supposed to be dedicated to
people getting technical answers.
|
The point is that somebody asked specifically how to do something in DB2
which has still has not yet been answered by anyone on this ng, despite
it being dedicated to people getting technical answers. The one answer
that was given was not the correct one for the question posed. |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Sat Feb 12, 2005 1:45 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark Townsend wrote:
| Quote: | Larry wrote:
The point is it's a bit of an annoyance to have someone call into
question what is involved with doing certain things in one's product
on an internet ng that is supposed to be dedicated to people getting
technical answers.
The point is that somebody asked specifically how to do something in DB2
which has still has not yet been answered by anyone on this ng, despite
it being dedicated to people getting technical answers. The one answer
that was given was not the correct one for the question posed.
Timeout! |
Here is the reaction to the very first answer the original poster got:
"Larry,
Thanks for the information. Thats exactly what I was looking for.
Nick"
So.. either Firefox is messing something seriously up in my thread or
I'm unclear what the two of you are quibbling about.
Mark, did you receive the two links I provided in response to your
request? If yes, do they or do they not provide sufficient detail?
If there are any issues with usenet.. I recommend www.individual.net as
a timely mirror and Firefox is doing a fine job showing the threads....
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: Sat Feb 12, 2005 1:59 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
| Quote: | To the best of my knowledge Mark A. Isn't an IBM employee.
Cheers
|
That is correct. I am an independent consultant. |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Sat Feb 12, 2005 2:02 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"Mark Townsend" <markbtownsend@comcast.net> wrote in message
| Quote: | The one answer
that was given was not the correct one for the question posed.
I would say that the question was not correct for he wanted to know. |
He just said that he wanted to connect to a database on machine 2 from
machine 1. He did not say he wanted to be connected to a database on machine
1 and use that same connection to access a database on machine 2. |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Sat Feb 12, 2005 4:31 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark A wrote:
| Quote: | "Mark Townsend" <markbtownsend@comcast.net> wrote in message
The one answer
that was given was not the correct one for the question posed.
I would say that the question was not correct for he wanted to know.
He just said that he wanted to connect to a database on machine 2 from
machine 1. He did not say he wanted to be connected to a database on machine
1 and use that same connection to access a database on machine 2.
|
Perhaps this is just another one of those displays of my ignorance but
I thought the subject at the top of this thread defined the intent of
the OP's question. What an Oracle database link does is well documented.
The answer provided, as I understand it, does not do the same thing. So
while it may have answered the OP's question ... it did not address the
subject which is an equivalence to another product's functionality.
But lets not belabour the point ... I think there is room here for
everyone to feel like the communications have been less than clear.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Sat Feb 12, 2005 4:57 am Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1108186099.283356@yasure...
| Quote: | Perhaps this is just another one of those displays of my ignorance but
I thought the subject at the top of this thread defined the intent of
the OP's question. What an Oracle database link does is well documented.
The answer provided, as I understand it, does not do the same thing. So
while it may have answered the OP's question ... it did not address the
subject which is an equivalence to another product's functionality.
But lets not belabour the point ... I think there is room here for
everyone to feel like the communications have been less than clear.
--
Daniel A. Morgan
|
Here is the post I responded to from WantedToBeDBA, who is NOT the creator
of this thread (OP), so he did NOT make up the thread title which mentioned
Oracle DB Links:
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..
----------------------------------------------------------------------------
--------
Based on the above, and based on the fact that WantedToBeDBA did not create
this thread, I believe I answered the question exactly as it was asked.
I am still not absolutely convinced that WantedToBeDBA needs DB2 Federated
support, but it is hard to know based on the information provided. Unless he
needs to include tables from databases on each machine in the same SQL
statement, he probably doesn't need Federated and could suffice with the
instructions I gave him.
So, yes Daniel, your confusion of the OP by Nick Palmer with the post by
WantedToBeDBA that I answered, does display your ignorance of exactly what
happened.
: |
|
| Back to top |
|
|
Mark Townsend
*nix forums Guru Wannabe
Joined: 02 Apr 2005
Posts: 213
|
| Posted: Sat Feb 12, 2005 4:05 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Mark A wrote:
| Quote: | "DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1108186099.283356@yasure...
Perhaps this is just another one of those displays of my ignorance but
I thought the subject at the top of this thread defined the intent of
the OP's question. What an Oracle database link does is well documented.
The answer provided, as I understand it, does not do the same thing. So
while it may have answered the OP's question ... it did not address the
subject which is an equivalence to another product's functionality.
But lets not belabour the point ... I think there is room here for
everyone to feel like the communications have been less than clear.
--
Daniel A. Morgan
Here is the post I responded to from WantedToBeDBA, who is NOT the creator
of this thread (OP), so he did NOT make up the thread title which mentioned
Oracle DB Links:
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..
----------------------------------------------------------------------------
--------
Based on the above, and based on the fact that WantedToBeDBA did not create
this thread, I believe I answered the question exactly as it was asked.
I am still not absolutely convinced that WantedToBeDBA needs DB2 Federated
support, but it is hard to know based on the information provided. Unless he
needs to include tables from databases on each machine in the same SQL
statement, he probably doesn't need Federated and could suffice with the
instructions I gave him.
So, yes Daniel, your confusion of the OP by Nick Palmer with the post by
WantedToBeDBA that I answered, does display your ignorance of exactly what
happened.
|
What do you take "Can you guys help me establishing db link between
these 2 system." to actually mean ? |
|
| 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
