What happens to a tablespace when its recovery i

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

(Continued from previous question...)

What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible?

The tablespace is put into copy pending status.

(Continued on next question...)

Other Job Interview Questions

• What information is contained in a SYSCOPY entry?
• B37 abend during SPUFI
• What is a clustered index?
• What is the SQL Communicaions Area and what are some of its key fields?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is the function of buffer manager ?
• How to see the structure of DB2 table?
• What are the three lock types?
• Where besides the DB2 catalog is database object information stored by DB2?
• What is the best lock size that you could use when you create a tablespace?
• More...