Equivilant of Oracle's DB Links in DB2

[Mark Townsend]

Re: Equivilant of Oracle's DB Links in DB2

Larry wrote:
[color=blue]
>
> And for the 300GB TPC-H?
>[/color]

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.
[color=blue]
> 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.[/color]

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.

[DA Morgan]

Re: Equivilant of Oracle's DB Links in DB2

Serge Rielau wrote:[color=blue]
> Mark Townsend wrote:
>[color=green]
>> Serge Rielau wrote:
>>[color=darkred]
>>> 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?[/color]
>>
>>
>>
>> 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 ?
>>[/color]
>
> 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):[color=green][color=darkred]
> >>-CATALOG--+-------+--TCPIP NODE-- nodename --------------------->[/color][/color]
> '-ADMIN-'
>
> (1)[color=green]
> >--REMOTE--+- hostname ---+---------SERVER-- service-name ---------->[/color]
> '- IP address -'
>[color=green]
> >--+----------------+--+--------------------------------+------->[/color]
> '-SECURITY SOCKS-' '-REMOTE_INSTANCE-- instance-name -'
>[color=green]
> >--+---------------------+--+-------------------------------+--->[/color]
> '-SYSTEM-- system-name -' '-OSTYPE-- operating-system-type -'
>[color=green]
> >--+------------------------+----------------------------------><[/color]
> '-WITH-- "comment-string" -'
>[/color]

Thanks.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu
(replace 'x' with 'u' to respond)

[Pablo Sanchez]

Re: Equivilant of Oracle's DB Links in DB2

Serge Rielau <srielau@ca.ibm .com> wrote in
news:3758ttF588 kbaU1@individua l.net:
[color=blue]
> If there are any issues with usenet.. I recommend
> www.individual.net[/color]

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

[Serge Rielau]

Re: Equivilant of Oracle's DB Links in DB2

Pablo Sanchez wrote:[color=blue]
> Serge Rielau <srielau@ca.ibm .com> wrote in
> news:3758ttF588 kbaU1@individua l.net:
>
>[color=green]
>>If there are any issues with usenet.. I recommend
>>www.individual.net[/color]
>
>
> 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,[/color]
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