DB2 Error Code – +162 tablespace database-name.tablespace-name has been placed in check pending

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.