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
- 5168 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is a view? Why use it?
What is innodb buffer pool?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is the purpose of rollback and commit?
What is the logical entity between plan and Package?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is EXPLAIN?
What is the FREE command?
What is copy book?
What is nvl in db2?
Mention the different locking levels that are available in db2.
COBOL 
