joining across remote locations

william giannelli

joining across remote locations

is it possible to join 2 tables in 2 different locations? (different subsystems)

thanks

Bill

Philip Sevetson

joining across remote locations
(in response to william giannelli)
“Distributed Request” is what you’re asking about. It’s not supported as of at least DB2-z/OS-V11.

From: william giannelli [mailto:[login to unmask email]
Sent: Wednesday, May 01, 2019 12:06 PM
To: [login to unmask email]
Subject: [DB2-L] - joining across remote locations


is it possible to join 2 tables in 2 different locations? (different subsystems)

thanks

Bill

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Kenny Fogarty

joining across remote locations
(in response to Philip Sevetson)
its possible with data virtualisation tools, but not natively with db2 itself.
Cheers,

Kenny

On Wed, 1 May 2019 at 17:49, Sevetson, Phil <[login to unmask email]> wrote:
>
> “Distributed Request” is what you’re asking about. It’s not supported as of at least DB2-z/OS-V11.
>
>
>
> From: william giannelli [mailto:[login to unmask email]
> Sent: Wednesday, May 01, 2019 12:06 PM
> To: [login to unmask email]
> Subject: [DB2-L] - joining across remote locations
>
>
>
> is it possible to join 2 tables in 2 different locations? (different subsystems)
>
> thanks
>
> Bill
>
>
>
> -----End Original Message-----
> **This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
> -----End Original Message-----

Michael Hannan

RE: joining across remote locations
(in response to william giannelli)

There once was a Product called Data Joiner. I guess its not around any more. Have not heard anything about it in recent years.

I would suggest look at ways to maintain a copy of tables at another location (from the base location), so that can do local joins with all normal access paths. e.g. maintain a copy of a smaller table in location of the large table. Or keep a copy the table that is most stable with least changes, to reduce Sync Overheads. Maintain a copy using special products that read the Log, or use triggers, Stored Procs, etc.

Application can select required rows from a remote table, Insert row by row into local or Declared temp table, with any indexes needed, then join to the local table, or do the join manually to look up rows matched to each remote row retrieved. Expensive though unless very few remote rows.

Cross Loader product can move table extracts if a lot of rows to do in one hit. May not be relevant.

In Reply to william giannelli:

is it possible to join 2 tables in 2 different locations? (different subsystems)

thanks

Bill


Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Edited By:
Michael Hannan[Organization Members] @ May 07, 2019 - 10:11 AM (Europe/Berlin)

Philip Nelson

joining across remote locations
(in response to Michael Hannan)
InfoSphere Federation Server is the newer product, with much greater
functionality than Data Joiner.

I'm not sure about the z/OS functionality, but this functionality has been
rolled into the DB2 for LUW product at V11.1 level (I think at V11.1.2.2).

I'll be giving a session at IDUG North America D.V. on using this as a
"Data Integration Gateway" to both IBM and non-IBM data souces.

And you can expect to hear a lot more about federation in this space in the
near future (maybe as early as Charlotte).

Phil

On Tue, 7 May 2019 at 09:04, Michael Hannan <[login to unmask email]> wrote:

> There once was a Product called Data Joiner. I guess its not around any
> more. have not heard anything about it in recent years.
>
> I would suggest look at ways to maintain a copy of tables at another
> location (from the base location), so that can do local joins with all
> normal access paths. e.g. maintain a copy of a smaller table in location of
> the large table. Or keep a copy the table that is most stable with least
> changes, to reduce Sync Overheads.
>
>
>
> In Reply to william giannelli:
>
> is it possible to join 2 tables in 2 different locations? (different
> subsystems)
>
> thanks
>
> Bill
>
>
>
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
>
> -----End Original Message-----
>

J&#248;rn Thyssen

[AD] RE: joining across remote locations
(in response to william giannelli)

Hi Bill,

IBM Data Virtualization Manager allows you to join across data sources: Db2 and non-Db2 - both on and off-platform. It runs on z/OS and will integrate into Db2. 


In Reply to william giannelli:

is it possible to join 2 tables in 2 different locations? (different subsystems)

thanks

Bill



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

Anguraj Rathinasamy

[AD] joining across remote locations
(in response to Jørn Thyssen)
Federation Server supports join 2 tables in two different location, but not efficient as same subsystem join. Thanks

Anguraj Rathinasamy.

> On May 8, 2019, at 2:52 AM, Jørn Thyssen <[login to unmask email]> wrote:
>
> Hi Bill,
>
> IBM Data Virtualization Manager allows you to join across data sources: Db2 and non-Db2 - both on and off-platform. It runs on z/OS and will integrate into Db2.
>
>
> In Reply to william giannelli:
>
> is it possible to join 2 tables in 2 different locations? (different subsystems)
>
> thanks
>
> Bill
>
>
>
>
>
>
> Best regards,
>
> Jørn Thyssen
>
> Rocket Software
> 77 Fourth Avenue • Waltham, MA • 02451 • USA
> E: [login to unmask email] • W: www.rocketsoftware.com
>
> 2019 IBM Champion.
>
> Views are personal.
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>