|
|
|
|
|
|
| Author |
Message |
Mark Townsend
*nix forums Guru Wannabe
Joined: 02 Apr 2005
Posts: 213
|
 Posted: Sun Feb 13, 2005 6:26 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Larry wrote:
| Quote: |
And for the 300GB TPC-H?
|
Larry - Are these questions purely rhetorical or do you really not know ?
By eyeball and quick back of the envelope calculation, the best 300Gb
DB2 result has about 19K of scripts in the appendices, the closest 300Gb
Oracle result has about 11K.
| Quote: | Not the point, Mark. If you're more than happy to get into that
discussion, then you should have demonstrated that when you made your
first posts instead of just inserting your editorial comments.
|
I think my first editorial comment was "Seems a little overkill for a
simple DB2 to DB2 link (why do I need a wrapper and a server definition
- won't the nickname suffice ? That's effectively all that is required
in Oracle)." at which stage I would have hoped that a "It's for
performance reasons, dummy" conversation could have started. I mean, I
did ask, right ?
So let me ask again. What value does defining the wrapper and server
have when the target is a known entity ? You know the protocal, you know
the version, you know the dialect and data type support, and you know
the optimizer capabilities of the target. Why externalise these ? Is it,
as I summised, that the greater case (access to unknown entities) has
subsumed the simple case (which, BTW, is a perfectly valid approach), or
is there indeed some performance/ease of use/adherence to CS best
practices value that I am missing ?
Cmon. Throw me a bone. Teach an old product manager a few new tricks. I
love to beat up on our developers and tell them how things _should_ be done. |
|
| Back to top |
|
 |
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Thu Feb 17, 2005 3:31 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Serge Rielau wrote:
| Quote: | Mark Townsend wrote:
Serge Rielau wrote:
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?
They show too much detail, in that they show how to sent up a
connection between different vendors databases. The corollorary in
Oracle would be setting up a Transparent Gateway. I'm assuming that
it's a simpler to set up the equivalent of an Oracle to Oracle
database link between two DB2 instances ?
Here is how I set up local DB2 -> DB2 testing when I need it:
catalog local node local instance regress;
commit;
create wrapper DRDA;
commit;
create server loop type DB2/CS VERSION 8.0 WRAPPER DRDA
AUTHORIZATION "xxxxx" PASSWORD "yyyyy"
options (Node 'LOCAL',DBNAME 'GLOBALDB');
create user mapping for zzzzzz
server loop
options (Remote_authid 'xxxx',
Remote_password 'yyyyy');
-- done.. from now on it's about declaring the tables one wants to see.
create nickname nickname1 for loop.blahschema.blahtable;
To use a remote node here is the syntax diagram (from Command reference
manual):
-CATALOG--+-------+--TCPIP NODE-- nodename ---------------------
'-ADMIN-'
(1)
--REMOTE--+- hostname ---+---------SERVER-- service-name ----------
'- IP address -'
--+----------------+--+--------------------------------+-------
'-SECURITY SOCKS-' '-REMOTE_INSTANCE-- instance-name -'
--+---------------------+--+-------------------------------+---
'-SYSTEM-- system-name -' '-OSTYPE-- operating-system-type -'
--+------------------------+----------------------------------
'-WITH-- "comment-string" -'
|
Thanks.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Pablo Sanchez
*nix forums beginner
Joined: 28 Jun 2005
Posts: 29
|
| Posted: Thu Feb 17, 2005 8:30 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Serge Rielau <srielau@ca.ibm.com> wrote in
news:3758ttF588kbaU1@individual.net:
Hey Serge (and all),
FWIW, individual.net is becoming a pay-for site. They've been free
for such a long time, I'm amazed they've lasted this long.
Regards,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com |
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Thu Feb 17, 2005 9:07 pm Post subject:
Re: Equivilant of Oracle's DB Links in DB2
|
|
|
Pablo Sanchez wrote:
| Quote: | Serge Rielau <srielau@ca.ibm.com> wrote in
news:3758ttF588kbaU1@individual.net:
If there are any issues with usenet.. I recommend
www.individual.net
Hey Serge (and all),
FWIW, individual.net is becoming a pay-for site. They've been free
for such a long time, I'm amazed they've lasted this long.
Regards,
Yup, got the email a couple of days ago and decided to cough up the |
money. A reliable newsserver is worth 10Euro/year.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 3:21 am | All times are GMT
|
|
Bad Credit Loan | Bankruptcy | Mobile Phone | Debt Consolidation | Credit Cards
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
