| View previous topic :: View next topic |
| Author |
Message |
sheelu
Beginner
Joined: 07 Apr 2014
Posts: 26
Topics: 6
|
 Posted: Mon Sep 08, 2014 12:27 am Post subject: Cobol-DB2 application accessing remote RDBMS |
 |
|
Hi
I wanted to know if it is possible for existing cobol-DB2 applications in z/os to access remote RDBMS (non-DB2) on the occasion of database migration.I read about how DRDA protocol can be used to connect DB2 z/os to remote DB2 but did not get any information on whether DB2 z/os can connect to any other remote RDBMS apart from DB2 using DRDA.
Can you please suggest some options to achieve this? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
sheelu
Beginner
Joined: 07 Apr 2014
Posts: 26
Topics: 6
|
| Posted: Tue Sep 09, 2014 2:52 am Post subject: |
|
|
Thanks a lot Kolusu..
Actually I wanted to know if there are any non-product based solutions like DRDA.But I am not sure about its implementation in the current scenario.  |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Sep 09, 2014 12:24 pm Post subject: |
|
|
| sheelu wrote: | Thanks a lot Kolusu..
Actually I wanted to know if there are any non-product based solutions like DRDA.But I am not sure about its implementation in the current scenario. |
Is this a real requirement or you just interested ? Oracle has a gateway interface that can connect to DB2
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
sheelu
Beginner
Joined: 07 Apr 2014
Posts: 26
Topics: 6
|
| Posted: Tue Sep 23, 2014 6:56 am Post subject: |
|
|
Thanks kolusu
I am looking for options to connect existing cobol applications on z/OS to any other remote RDBMS other than DB2.
I read about three part name approach using DRDA concept.But I also came across this condition that three part name (DRDA approach) can be used only for DRDA compliant RDBMS. I could not find out the list of DRDA compliant RDBMS other than DB2 ,Informix etc.
Is there any other RDBMS that is DRDA compliant? |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Sep 23, 2014 10:48 am Post subject: |
|
|
| sheelu wrote: | I could not find out the list of DRDA compliant RDBMS other than DB2 ,Informix etc.
Is there any other RDBMS that is DRDA compliant? |
Sheelu,
If you had read my earlier response about Oracle you would have got the answer by now.
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
sheelu
Beginner
Joined: 07 Apr 2014
Posts: 26
Topics: 6
|
| Posted: Wed Sep 24, 2014 4:35 am Post subject: |
|
|
Thanks kolusu
I did go through the link provided by you.Actually I wanted to know if it is possible to connect batch programs running on z/OS to remote non-DRDA RDBMS (MYSQL, ORACLE ) without any product like federation server.
I read that it is possible to connect to remote DB2 without federation server ,but I am not sure about the other RDBMSes.
I am also looking for the list of DRDA compliant RDBMSes other than DB2. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Wed Sep 24, 2014 10:41 am Post subject: |
|
|
| sheelu wrote: | Thanks kolusu
I did go through the link provided by you.Actually I wanted to know if it is possible to connect batch programs running on z/OS to remote non-DRDA RDBMS (MYSQL, ORACLE ) without any product like federation server.
I am also looking for the list of DRDA compliant RDBMSes other than DB2. |
Sheelu,
Do you even read the responses? This is the second time that I had to point to the earlier post in this very topic.
*Sigh* I guess I have to spoon feed you.
http://lmgtfy.com/?q=Oracle+has+a+gateway+interface+that+can+connect+to+DB2
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
sheelu
Beginner
Joined: 07 Apr 2014
Posts: 26
Topics: 6
|
| Posted: Wed Sep 24, 2014 10:22 pm Post subject: |
|
|
Thanks kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
