LOAD,LOG NO,DUPLICATE RECORDS

Leila Hosseini

LOAD,LOG NO,DUPLICATE RECORDS
Hi dear listers.
we have DB2 V6 IN MAINFRAME.
I have a question about load utility,with LOG NO
option ,if there is record in table, duplicate records
will write in log?
how can solve this problem?
Thanks in Advance.
L.S.Hoseini


____________________________________________________________________________________
Be a better sports nut! Let your teams follow you
with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: LOAD,LOG NO,DUPLICATE RECORDS
(in response to Leila Hosseini)
Hi Laila

If you run the LOAD utility, regardless of whether you have LOG YES or
LOG NO, DB2 will REMOVE duplicate records from the table during one of
the final stages of the load

Bear in mind, that a "duplicate" record is only detected where there is
one (or more) unique indexes on the table you are loading into - if the
same record is in the input dataset more than once and there are NO
unique indexes, then Db2 does NOT regard these as duplicates

Hope this helps

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Laila hosaini
Sent: 28 November 2007 11:38
To: [login to unmask email]
Subject: [DB2-L] LOAD,LOG NO,DUPLICATE RECORDS

Hi dear listers.
we have DB2 V6 IN MAINFRAME.
I have a question about load utility,with LOG NO option ,if there is
record in table, duplicate records will write in log?
how can solve this problem?
Thanks in Advance.
L.S.Hoseini



________________________________________________________________________
____________
Be a better sports nut! Let your teams follow you with Yahoo Mobile.
Try it now.
http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm