by Patrick Finnegan <finnegan.patrick@[EMAIL PROTECTED]
>
May 1, 2008 at 12:25 PM
On May 1, 7:32 pm, zgh1970 <george.zh...@[EMAIL PROTECTED]
> wrote:
> On May 1, 1:39 pm, Patrick Finnegan <finnegan.patr...@[EMAIL PROTECTED]
>
> wrote:
>
> > Tables may be reorg pending or "set integrity pending". Can 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,
Excellent. Thanks.
