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
- 4943 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
What is db2 command?
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of value function?
Explain about rct in db2?
What is explain in db2?
What is sqlca’s maximum length?
What is alias in db2?
What is ibm db2 database?
How and when does the db2 enforces the unique key?
i want to maintain uniqueness on pdf without make lf??????????
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How do I import a csv file into db2?
What is a db2 schema?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to access db2 tables in mainframe?
