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 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 create a view in db2?
What is nvl in db2?
How many databases can be created inside an instance in db2 ?
Can there be more than one cursor open for any program?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a bind card?
What is db2 bind?
How can you quickly find out the # of rows updated after an update statement?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What does sqlcabc has?
What do you mean by between and in? Is between inclusive of specified range values?
Explain package in db2 and its advantages?
What is cloudant database?
What is iseries database?
How to execute stored procedures?