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?
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 is the function of logging in the db2 database?
List out the data types available.
What are the three types of page locks that can be held?
What is a DB2 catalog?
What is the use of predicate?
What is declare cursor?
How would you print the output of an SQL statement from SPUFI?
How and when does the db2 enforces the unique key?
What does sqlcabc has?
what is the difference between normal select query and currosor
Explain about cursor stability?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?