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.
Joined: 23 Nov 2006 Posts: 13604 Location: 221 B Baker St
Hello,
I suspect that a re-bind is not your problem unless there has been a change to the volume or content that might influence the optimizer.
I suspect that the code is processing too many rows for an online transaction or the process is not properly accessing the needed rows (full table transversal instead of direct access).
Suggest you work with your dba and run/analyze an EXPLAIN.
Thanks for the response.
However, We tried to check with our DBAs but couldn't get proper answer.
We do not have access to run EXPLAIN so we don't know what is going on.
Do you think Binding Plan would increase the performance?
We Bound the Plan only at Implementation. After that we had one time Heavy Data Load to DB2 system But we never Bound the Plan.
I just wanted to make sure before I go to our DBA's. (We are with Govt client so it takes time to implement any thing).
