How to create multi-location/global views?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurence - 07 Feb 2007 09:11 GMT

Hi folks,

Who knows how to create multi-location/global views? Could you show me
some examples?

Thanks in advance,

Laurence

Reply to this Message

Knut Stolze - 07 Feb 2007 10:05 GMT

> Who knows how to create multi-location/global views? Could you show me
> some examples?

What are your different "locations"?

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

Laurence - 07 Feb 2007 12:10 GMT

Thanks for the reply.

The view could join information in multiple data sources located on
different systems (across systems), even on different databases in the
same system/machine (across databases).

Have any comments?

Reference: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.admin.doc/doc/t0005016.htm

Reply to this Message

shenanwei@gmail.com - 07 Feb 2007 16:39 GMT

> Thanks for the reply.
>
[quoted text clipped - 5 lines]
>
> Reference:http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/c...

I think you need to ebable federated DB first, then create view on
them.

Reply to this Message

Knut Stolze - 07 Feb 2007 19:15 GMT

> Thanks for the reply.
>
[quoted text clipped - 3 lines]
>
> Have any comments?

Use DB2's federated capabilities, i.e. create wrapper, server, and nickname
objects. A nicknames is a placeholder/pointer/reference to a table in
another database.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message