View previous topic :: View next topic
|
Author |
Message |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3054 Location: NYC,USA
|
|
|
|
Currently, in my project we have EXCI calls which does updations into the MQs and the tansactions gets processed which then updates corresponding table.
What, if the above design can be rewritten completly into Batch ( just a thought) then would that really reduce the execution time also reduce the CPU consupmtion? |
|
Back to top |
|
|
Jose Mateo
Active User
Joined: 29 Oct 2010 Posts: 121 Location: Puerto Rico
|
|
|
|
Good afternoon, Rohit!
If you think this could be done better in batch then why the system is design the way it's working now? Right now the table is updated online in realtime and I think that other online applications use that table for some kind of process. You could do it thru batch by collecting all the transactions in one file and processing the file to update the table in a specific time of day but is that what you want to do? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Nice question.
If you have the money,
i can make the time. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3054 Location: NYC,USA
|
|
|
|
Jose,
Greetings of the day!!
Quote: |
If you think this could be done better in batch then why the system is design the way it's working now? |
I don't know why they did that, its old app.
Quote: |
Right now the table is updated online in realtime and I think that other online applications use that table for some kind of process. You could do it thru batch by collecting all the transactions in one file and processing the file to update the table in a specific time of day but is that what you want to do? |
Yes, right
Thanks
Quote: |
If you have the money,
i can make the time. |
|
|
Back to top |
|
|
Pradip kumar Mohanty
New User
Joined: 16 Sep 2007 Posts: 33 Location: India
|
|
|
|
If i make out it correctly, then Dick was referring the question by Jose as being "Nice". That was a valid question indeed.
If jose's assuption is correct, then i would suggest the original poster to contemplate on these two items-
1. See, if the process can be broken into two parts. first part, a batch only process, accessing MQ, processing transactions and writing back to MQ and with the second part a MQ-CICS process to update DB2 table from MQ. Does not sound good to my ear, but can give it a try to see how much load on CICS can be reduced and the overall batch+CICS load.
2. See if from a business stand point, if this can be delayed till CICS comes down and make it a "batch only" process. Not much a possibility , as this looks like a "real time" mandate. However, if the as-is pprocess is really a killer, and the trade off shows in favour of a batch only process, then start the fight. |
|
Back to top |
|
|
Earl Haigh
Active User
Joined: 25 Jul 2006 Posts: 475
|
|
|
|
If you want to eliminate usage of MQ from batch exci processing, sugest you take a look at software product BatchCICS-Connect (www.batchcics.com) |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3054 Location: NYC,USA
|
|
|
|
Thanks Pradip and Earl.
EXCI is what I am also looking out for. |
|
Back to top |
|
|
|