Suppose I have a program which uses a dynamic SQ

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Suppose I have a program which uses a dynamic SQL and it has been performing ...

Q: Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that performance has deteriorated. What happened?

AN:
There may be one of the following reasons:
probably RUN STATS is not done and the program is using a wrong index due to incorrect stats.
probably RUN STATS is done and optimizer has chosen a wrong access path based on the latest statistics.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between group by and order by ?
• What is the COBOL picture clause for a DB2 column defined
• What are the disadvantages of PAGE level lock?
• What is the picture clause of the null indicator variable?
• Where could you look if you had a question about whether a column has been defined as an index?
• How would you print the output of an SQL statement from SPUFI?
• How does DB2 determine what lock-size to use?
• Why might full image copies be faster to implement than an incremental image copy?
• How does DB2 determine what lock-size to use?
• What information is used as input to the bind process?
• More...