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
- 5029 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 syscat in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What r the comman abends in db2, jcl and cobol???????
Mention the location where the output received from explain statement is stored.
What is query_cache_limit?
what is utility for parm lib
How is deadlock resolved?
What is the difference between cursor and select statement?
What is db2 instance?
What are the contents of dclgen?
Why do we use cursor?
What is the latest version of ibm db2?
What are the two types of logging in the db2 database? Explain them.
What is a db2 schema?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
