Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: Determining...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 8846 of 9520
Post > Topic >>

Re: Determining Table Status?

by zgh1970 <george.zhang@[EMAIL PROTECTED] > May 1, 2008 at 11:32 AM

On May 1, 1:39=A0pm, Patrick Finnegan <finnegan.patr...@[EMAIL PROTECTED]
>
wrote:
> Tables may be reorg pending or "set integrity pending". =A0Can I run a
> script to determine the status of a table?

you can
select status from syscat.tables where status<>'N';
'C' means check pending. you need to set integrity.
For the reorg,   you can use
db2 list utilities to find the table in reorg.
thanks,
 




 3 Posts in Topic:
Determining Table Status?
Patrick Finnegan <finn  2008-05-01 10:39:19 
Re: Determining Table Status?
zgh1970 <george.zhang@  2008-05-01 11:32:01 
Re: Determining Table Status?
Patrick Finnegan <finn  2008-05-01 12:25:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 21:00:46 CST 2008.