In which column of which DB2 catalog would you f

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

(Continued from previous question...)

In which column of which DB2 catalog would you find the length of the rows for all tables?

In the RECLENGTH column of SYSIBM.SYSTABLES

(Continued on next question...)

Other Job Interview Questions

• How does DDB2 use multiple table indexes ?
• What is a predicate?
• What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible?
• What is a collection?
• What are the three lock types?
• When can you be sure that a quary will return onlyl one row ?
• What does the SQLcode of -818 pertain to?
• What information is contained in a SYSCOPY entry?
• What is a synonym?
• What is QUIESCE ?
• More...