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
- 5021 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 tablespace?
When reorg is used?
what is Static and dynamic linking
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Which transaction use a command thread ?
What is meant by the attachment facility?
What is a Resource Control Table(RCT)? Describe its characteristics.
how to execute qcmdexc in rpgle?plz write code also?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What information is held in SYSIBM.SYSCOPY?
What is the information associated with sysibm.syslinks table?
COBOL 
