I have a table A with 30,000 Records.
Module B selects the data from the table A.
This module B is called via online(CICS) and Batch mode.
This Module is called 30 million times in day. 20% of traffic is via Online mode and 80% of traffic is via Batch Mode.
In a second this Table is referred 30 times and in a minute 4500 times.
Each time Module B is triggered it selects data from Table A.
Whenever I do a select to table A. IO is caused and by…
ContinueAdded by Satya on January 18, 2016 at 11:16am — No Comments
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
© 2019 Created by channeldb2.
Powered by