steps in running CHECK DATA.

Rajendra Deshpande

steps in running CHECK DATA.
Hi friends,

I need to know the steps involved in running CHECK DATA utility on a table
space in check-pending state following a LOAD operation. How are invalid
row deletions effected. Does it result in the deletion of rows from parent
table too. Any information will be greatly appreciated.

TIA.



Bayard Tysor

Re: steps in running CHECK DATA.
(in response to Rajendra Deshpande)
Rajendra,

If you use DELETE YES, and have an SYSERR dataset, all
the discarded rows will be written to the SYSERR
dataset. These can be used for analysis and then could
then be used as a load file once the appropriate rows
in the parent table have been added (if that is what
is desired).

No rows in the parent table are effected.

Tink
--- Rajendra Deshpande
<[login to unmask email]> wrote:
> Hi friends,
>
> I need to know the steps involved in running CHECK
> DATA utility on a table
> space in check-pending state following a LOAD
> operation. How are invalid
> row deletions effected. Does it result in the
> deletion of rows from parent
> table too. Any information will be greatly
> appreciated.
>
> TIA.
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can


=====
B.L. "Tink" Tysor
Bayard Lee Tysor, Inc
(401)965-2688
www.BLTysor.com

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com



Srikanth (Cognizant) Chavali

Re: steps in running CHECK DATA.
(in response to Bayard Tysor)
Hi Rajendra,
When the CHECKDATA utility is executed, the way in which the invalid
rows
are handled depends on the FOR EXCEPTION clause of the CHECKDATA utility
control statement. If you use

FOR EXCEPTION IN table1 USE table2

where table1 is the table that was in check pending status
and table2 is the exception table that has same structure of table2,
then all the invalid rows will be placed in the exception table (table2).

You can also specify whether you want to delete the invalid rows from table1

after they were placed in table2 by using the DELETE clause.

And when you want to delete the invalid rows from a parent table with the
option SCOPE ALL, all the corresponding rows in the dependent tables will
also get deleted. One thing we need to remember here is to create the
exception tables for all the dependant tables also.

With regards,
Srikanth

> -----Original Message-----
> From: Rajendra Deshpande [SMTP:[login to unmask email]
> Sent: Monday, December 17, 2001 6:58 PM
> To: [login to unmask email]
> Subject: steps in running CHECK DATA.
>
> Hi friends,
>
> I need to know the steps involved in running CHECK DATA utility on a
> table
> space in check-pending state following a LOAD operation. How are invalid
> row deletions effected. Does it result in the deletion of rows from parent
> table too. Any information will be greatly appreciated.
>
> TIA.
>
>
>
>
>