Can CHKP status be ignored on DB2 Unload



IBM's flagship relational database management system

Can CHKP status be ignored on DB2 Unload

Postby cvcv » Fri Nov 25, 2016 1:47 am

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
cvcv
 
Posts: 11
Joined: Fri Aug 28, 2015 6:05 pm
Has thanked: 2 times
Been thanked: 0 time

Re: Can CHKP status be ignored on DB2 Unload

Postby pranav283 » Tue Nov 29, 2016 1:39 pm

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.
pranav283
 
Posts: 47
Joined: Sat Aug 30, 2014 3:52 pm
Has thanked: 2 times
Been thanked: 0 time

Re: Can CHKP status be ignored on DB2 Unload

Postby cvcv » Tue Nov 29, 2016 11:01 pm

Thanks pranav283
cvcv
 
Posts: 11
Joined: Fri Aug 28, 2015 6:05 pm
Has thanked: 2 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post