AIX

Hi,
I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side.

Question: (may be dumb to you)
1. Has anybody done this and would like to share their documents, lessons learnt, risks etc?
2. Where can I find the ODBC.ini for DB2 Mainframe?
3. Should I install this ODBC Driver on Mainframe or Oracle AIX?
4. Anything else that needs to be taken care.

Thanks to everyone in advance.

Regards,
Mani

IBM has a classic federation drivers I got them from the MF guys, a second place to look is datadirect they make odbc drivers for about everything

There's an odbc.ini file which need to be configured. It might be found in your webserver./ also where your oracle client is located.

In your case I'm assuming you install the oracle client inside the mainframe. And the oracle server is where you have your oracle 10G installed.

Code:

/opt/productABC/apache/docs/infospc/odbc/odbc.ini

vi this odbc.ini and modify the (just an example)

Code:

Driver = example /opt/productABC/apache/docs/infospc/odbc/lib/driverABC
decription = DB2 wire protocol
LogonID = repository_two <-is by default for oracle clients
Password-repository_two
SID = ORAXYZ <-depends on your repository name

and from my experience odbc file needs to be configured only for RHEL machine not aix. you guys can correct me if im wrong.

cheers

What exactly do you need to do? Are you trying to federate a query between Oracle and DB2 on z/OS. What are the database clients in the scenario?