What is meant by repeatable read?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is meant by repeatable read?

When an application program executes with repeatable read protection, rows referenced by the program can't be changed by other programs until the program reaches a commit point.

(Continued on next question...)

Other Interview Questions

• What is a synonym ? How is it used ?
• What else is there in the PLAN apart from the access path?
• What is Maximum number of rows per page
• What is DCLGEN?
• What are some SQL aggregates and other built-in functions?
• Where is the access path logic created by the DB2 Optimizer stored?
• What is ALTER?
• What is the error code - 803 ?
• How does DB2 determine what lock-size to use?
• What is the purpose of the WHENEVER statement?
• More...