467,113 Members | 1,351 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,113 developers. It's quick & easy.

Puzzled

Hi,

On running a load, I get the following summary:
What are the rows deleted ? There were more rows thatn that there to
begin with.
Number of rows read = 64692
Number of rows skipped = 0
Number of rows loaded = 64692
Number of rows rejected = 0
Number of rows deleted = 89
Number of rows committed = 64692

load from tab.dat of del modified by usedefaults pagefreespace=0
totalfreespace=0 chardel_ coldel~ decpt. replace into db.tab
NONRECOVERABLE

Mar 7 '06 #1
  • viewed: 1078
Share:
4 Replies
TheSpongebob wrote:
Hi,

On running a load, I get the following summary:
What are the rows deleted ? There were more rows thatn that there to
begin with.
Number of rows read = 64692
Number of rows skipped = 0
Number of rows loaded = 64692
Number of rows rejected = 0
Number of rows deleted = 89
Number of rows committed = 64692

load from tab.dat of del modified by usedefaults pagefreespace=0
totalfreespace=0 chardel_ coldel~ decpt. replace into db.tab
NONRECOVERABLE


Well, what are the other messages (the ones before that summary) telling
you?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 7 '06 #2
TheSpongebob wrote:
Hi,

On running a load, I get the following summary:
What are the rows deleted ? There were more rows thatn that there to
begin with.
Number of rows read = 64692
Number of rows skipped = 0
Number of rows loaded = 64692
Number of rows rejected = 0
Number of rows deleted = 89
Number of rows committed = 64692

load from tab.dat of del modified by usedefaults pagefreespace=0
totalfreespace=0 chardel_ coldel~ decpt. replace into db.tab
NONRECOVERABLE

I think these are due to unique key violations.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 7 '06 #3
Thanx. Key violations they were !

DB2 "deleted" some rows on me. Mind you, the rows were never actually
on the table and they weren't "deleted" off the flat file ...
I learned how to dump the messages too for next time.

Thanx guys.

Mar 7 '06 #4
LOAD has the responsability to get the data in there as fast as possible.
So duplicate key are not immediately checked and are therefore put into the
page. In the second phase of the load, the indexes are either maintained
and or rebuilt. At that point the load will recognize duplicate keys on
unique indexes. The row being already in the table, it is deleted.
If you run the same load with the following ... FOR EXCEPTION
tabschema.tabname
then load will keep the first key encountered and insert into the exception
table any duplicate subsequently met.
Please note that only for duplicate keys, both the delete and insert will be
logged.

So, as previously mentioned your 89 rows were most probably duplicate keys
deleted.

HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"TheSpongebob" <ga*****@sympatico.ca> a écrit dans le message de news:
11**********************@i40g2000cwc.googlegroups. com...
Thanx. Key violations they were !

DB2 "deleted" some rows on me. Mind you, the rows were never actually
on the table and they weren't "deleted" off the flat file ...
I learned how to dump the messages too for next time.

Thanx guys.


Mar 8 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Maciej Nadolski | last post: by
reply views Thread by Alex Molochnikov | last post: by
7 posts views Thread by Robin Becker | last post: by
4 posts views Thread by Philip Yale | last post: by
7 posts views Thread by Jonathan N. Little | last post: by
3 posts views Thread by Colin J. Williams | last post: by
11 posts views Thread by Daniel | last post: by
reply views Thread by alexandre_irrthum@yahoo.com | last post: by
15 posts views Thread by Lorenzo Stella | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.