I have a requirement. In order to reduce the DB2 access in online transactions, we intend to have a cursor to fetch the rows of the table for the first first transaction of a thread, load it to a COBOL array and then access the COBOL array for the remaining transactions instead of the table.
I wanted to know if
a) I will make any savings with the reduction in the DB2 access.
b) Will the Response time take a heavy beating. I am expecting a slight rise.