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
- 4955 Views
- I also Faced
- E-Mail Answers
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 COPY PENDING status?
what is sql abend code -801,-802?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is access path in db2?
How to access db2 tables in mainframe?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a base table?
What DB2 Catalog column tell you when an index needs table reorganized ?
Where are plans stored?
what's the best lock size that you could use when you create a tablespace?
can we view the access paths created by dbrm ? how ? thx
COBOL 
