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
- 4960 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 if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
how can u nderstand the sql stmts executed successfully or not ?
Is ibm db2 open source?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
Can a Db2 table data be retrived through JCL?
What is performance tuning db2?
Are views updateable?
How to design maps
can any body explain about plan and pakage in detail....
Explain packages.
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is concurrency in db2?
COBOL 
