Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Establish a dblink between two subsystems of Db2

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

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Tue Nov 04, 2008 1:08 pm    Post subject: Establish a dblink between two subsystems of Db2
Reply with quote

Hi,

Is it possible to establish a dblink between two subsystems of Db2. I have two subsytems named as test and prod. Is it possible to get the prod data in test. if so can you please let me know the steps. I heard Federated databases concept in Db2 on LUW but i dont know weather it is possible in Db2 on Zos. Please suggest me.

Thanks,
Nagesh.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Tue Nov 04, 2008 1:22 pm    Post subject: Reply to: Db2 on Zos Db link
Reply with quote

inter DB2 connection ( remote database concept ) has been there for a long time

DB2 DOES NOT CARE about naming and contents of networked DB2 instances

the logic is simply connect, make known to each other
DB2_SUBSYSTEM_ONE and .... DB2_SUBSYSTEM_TWO
production,testing, any use You make of it is no DB2 Concern

but.... connecting PROD and TEST... brrrrr
is against all good judgment and sound environment isolation practices
( think simply about all the permission issues )

every organization has already for a long time defined procedures to clone environments
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Tue Nov 04, 2008 1:31 pm    Post subject:
Reply with quote

Hi,
Can you please let me know the steps to do to make them known to each other. Can you please let me know if we can access the database in different Lpars from one LPar. if it is so can you please let me know the steps to do that.

Thank you very much for the information.


Thanks,
Nagesh.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Tue Nov 04, 2008 1:44 pm    Post subject: Reply to: Db2 on Zos Db link
Reply with quote

did you care to read my advice

everything is explained in the manuals
why should I( or anybody else ) waste time in rewriting them for You

You asked for advice and I gave it to You..
can be done YES
is it a good practice to do it for PROD/TEST NO

why would You expect me to provide advice on doing something wrong
if Your organization wants to do it...
go ahead but You will be very alone when facing troubles !
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Tue Nov 04, 2008 1:53 pm    Post subject: Reply to: Db2 on Zos Db link
Reply with quote

I just asked the question for learning pupose. We are not doing such kind of things. This is for your information.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Tue Nov 04, 2008 2:06 pm    Post subject: Reply to: Db2 on Zos Db link
Reply with quote

then You should learn to pose questions in the right way icon_smile.gif
do not go into the specific with names!
my habit is to always answer looking at organization and practices first, and technical details last
that's why the flame about sharing PROD and TEST
( I had a custmore who had done it , undoing it took much longer than doing it )

here is a link to the db2 installation manual
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNIGK13/CCONTENTS?SHELF=DSNSHKA2&DN=GC18-9846-03&DT=20080206045703

as far as LPAR are concerned the location of the DB2 susbsystems
is irrelevant as long as there is a TCP/IP connection available

in the latest db2 release everything is done thru the
DB2 customization ISPF dialogs
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Tue Nov 04, 2008 2:09 pm    Post subject:
Reply with quote

Thank you very much for your information.
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Mon Nov 10, 2008 3:10 pm    Post subject:
Reply with quote

hi I need more information on this....

is it possible to connect to the other subsystem through an application program, if so how do we avoid the problem with same table names in current system and remote subsystem.....

do we create a dblink and use it as a qualifier in application coding

I have gone through this link
http://www-128.ibm.com/developerworks/db2/library/techarticle/0310chong/0310chong.html

here its clearly shown that we can have multiple links but its not showing how do we use this link in application program
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Mon Nov 10, 2008 5:54 pm    Post subject: Reply to: Db2 on Zos Db link
Reply with quote

Code:
hi I need more information on this....


&DEITY bestow &his &blessings on people who try to help themselves

I played the fool and behaved as if I knew nothing... googled for
"DRDA programming" ( Distributed Relational Databes Access )

and everything was there,
how to bind, how to write the queries, everything ....

anyway the db2 manuals would be a better source of info
developerworks is a bit on the cryptic side sometimes

also
do You really think that posting after 2 and half hours the same query
might give You more answers

edited to add the link to the db2 bookshelf
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DSNSHKA2

and search for, for example, drda bind
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Mon Nov 10, 2008 6:13 pm    Post subject:
Reply with quote

thanks for the info...

I was a bit anxious as I have a dead line and sorry for multiple posts.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Nov 10, 2008 10:31 pm    Post subject: Reply to: Establish a dblink between two subsystems of Db2
Reply with quote

Quote:
I was a bit anxious as I have a dead line and sorry for multiple posts.
Tough organization.

Short deadlines on learning activities. . . icon_confused.gif
Quote:
I just asked the question for learning pupose. We are not doing such kind of things.


d
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 Can a COBOL program access two tables... dejunzhu DB2 7 Tue Oct 30, 2012 6:32 am
No new posts Establish DTB for a CICS transaction f8ful CICS 1 Thu Jan 27, 2011 7:42 pm
No new posts Compare structures in two Subsystems guptae DB2 5 Tue Feb 02, 2010 2:42 pm
No new posts Regarding Pipe Allocation to Establis... harsh singh CICS 4 Tue Nov 10, 2009 7:25 pm
No new posts How to establish MQ REXX INTERFACE priyadarshini03 All Other Mainframe Topics 1 Wed Jun 17, 2009 4:22 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us