| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| regarding WebSphere MQ Urgent |
« View previous topic :: View next topic » |
| Author |
Message
|
| kishoreMuthyala |
 Posted: Mon Aug 23, 2004 8:03 pm Post subject: regarding WebSphere MQ Urgent |
 |
|
Apprentice
Joined: 24 Mar 2004
Posts: 35
Location: singapore
|
Hi,
My scenario is like this.iam working on WBIMBv5.0 where i need to get the data from SAP(using SAP Adapter) and pass it to DB2(Remote).When iam executing my scenario iam able to get the data from SAP and it is put in Delivery Queue as specified by my code(this is my first message flow).This Delivery Queue is now the Input Queue for the next message flow where iam sending the data to DB2 database.But here the Problem is after the data is coming to the delivery queue it is taking very long time to process the message and send to database...I dont why it it taking so long time..Can anyone guide me..
regards & thanks
Kishore Muthyala |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Aug 23, 2004 8:52 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Explain what is your second message flow doing and how are you measuring these timings?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| kishoreMuthyala |
| Posted: Mon Aug 23, 2004 9:46 pm Post subject: regarding WebSphere MQ Urgent |
|
|
Apprentice
Joined: 24 Mar 2004
Posts: 35
Location: singapore
|
Hi,
I have created two message flows where in the first message flow interacts with the database through the SAPAdapter and gets the data from SAP and puts into a Delivery Queue.(Note:This Delivery becomes the Input queue for the Second Message flow)
My Second Message flow is to send the data that is in the deliveryqueue to the remote database.
It has one MQInputnode , Compute Node, MQOutputnode.
In the MQInputnode properties iam specifying the Queue i.e DeliveryQueue which contains the message.In the Compute Node Properties iam specifying the DataSource name of the database where the data should go.
The data in the delivery queue passes from the MQInputnode to the ComputeNode and goes to the Database for Insert or Update.
The Problem here is when the message enters the Deliveryqueue it should immediately pass to the Computenode for execution.But it is taking very long time to pass from the MQInputnode delivery queue.
I could not understand weather it is the MQ problem or anyother.The same code has worked in the Development box without problem.The problem iam facing is in the production System.
regards & thanks for the support
kishore Muthyala |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Aug 23, 2004 10:07 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Is that your input messages are consumed slowly by message flow? Are your insert/update going thru or you are getting errors when executing the transactions? Could it be because of the volume of data in the database (primary key etc.) and environment settings? If you think that your DB message flow is slow, you can set multiple instances for that message flow to run faster.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| PGoodhart |
| Posted: Tue Aug 24, 2004 5:19 am Post subject: |
|
|
Master
Joined: 17 Jun 2004
Posts: 278
Location: Harrisburg PA
|
Another thing you may want to consider, is the general health of your database. In my experience, slow downs in DB inserts usually mean that the database is due for a reorginization, or that the indexes are badly set. You may want to also look at your connection between the database and the MQ server. If the database is on another server, you may be dealing with a saturated pipe (too many connections).
_________________
Patrick Goodhart
MQ Admin/Web Developer/Consultant
WebSphere Application Server Admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
