Satya's Page

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 doing like this lot of IO is caused. Iam using an…See More