View Single Post

   
  #2 (permalink)  
Old 02-27-2008, 05:00 AM
Knut Stolze
 
Posts: n/a
Default Re: Integrity pending

Jurgen Haan wrote:

> Hey All..
>
> What's the easiest way to query all the tables that are in a integrity
> pending state?


Querying SYSCAT.TABLES.STATUS. If that column is set to 'C', then the table
is is "check pending" state.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Reply With Quote