Establish a dblink between two subsystems of Db2

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

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.

enrico-sorichetti · Posted: Tue Nov 04, 2008 1:22 pm

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

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

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.

enrico-sorichetti · Posted: Tue Nov 04, 2008 1:44 pm

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 !

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

I just asked the question for learning pupose. We are not doing such kind of things. This is for your information.

enrico-sorichetti · Posted: Tue Nov 04, 2008 2:06 pm

then You should learn to pose questions in the right way

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
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

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

Thank you very much for your information.

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

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
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

enrico-sorichetti · Posted: Mon Nov 10, 2008 5:54 pm

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

thanks for the info...

I was a bit anxious as I have a dead line and sorry for multiple posts.

dick scherrer · Posted: Mon Nov 10, 2008 10:31 pm