Our DB2 system has just 10 Lakhs records in each table (5 tables).
The screens are taking lot of time to respond with the results. Some one suggested that we need to Bind programs frequently to increase the performance. We did it once. But it didn't increase much. Does BInd process increases performance? How frequently do we need to do?
We BIND Package level. We never did BIND for Plan level (handled by DBA).
is there any other way to increase DB2 performance?
I searched many forums but couldn't get exact info.
results were like, Bind Plan, Bind Packages, Run Explain so on. not sure what to follow.