Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

Puzzled

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TheSpongebob - 07 Mar 2006 17:48 GMT
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
Knut Stolze - 07 Mar 2006 18:30 GMT
> Hi,
>
[quoted text clipped - 12 lines]
> totalfreespace=0 chardel_ coldel~  decpt. replace into db.tab
> NONRECOVERABLE

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

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Serge Rielau - 07 Mar 2006 20:52 GMT
> Hi,
>
[quoted text clipped - 12 lines]
> totalfreespace=0 chardel_ coldel~  decpt. replace into db.tab
> NONRECOVERABLE

I think these are due to unique key violations.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

TheSpongebob - 07 Mar 2006 23:24 GMT
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.
Pierre Saint-Jacques - 08 Mar 2006 01:01 GMT
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.
Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Thanx. Key violations they were !
>
[quoted text clipped - 3 lines]
>
> Thanx guys.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.