MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Remote Aliases in DB2 LUW

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
schintala
Beginner


Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
PostPosted: Wed Jan 04, 2012 4:20 pm    Post subject: Remote Aliases in DB2 LUW Reply with quote
Hi,
We have DB2 databases listed on z/OS. We want to work with aliases in DB2 LUW, but physical databases resides on z/OS. Can we create alias to those in LUW DB2? Please advise. Does it work?

Thank you.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
PostPosted: Wed Jan 04, 2012 4:49 pm    Post subject: Reply with quote
schintala,

As long as you have communication between LUW and DB2 on z/OS it is pretty much straight forward

On LUW DB2 use this to create the alias (Untested)
Code:

CREATE ALIAS alias_name FOR z/os_location_name.tablespace.tablename


Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
GuyC
Supermod


Joined: 27 May 2011
Posts: 35
Topics: 0
PostPosted: Thu Jan 05, 2012 11:42 am    Post subject: Reply with quote
I don't think so.

What you are looking for are federated objects and to set that up , you need to
Quote:
1. Set up the dbm cfg federated yes
2. catalog the node and database to which u want to connect
3. created wrapper (as applicable like for db2..DRDA)
4. create server definition.
5. create nickname.
6. create user mapping
7. give required permission.

Pretty old , but still interesting
http://www.redbooks.ibm.com/redbooks/pdfs/sg247052.pdf
chapter 4.3
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group