In this post, you’ll learn about the error message +162 tablespace database-name.tablespace-name has been placed in check pending in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
+162 tablespace database-name.tablespace-name has been placed in check pending
Reason for the Error
The indicated table space is in the CHECK PENDING state because ALTER TABLE was used to specify a referential constraint on a populated table.� The table space is not generally available until the CHECK PENDING state is removed from the table space.
Solution
The use of CHECK DATA is advised.
