what exactly does SYSCS_CHECK_TABLE?

[Xavier Vigouroux <Xa...@Sun.COM>]

Hi,

I am trying to create an agent that will check that a database is 
working correctly.
In this context what operation is performed by SYSCS_CHECK_TABLE?


thanks

-- 
Xavier VIGOUROUX - sun microsystems

Re: what exactly does SYSCS_CHECK_TABLE?

[Xavier Vigouroux <Xa...@Sun.COM>]

Thanks for these answers.

Le 1 sept. 05, à 18:20, Sunitha Kambhampati a écrit :

> Xavier Vigouroux wrote:
>
>>
>> Hi,
>>
>> I am trying to create an agent that will check that a database is  
>> working correctly.
>> In this context what operation is performed by SYSCS_CHECK_TABLE?
>>
>>
>> thanks
>>
> You may find this derby manual link  helpful , - explains what all  
> internal consistency checks are done as part of  SYSCS_CHECK_TABLE.  
> http://db.apache.org/derby/docs/10.1/adminguide/ 
> radminconsist30301.html
>
> Sunitha.
>
-- 
Xavier VIGOUROUX - sun microsystems

Re: what exactly does SYSCS_CHECK_TABLE?

[Sunitha Kambhampati <ks...@gmail.com>]

Xavier Vigouroux wrote:

>
> Hi,
>
> I am trying to create an agent that will check that a database is 
> working correctly.
> In this context what operation is performed by SYSCS_CHECK_TABLE?
>
>
> thanks
>
You may find this derby manual link  helpful , - explains what all 
internal consistency checks are done as part of  SYSCS_CHECK_TABLE. 
http://db.apache.org/derby/docs/10.1/adminguide/radminconsist30301.html

Sunitha.

Re: what exactly does SYSCS_CHECK_TABLE?

[Mike Matrigali <mi...@sbcglobal.net>]

check table checks that every row in a table can be retrieved
from a table and that all of the rows in it's associated indexes
are consistent.  It is a very heavy weight, cpu/io intensive
operation.

Xavier Vigouroux wrote:

> 
> Hi,
> 
> I am trying to create an agent that will check that a database is
> working correctly.
> In this context what operation is performed by SYSCS_CHECK_TABLE?
> 
> 
> thanks
>