SEO

#1 (**permalink**) 05-02-2008, 05:04 AM

Tables may be reorg pending or "set integrity pending". Can I run a
script to determine the status of a table?

#2 (**permalink**) 05-02-2008, 05:04 AM

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,

#3 (**permalink**) 05-02-2008, 05:04 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Determining Table Status?