On May 1, 7:32 pm, zgh1970 <george.zh...@lombard.ca> wrote:
> On May 1, 1:39 pm, Patrick Finnegan <finnegan.patr...@gmail.com>
> 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.