| Author |
Message
|
| Rajat |
 Posted: Thu Nov 26, 2009 3:43 am Post subject: connect to mainframe Database from AIX Box using DB2 connect |
 |
|
Novice
Joined: 26 Nov 2009
Posts: 15
|
Is it possible to connect to remote DB2 database , located on mainframe host from MQSIv6.0.1.3 compute node?
I am planning to connect to mainframe Database from AIX Box using DB2 connect via ODBC.
z/OS is running version 1.9 and we are running DB2 UDB for z/OS v8r1
I have few questions
1) How do I establish the connection between Message Broker and DB2 Connect. what kind of configuration is required for odbc.ini file.
2) what kind of configuration are required for DB2 Connect to access Mainframe Database.
I have Database Name,Mainframe sub system Name,DNS Name with me.
Hey Friends I am in urgent need for a solution.
Thanks in Advance |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu Nov 26, 2009 6:07 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
i am not pretty aware about DB2 Connect.
But we usually keep a DB Client and through that we communicates with the DB Servers.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Rajat |
| Posted: Fri Nov 27, 2009 2:59 am Post subject: Hello Friends |
|
|
Novice
Joined: 26 Nov 2009
Posts: 15
|
| Can you please give me some solution.. I am struggling... |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Nov 27, 2009 3:34 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| What do you want to do to the database? Some kind of administration task? |
|
| Back to top |
|
|
| Rajat |
| Posted: Fri Nov 27, 2009 3:41 am Post subject: |
|
|
Novice
Joined: 26 Nov 2009
Posts: 15
|
| I want to access some tables |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Nov 27, 2009 3:50 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
|
| Back to top |
|
|
| Rajat |
| Posted: Fri Nov 27, 2009 4:41 am Post subject: Hi |
|
|
Novice
Joined: 26 Nov 2009
Posts: 15
|
Thnaks for the information..
But why you are saying that I am heading in a wrong direction
MB(AIX)------------>DB2 Connect----------->Mainframe Database
MB(AIX)------------>DB2 Connect( This is the part where I am confused)
How to establish connection between WMB and DB2 Connect via ODBC
Please Help  |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Nov 27, 2009 6:38 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
|
| Back to top |
|
|
|
|
