Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Performance of MQueue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Mon Sep 23, 2013 8:39 pm    Post subject: Performance of MQueue
Reply with quote

Hi,
I have a requirement where I have to access the cloud database thru mainframe. So to do that we planned to use MQueue series.
It took around 5 min to process 100 records to send the request to MQ and receive the response in the response queue. We process 1 record at a time meaning ( open all the connection /queue in the beginning and then we send the 1 rec of primary key to the MQueue then we receive the rec corresponding to that primary key in the response queue and do the same process for 2nd record till 100th record in the end close all the MQ connection) is there an optimistic way to reduce the time.
Or is there any way to unload the entire cloud database and populate in the MQ or you have any other suggestions
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 23, 2013 9:32 pm    Post subject:
Reply with quote

Hello,

How was it determined that this must take place in the cloud? Would distributed data not fill the need?

If you explain what is being done from a business perspective, someone may have a suggestion.

So far, i have not seen any reports of statistics gathered when accessing a "cloud" from a mainframe. I do not know what to expect, but 5 min for 100 records seems Really slow . . .
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Mon Sep 23, 2013 11:07 pm    Post subject: Reply to: Performance of MQueue
Reply with quote

We got a new requirement to generate message for new client and currently all the data’s are available in cloud. From mainframe we have no idea how to connect thru cloud so we decided to use MQ to do request and response from cloud database. No people from here have any idea how to interact cloud thru mainframe?
My client doesn’t want to clone the cloud database to DB2 as the cloud database is used by many applications currently. So we have to use the cloud database only for sure. Now we are trying to do performance process either to unload the cloud table and copy to a temp table or to process directly thru MQ.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Sep 24, 2013 5:10 pm    Post subject:
Reply with quote

well,
other than the obvious
- your company pay for some training of the people that is the basis of the billing of your customer..............

you mentioned mqs, but i don't think that you are connecting directly to cloud with that.

cloud is accessable thru internet
(more accurately, cloud is based on servers)
which means you are using mqs to communicate between the mainframe
and some server based something that deals directly with cloud.

i would stop trying to find fault with mqs
mqs is really quick
and unless the task priorities on the mainframe and your server are being set by neanderthals,
your hold-up is not mqs.

maybe the data that you are transfering is just too big.
try smaller packets until you learn and understand what needs to be done.

you provided very little info.

what kind of response do the applications that currently access the cloud db have?

also, you have to generate a message on the mainframe, triggered by something,
why not have that something also include the info from cloud that is necessary.

i realize that would require a complete revamp of the process,
but all you company did was spit in the wind
and now it is smacking you in the face.

designing something without understanding your db is asking for trouble.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts CONTIG for performance? JPVRoff JCL & VSAM 8 Fri Jun 09, 2017 8:39 am
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts DISP=(SHR,PASS) performance opinion steve-myers JCL & VSAM 1 Wed Dec 02, 2015 11:53 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us