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
 

 

Accessing Oracle database from Mainframes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vaddi.ajay

New User


Joined: 20 May 2007
Posts: 1
Location: Chennai

PostPosted: Fri May 25, 2007 10:57 am    Post subject: Accessing Oracle database from Mainframes
Reply with quote

We have an oracle database residing on a Unix server (REGPAR). On mainframe, we have a job running every 15 minutes, that needs to get data from the oracle database.

so is it possible to retrieve the data from Unix server on Mainframes. If so, how can this be done?
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: Sat May 26, 2007 4:53 am    Post subject:
Reply with quote

Hello,

One way to get the data from Oracle to the mainframe is to run a process on the unix system that pulls data from Oracle and ftps the results to the mainframe. The mainframe job would process the uploaded data and delete the file after making a copy (unless none was needed).
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Sat May 26, 2007 11:22 am    Post subject: Re: Accessing Oracle database from Mainframes
Reply with quote

Just add one more view , similar to dick's view.

1. We too had the similar requirement. We had the data uploaded to Mainframe Queue and our job will take care of draining the messages from the Queue.

2. In the second scenario as dick suggested, Oracle needs to FTP the file to Mainframes, Once th file is ready, we can have Mainframe trigger job to trigger the mainframe job to run with the existing file.

Hope i made clear to you.

Thanks,
Diwakar

----------------------------------------
Nobody is Perfect. I am Nobody
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Fri Jun 01, 2007 8:50 am    Post subject: Re: Accessing Oracle database from Mainframes
Reply with quote

I, too, would be interested in knowing how or if this can be done. Our shop is setup similar to the way the O/P described.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Accessing first bit of PD value rajatbagga DFSORT/ICETOOL 11 Wed May 03, 2017 6:03 am
No new posts Are there any Freeware utilties for i... johnmull IBM Tools 2 Wed Dec 21, 2016 8:29 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am


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