DB2 + transactional + Data + Performance Techniques

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 clone database for maintenance purposes.


I am looking for options where I reduce IO and get best performance.

Options which I already had a thought

1)      Create an internal array in the program.   Whenever the program is called  first check if  there is an entry in the Internal array(Via Sequential Search). If it is present in Internal array then respond  the request with the data present in  internal array. If  data is present in Internal array then fetch the data from the Table store the data in the Internal array and  respond  the request with the data received from the table.






Views: 148


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service