When adding a foreign key to an existing table , SQLCode 162 is returned. DB2 places a table space into CHECK PENDING state if:
1)Any table in that table space has ever been populated at any time.
2)A foreign key is added or modified for any table in the table space.
The library server performs and commits the foreign key creation. However, a warning message is written to the library server log to remind you to run the CHECK DATA DB2 utility so that tables and views in this table space can be accessed.