Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Federated Database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Nimesh.Srivastava

New User


Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE

PostPosted: Thu Feb 14, 2008 9:14 am    Post subject: DB2 Federated Database
Reply with quote

Hi All,
I have two queries
in order to access a z/OS DB2 table from DB2 UDB on a UNIX server using nicknames; do I require any other software besides
1. DB2 Connect
2. DB2 UDB which is installed on UNIX server
3. DB2 z/OS which is installed on mainframe

this allows me to access my remote mainframe tables like
select r_a,r_b from mf_schema.A,unix_schema.B
where r_a > 100 and r_b < 1000
with ur;
Would I mandatorily require tools like DB2 Relational Connect for achieving this.

Also, my next query is how is the DB connection to z/OS & unix maintained in tha query like this. User id and password entered during user mapping is used only once and the connection to z/OS is maintained until specifically disconnected.
or its connected and disconnected every time I access mainframe DB2 via the nickname created on UNIX.
Thanks in advance
Nimesh
Back to top
View user's profile Send private message

dr_te_z

New User


Joined: 08 Jun 2007
Posts: 71
Location: Zoetermeer, the Netherlands

PostPosted: Thu Feb 14, 2008 12:40 pm    Post subject:
Reply with quote

You'll need this http://www.amazon.com/Understanding-DB2-Learning-Visually-Examples/dp/0131859161
Back to top
View user's profile Send private message
Nimesh.Srivastava

New User


Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE

PostPosted: Tue Feb 19, 2008 10:43 am    Post subject:
Reply with quote

Hi dr_te_z,
Thanks for the reply but are you sure this book would contain what I am looking for ?
I dont want to buy and then find its not what I was looking for.
Regards,
Nimesh
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Tue Feb 19, 2008 2:35 pm    Post subject: Reply to: DB2 Federated Database
Reply with quote

what about searching the IBM redbooks,
they usually give very good insight on the general architecture of things
http://www.redbooks.ibm.com/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us