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
- 5035 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 are bind parameters in db2?
What is reorg and runstats in db2?
Why select is not preferred in embedded sql programs?
What is load replace in db2?
What is the maximum size of a char data type in db2?
What are concurrency issues?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a page in db2?
Explain in brief how does db2 determine what lock-size to use?
What is phantom read in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the connection string to connect to the DB2 Database ?
Explain about dbrm.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a db2 package?
