GeekInterview.com
Series: Subject: Topic:
Question: 78 of 207

What is check pending and copy pending status in DB2, how do you resolve it?

Asked by: Interview Candidate | Asked on: Sep 14th, 2006
Showing Answers 1 - 9 of 9 Answers
sangramkc

Answered On : Nov 18th, 2006

Check pending status of a table is set on when you are loading into table with log no and that table has some referencial constarint with other table.

copy pending status is set on when you are loading into a table without a NOCOPYPEND option.

Thanks,

Sangram

  
Login to rate this answer.

If the table is loaded with ENFORCE NO option then the table space get into check pending status. That means table space is loaded without enforcing constraints. CHECK utility needs to be run on table space.

If table is loaded with LOG NO option then it get's into cpoy pending status. The meaning is image copy is needed on table space.

Yes  1 User has rated as useful.
  
Login to rate this answer.
sethy.pradeep

Answered On : Nov 18th, 2008

View all answers by sethy.pradeep

In Copy pending status the table is available only for query processing. The solution of copy pending status is take an image copy or use repair utility.
Check pending status happens only when the table is loading with ENFORCE NO option.
It means the load utility didn't perform constraint checking.
Regards,
Pradeep

  
Login to rate this answer.
yuvaevergreen

Answered On : Mar 26th, 2010

View all answers by yuvaevergreen

Following utilities set the CHECK-pending status

  • LOAD with ENFORCE NO
  • RECOVER to a point in time
  • CHECK LOB

1. Check and correct referential integrity constraints using the CHECK DATA utility.

If a table space is in both REORG-pending and CHECK-pending status (or auxiliary CHECK-pending status), run REORG first and then use CHECK DATA to clear the respective states.

2. COPY-pending (COPY) restrictive status indicates that the affected object must be copied

3. Take an image copy of the affected object.

  
Login to rate this answer.
RAM

Answered On : Jul 29th, 2011

where are packages and plan are stored ?

  
Login to rate this answer.
RAM

Answered On : Jul 29th, 2011

COPY PENDING
A state in which, an Image Copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.

CHECK PENDING
When a table is Loaded with ENFORCE NO option, then the table is left in CHECK PENDING status. It means that the LOAD utility did not perform constraint checking


Thanks & Regards
RAM

  
Login to rate this answer.
jzmoonrock56

Answered On : Aug 31st, 2011

View all answers by jzmoonrock56

IBM utilities run on tablespaces will leave the tablespace in a check pending or copy pending status depending on the parameters used. Once this happens the table within the tablespace cannot be accessed. You can run another utility to remove the flags or use interactive DB2 commands from the TSO panel and enter a command to force the tablespace open which will remove the flags.

  
Login to rate this answer.
Mohit

Answered On : May 28th, 2012

SET INTEGRITY Option....please read IBM libraries before using this.

  
Login to rate this answer.

Check Pending is when you have data added to the table using either insert or LOAD utility which violate table check constraints. The IBM DB2 LOAD UTILITY has ENFORCE CONSTRAINTS and similar options which disable enforcing tablespace check constraints during the LOAD operation. After the LOAD, if at least one of the records in the table violates the table check constraint, the tablespace goes into CHECK Pending Status. Similarly, index can also go into CHECK PENDING status if the constraints are managed using Indexes.

CHECK INDEX and CHECK DATA Utilities can be run to remove the tablespace or IndexSpace from CHECK PENDING Status (i.e. delete rows violating Check constraints)

COPY Pending is mostly encountered when a LOAD RESUME (append) is done on a table without taking an ImageCopy Backup or if NOCOPYPEND option is not used in the LOAD parameter. This can be removed by taking an ImageCOpy of the tablespace in question or the TableSpace can be stopped and started using ACCESS FORCE TSO DSN Commands.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.