| Author |
Message
|
| dhanaraj |
 Posted: Tue Mar 13, 2007 1:01 pm Post subject: MQ-CICS Design |
 |
|
Voyager
Joined: 10 Aug 2004
Posts: 92
|
Hi
I am not familiar with Mainframe data base. We are struct in the middle of the architecure design.
We are planning request and response messages of j2ee application(WAS) through the(MQJMS) Messaging gateway MQ to interact mainframe database. My question how can we interact the MQ to( CICS screen scap )mainframe database. Client don't want to INSTALL any PRODUCTS(MQ,WAS,etc..) on main frame database. Whole application and MQ will run on solaris.
Please answer any seniour member.
Thanks
Anand  |
|
| Back to top |
|
 |
| Michael Dag |
| Posted: Tue Mar 13, 2007 1:41 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
what's the database?
can you make a client (ODBC) connection to it from Solaris.
there is no MQ Client for z/OS (you referred to mainframe database, so I assume you mean z/OS...)
so if the client does not want to install software (MQ/WAS) on the mainframe, you are stuck with some client connection to the database...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Tue Mar 13, 2007 5:03 pm Post subject: Re: MQ-CICS Design |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
| dhanaraj wrote: |
Hi
My question how can we interact the MQ to( CICS screen scap )mainframe database. Client don't want to INSTALL any PRODUCTS(MQ,WAS,etc..) |
If you don't want to install anything new and neither MQ nor CAF are already installed on the mainframe then you are going to be totally out of luck.
If MQ is alreay installed over there then you could use the CICS Bridge to fire off the transaction you require.
Other then that Michael's solution is the only one you stand a chance with. |
|
| Back to top |
|
|
| dhanaraj |
| Posted: Wed Mar 14, 2007 7:33 am Post subject: Thanks both of u guys |
|
|
Voyager
Joined: 10 Aug 2004
Posts: 92
|
I appriciated U guys help. U guys gave me valuable info. Michael solution may work in our environment.
Database is DB2 or Oracle. we don't know that yet. But it will run on Z/OS and OS/390. This is my plan " from MQ i may recommond them using (MQ frame work) MQAPI will get message(request) from MQ and update or inquire to the database using client connections through JDBC or ODBC connnection pool. And retrive the message(respose) from the same way put that message in to the MQ."
Please help me the above recommondation make sense or do i need update on my recommondation. And I got another idea
Can i recommand them MessageBroker(will install on MQ Server) instead of the MQ frame work.
Thanks
Anand |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Mar 14, 2007 7:50 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
and what would be the added value of message broker on the mq server (solaris) to connect via ODBC to the database on the mainframe?
no offense, but I have serious doubts on your understanding of subject matter and I hope your customer is not on this board aswell...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| dhanaraj |
| Posted: Wed Mar 14, 2007 8:55 am Post subject: what would be the added value of message broker on the mq |
|
|
Voyager
Joined: 10 Aug 2004
Posts: 92
|
Yes u r right. My client is not interested on MB.
Q.1. Message Transformation (only one application need transformation)
Q.2. Interact with multiple database.
Ans:
A.1 For Transformation, we are planning Websphere TCP/IP adapter from MQ.
A.2 The one u suggested.
So What r ur recommondations on second answer. Will you agree on this?
or do i need to change any thing
" from MQ i may recommond them using (MQ frame work) MQAPI will get message(request) from MQ and update or inquire to the database using client connections through JDBC or ODBC connnection pool. And retrive the message(respose) from the same way put that message in to the MQ."
Thanks for ur help |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Wed Mar 14, 2007 9:26 am Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
So you are proposing having an application on a distributed, MQ enanbled platform read messages from a queue, then use ODBC to update a remote database on the mainframe, and then issue a reply to a response queue?
If this is the case you need to be careful about database locks on the mainframe, especially if the database is open. |
|
| Back to top |
|
|
| dhanaraj |
| Posted: Wed Mar 14, 2007 10:36 am Post subject: |
|
|
Voyager
Joined: 10 Aug 2004
Posts: 92
|
| Quote: |
| So you are proposing having an application on a distributed, MQ enanbled platform read messages from a queue, then use ODBC to update a remote database on the mainframe, and then issue a reply to a response queue? |
YES
| Quote: |
you need to be careful about database locks on the mainframe, especially if the database is open
|
What kind of probs will encounter when the database is open? What is the sol for those probs?
We are planning to create a session in that session we will open database lock and process all the request corresponding response in that session. If the session expires so user need to resubmit the request again.
any corrections on this plz let me know |
|
| Back to top |
|
|
|
|
