| MQ-JDBC connections, |
|
|
| Total Votes : 0 |
|
| Author |
Message
|
| mvarghese |
 Posted: Fri Dec 08, 2006 12:14 am Post subject: MQ-JDBC connectors |
 |
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
I never done MQ-JDBC connections, i am not able to get right document from net.How to implement it ?all docs i seen is J2ee-Jdbc stuffs.
Can any one send me..necessary docs regarding
1.How to implement MQ-JDBC connections?
My requirment is to get messages from Queue to Db2 database using JDBC.
I need first to do in Windows, then in Unix.
thanks in advance.
_________________
Jain Varghese |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Dec 08, 2006 12:24 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
a) Write a Java application that reads a queue (possibly using the native interface if you're not in a J2EE environment) and writes to a database using DB2 JDBC
b) Buy MWB & write a flow MQInput -> Database
Documentation in abundance available on the IBM site.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mvarghese |
| Posted: Tue Dec 12, 2006 8:05 pm Post subject: Jdbc Adapters |
|
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Hi,
Its presently running using message flow, i mean message from Queue will write to db2 using ESQl in compute node.
But i seen so much CPU usage and performance problem here.
So i am thinking of implementing JDBC connectors to read messages from Q and put in Db2.
So questions are, Is its a good solution?
Is JDBC connector is free of cost?Present set up only WMB 6.0 adn DB2 with MQ 6.0.
Number of messages going to database per day is around 100k+.
Any good solution for this case?
_________________
Jain Varghese |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Dec 13, 2006 12:01 am Post subject: Re: Jdbc Adapters |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mvarghese wrote: |
Hi,
Its presently running using message flow, i mean message from Queue will write to db2 using ESQl in compute node.
But i seen so much CPU usage and performance problem here. |
Define "performance problem" - what figures are you getting? What tuning activities have you already tried (so we don't go over covered ground)? Both for the flow and for the DB2?
| mvarghese wrote: |
Is JDBC connector is free of cost?Present set up only WMB 6.0 adn DB2 with MQ 6.0. |
I believe IBM supply a free JDBC connector with the product, but it's been a while. Google is your friend here I think. Also I don't know what features the various JDBCs support.
(And I don't believe any of them will pull a message from a queue and put it into a database without code)
| mvarghese wrote: |
| Number of messages going to database per day is around 100k+. |
Each message 1k or 100Mb?  It certainly doesn't sound like a lot in volume terms.
| mvarghese wrote: |
| Any good solution for this case? |
If I'd got WMB & your requirements I'd use a flow.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Dec 13, 2006 9:04 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
So, what's the poll for? 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Wed Dec 13, 2006 11:30 am Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
| tleichen wrote: |
| So, what's the poll for? |
its to see if you have 2 MQ-JDBC connections or two of them  |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Dec 13, 2006 1:55 pm Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
oh, okay.....
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| mvarghese |
| Posted: Thu Dec 28, 2006 6:32 pm Post subject: |
|
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Hi Vitor,Thanks for ur reply.
1.Message coming to db is a copy of message going to diff message flows...As per customer requirement..its act as a back up in db2.So as per ur question Size will vary from message to message..but all are less than 4 MB:).
2.Can u send me a link where i can get free JDBC adaptors...For my undertanding not to implemnt in Project:) becos as per diff Techies opnion as per present load , message flow itself ok.
3.Why performance issue?.The problem is that specific message flow only taking lots of CPU ..i mean 2-4% additional than all other flows running in PROD machine and also from Broker Staistics also, we are getting some time more than 10 sec to process a single message ie violating the SLA with client.
_________________
Jain Varghese |
|
| Back to top |
|
|
| pathipati |
| Posted: Thu Dec 28, 2006 6:48 pm Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
| Quote: |
| Can u send me a link where i can get free JDBC adaptors... |
I don't think IBM will provide JDBC Adaptor for free.
| Quote: |
| The problem is that specific message flow only taking lots of CPU ..i mean 2-4% additional than all other flows running in PROD |
If you have performance issue with Specific Message flow then try to find the cause of issue. Like is it because of your flow or request message? |
|
| Back to top |
|
|
|
|
