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…Continue
Added by Satya on January 18, 2016 at 11:16am — No Comments