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 bufferpool in db2?
is it possible to get -811 error when you use cursors. why?
What is db2 purescale?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
wht r the requirements for writing a cobol-db2 pgm ?
What's the difference between DB2 active log and archive log? Thanks a lot...
what is different three logs in DB2?
What is the difference between TYPE 1 index & TYPE 2 index
What is ALTER ?
how can u retrieve the data from null values using applicaion program.
How do you define a correlated name?
What is a db2 collection?