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
- 4595 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 |
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What's The Percentage Free Space ?
Where could you look if you had a question about whether a column has been defined as an index?
i want to delete 20th million record how ?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Define db2 and its databases?
Which are the db2 tools to protect integrity of the database?
How to find the number of rows in a db2 table?
How does one remove entries from the SCT02 table?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
How do I copy a table in db2?
COBOL 
