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
What are the contents of a dclmgen?
What's The Error Code For Unique Index Voilation?
List some fields from sqlca?
What is host variable in db2 cobol?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How and when does the db2 enforces the unique key?
What is iseries database?
What is meant by dclgen?
Explain about dbrm.
What is a trigger in the db2 database?
Define declaration generator (dclgen).
List down the types of triggers in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is database manager in db2?
How does coalesce work?