| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSeries perfomance queury |
« View previous topic :: View next topic » |
| Author |
Message
|
| vinodh_niit |
 Posted: Fri Aug 23, 2002 3:09 am Post subject: MQSeries perfomance queury |
 |
|
Apprentice
Joined: 22 May 2002
Posts: 36
Location: chennai
|
Hi All,
We had client-server architecture that was using APPC for communicate between the NT client and the OS/390 server.
Recently we moved to MQseries and we find that the reponse time has increased. With the omegamon report on DB2 we found that that DB2 threads and DB2 commits, the i/o waits, service waits have increased.What could be the possible problems? Would it be related to MQSeries and if so what needs to be tuned for a better performance and a faster reponse time.
Further details on the architecture can be provided. But we need to confirm if MQSeries can be a cause for such increased DB2 threads and slow response times.
Rgds
Vinodh
_________________
vinodh
ssg-mq ream |
|
| Back to top |
|
 |
| bduncan |
| Posted: Fri Aug 23, 2002 8:54 am Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
I'm assuming you are using syncpoint, so how many messages are processed between commits? Also, does each message represent a single SQL query, or do you pack multiple queries into a single message?
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| Back to top |
|
|
| vinodh_niit |
| Posted: Sun Aug 25, 2002 8:29 pm Post subject: MQSeries perfomance queury |
|
|
Apprentice
Joined: 22 May 2002
Posts: 36
Location: chennai
|
Hi
Thanks for your reply.
We have asked the application team to check on this (We are from the system side). To understand the impact of what you have suggested, can you tell us what would be effect on perfomance if we have multiple sql queries packed in a single message rather that each message representing a single query.
We are aware that processing many messages between commits has impact on perfomance.
Can you give us further inputs on this perfomance issue.
Sorry, If we ask you basic questions as we are relatively inexpereinced and we are on the learning phase.
Rgds
Vinodh
_________________
vinodh
ssg-mq ream |
|
| Back to top |
|
|
| vinodh_niit |
| Posted: Sun Aug 25, 2002 9:21 pm Post subject: MQSeries perfomance queury |
|
|
Apprentice
Joined: 22 May 2002
Posts: 36
Location: chennai
|
Hi Brandon
I would like to give you further inputs on the archeitecture so that you can help us.
The product is a db2 based system and is capable of running under IMS/DC or CICS transaction processing environments on IBM 3090. Earlier the product used APPC/LU6.2 communication protocol for communication with mainframe. Due to some limitation we moved to tcp/ip and implement MQSeries as another communication protocol for the product's client server model.
The client is on win/95. The server is os/390. Client to server communication happens through MQSeries installed on win/NT server.
The flow happens to following way:
Request flow:
CLIENT -> MQPUT REQUEST -> XMIT QUEUE -> REMOTE REQUEST QUEUE -> INIT QUEUE -> MQ PROCESS
Reply flow:
MQ PROCESS -> CICS TXN -> MQGET REQUEST -> SERVER PROCESSING -> MQPUT REPLY
When a Request is put in the Request Queue (Remote,TriggerType=Every) by the Client, a CICS transaction is invoked.
This CICS transaction executes the COBOL/CICS program1 which transfers control to the presentation layer program2. The purpose of the program1 is to assign a unique value of ‘2’ to EIBCALEN so that the router program2 can identify the type of communication protocol used.
The request is obtained from the Request Queue via a MQGET call. The name of the Dynamic Reply Queue and the Q manager of the client are obtained from the Request message.
The Request is processed and the formatted output(which are BMS maps of the online screen) is sent via a MQPUT call to the Dynamic Reply Queue.
The client does a MQGET to retrieve the formatted o/p and throws it on the screen.
Hope I have given the clear picture of the setup?
Request you to plz help us with your suggestions.
Thanks in advance
Rgds
Vinodh
_________________
vinodh
ssg-mq ream |
|
| 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
|
|
|
|
