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
- 4917 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 reorg and runstats in db2?
can all users have the privilage to use the sql statement select * (dml)?
Comment whether the cursor is closed during commit or not.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is database reorganization?
What is the difference between oracle and db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
what is the sqlcode -501
Explain about cursor stability?
What does runstats do in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
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 do you find the maximum value in a column in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is buffer pool in the db2 database?
