DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is the best lock size that you could use wh

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

(Continued from previous question...)

What is the best lock size that you could use when you create a tablespace?

The answer is Locksize = ANY. Unless you are Sure what is the PURPOSE of tablespace ie, Read only or R/W. If you use lock size = ANY, DB2 would automatically detemine what type of locks it should use.

(Continued on next question...)

Other Job Interview Questions