Page 1 of 1

Can CHKP status be ignored on DB2 Unload

PostPosted: Fri Nov 25, 2016 1:47 am
by 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

Re: Can CHKP status be ignored on DB2 Unload

PostPosted: Tue Nov 29, 2016 1:39 pm
by 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:

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.

Re: Can CHKP status be ignored on DB2 Unload

PostPosted: Tue Nov 29, 2016 11:01 pm
by cvcv
Thanks pranav283