MVSFORUMS.com

haqshaik · Beginner Joined: 11 May 2005 Posts: 49 Topics: 19

Hello Gururs,

Is there a possibility of connecting to Oracle on solris Box from Main frame?. The host language would be COBOL and these programs has to do typical database extracts. I think there is a possiblity of connecting to Oracle from Mainframe. I am not sure. could you please let me know what are the drivers that needs to be required and how the connection works out?

Your help will be gretly appriciated..

Thaks,
Salauddin

kolusu · Posted: Tue Jun 28, 2005 2:14 pm Post subject:

haqshaik,

Check this link which might be helpful

http://www.orafaq.com/faqmvs.htm

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

haqshaik · Beginner Joined: 11 May 2005 Posts: 49 Topics: 19

Kolusu,
Thanks for your quick reply. This link was very helpful. I did not get a clear answer for this, But it seems there are ways by which this can be achieved.

Thanks,
Salauddin

haqshaik · Beginner Joined: 11 May 2005 Posts: 49 Topics: 19

Hi
To access oracle in UNIX box, from Main frame the, we need to install Oracle for OS/390 Client and its components are:

-Oracle Access Manager (chose between 'for CICS' or 'for IMS')

-Net8

-Oracle Precompilers

-Oracle Call Interface

-SQLLoader

-SQLPlus

Of the above components the most important is the NET8, which manages the connections to the Oracle database on Solaris. The supported protocols are TCP/IP and APPC/LU6.2. This product has got inbuilt features to convert the data as well. The data can be accessed through the SQL calls. NET8 runs on the mainframe in a separate address space and the dedicated address space is called TNS (Transparent Network Subtrate). Its similar to the DB2 master batch Job running its own address space, manages connections and accessing data from DB2 tables. This product can be configured to access more than one oracle Instance. Oracle access manager is required if we are using any online transaction manager like CICS or IMS.

Just want to share with you all.

Kolusu, the link you have provided is vey good and once again thanks for the same.

Thanks,
Salauddin

kolusu · Posted: Thu Jun 30, 2005 10:26 am Post subject:

haqshaik,

Thanks for the feedback !

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu