Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Check pending option for a DB2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
garlanaga

New User


Joined: 14 Oct 2008
Posts: 1
Location: chennai
PostPosted: Wed Oct 15, 2008 2:58 am    Post subject: Check pending option for a DB2 table
 Reply with quote
Hi

I tried to change the index of a table which had referential integrity with another table, due to this reason db2 puts check pending option to the table which I have tried to change the index and unable to access the table.

Please let me know how to clear the check pending option for the table.


cheers,
Naga
Back to top
View user's profile Send private message
References
Prasanthhere

Senior Member


Joined: 03 Aug 2005
Posts: 304
PostPosted: Wed Oct 15, 2008 10:58 am    Post subject: Reply to: Check pending option for a DB2 table
 Reply with quote
How about This link

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.ugref/db2z_resetcheckpendingstatusload.htm
Back to top
View user's profile Send private message
ruodeer

Active User


Joined: 06 Jul 2007
Posts: 60
Location: home
PostPosted: Wed Oct 15, 2008 11:50 am    Post subject:
Reply with quote
I think you should properly try the CHECK DATA utility, it can remove the ugly data from the oject caused by constraint such as RI...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1