DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

What is check pending and copy pending status in

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

(Continued from previous question...)

What is check pending and copy pending status in D...

1. Check pending status of a table is set on when you are loading into table with log no and that table has some referencial constarint with other table.

copy pending status is set on when you are loading into a table without a NOCOPYPEND option.

2. If the table is loaded with ENFORCE NO option then the table space get into check pending status. That means table space is loaded without enforcing constraints. CHECK utility needs to be run on table space.

If table is loaded with LOG NO option then it get's into cpoy pending status. The meaning is image copy is needed on table space.

(Continued on next question...)

Other Job Interview Questions