Can CHKP status be ignored on DB2 Unload

[cvcv]

Hi,

Can a CHKP status (set on a tablespace) be ignored when doing a DB2 table unload?

UNLOAD FROM TABLE RSMTZO#1.TPRINMP
PUNCHDDN UNLDPNCH

Thanks

[pranav283]

Hi,

In general- No. One should never leave any pending status on the table which is meant to be accessed by the application programs.
If you see that your tablespace is in CHECK PENDING status - it means that whenever the latest 'LOAD' was executed, the referential integrity constraints were not taken care of.
So, make sure whenever there is a dependency of a table (residing in the TS in the picture) with a different table, always LOAD it using this option:

Code: Select all

ENFORCE YES

Probably, whenever the LOAD of the table would have been taken, it would have been with 'ENFORCE NO' or default.

And now that you have to access the table again, you need to repair it first. So, use this command:
REPAIR TABLESPACE SET dbname.tsname NOCHKPEND

Also, ask your DBAs whether to add some options to this command or not as they may be aware of the site specific standards.

[cvcv]

Thanks pranav283