Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

MQ Series Performance

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
callmeavi14

New User


Joined: 18 Jan 2010
Posts: 3
Location: India

PostPosted: Wed Feb 03, 2010 3:22 pm    Post subject: MQ Series Performance
Reply with quote

Hi All,

As per my requirement i have to write some transaction data to DB2 table. As i cant give explicit commit or rollback. I am thinking to write the data to either MQ or Flat file and later using a batch job will upload to the DB2 table.

Can anyone suggest which will be better in case of High Volume Real time data? Approx i will be receiving 3 Million records a day.
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: Wed Feb 03, 2010 8:23 pm    Post subject:
Reply with quote

Hello,

Why the concern about commit/rollback? 3 million INSERTs in a singoe batch process is probably not going to perform acceptably.

Will the received records be in a format that can be directly loaded into the table or do they need to be pre-processed to become loadable?

Can all of the data be loaded at one time or should the data be put into the table as it is received?

How will this data be received?
Back to top
View user's profile Send private message
callmeavi14

New User


Joined: 18 Jan 2010
Posts: 3
Location: India

PostPosted: Wed Feb 03, 2010 9:52 pm    Post subject: Reply to: MQ Series Performance
Reply with quote

Hi,
The 3 million records are not going to come in a single go. Its the total volume expected by end of day. The application which is going to process the records is triggered every 30 secs. i need to update the audit database for successful/unsuccessful processing of each record.

Since the application doesn't have any explicit commit/rollback. So if a transaction is unsuccessful if i directly update the Audit database, it will be rolled back. Hence considering either MQ or flat file to store the info and later on applying to the database.
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: Thu Feb 04, 2010 2:56 am    Post subject:
Reply with quote

Hello,

Does this job run every 30 seconds n batch?

I'm still not clear on where the records "come from". . . How are these presented to the mainframe?
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 -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts Performance tuning of Online system bipinpeter All Other Mainframe Topics 2 Thu Nov 26, 2015 2:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us