Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose I have a program which uses a dynamic SQL and it
has been performing well till now. Off late, I find that
the performance has deteriorated. What happened?
- 1 Answers
- 5103 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
Check if it is a DB2 problem or not. If its a DB2 problem ,
It depends !!!
Check the access path and see if there is a problem.
RUNSTATS may be necessary to update the statistics if the
data characteristics has been changed.
OR
Check for locking problems
OR
Check for failed messages
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I start db2 in windows?
What is runstats db2?
Explain the contention situations caused by locks?
What is the physical storage length of time data type?
What is the role of union all and union
What is multi row fetch in db2?
can we view the access paths created by dbrm ? how ? thx
Differentiate between cs and rr isolation levels? Where do you specify them?
Is it possible using max on a char column?
What is page size in db2?
What is scrollable cursor in db2?
How and when does the db2 enforces the unique key?
What is an instance database?
What is cascading rollback?
Define buffer pool.
