Prev: Run DB2CMD commands through PowerShell
Next: SQL0332N There is no available conversion for the source code page
From: Gregor Kovač on 11 Jul 2007 08:56
Hi!

I've tried LOAD .... INSERT INTO TABLE_NAME. The docs say about INSERT
option:
"One of four modes under which the load utility can execute. Adds the loaded
data to the table without changing the existing table data."

But when I do LOAD I get this in my message file:
Number of rows read = 671
Number of rows skipped = 0
Number of rows loaded = 671
Number of rows rejected = 0
Number of rows deleted = 669
Number of rows committed = 671

Why there are 669 rows being deleted? If rows are being deleted, can I
assume that this is similar to INSERT_UPDATE option with IMPORT?

I've tried to use LOAD with ADMIN_CMD command, but find it not very useful,
because the result set returned by this procedures gives me a MSG_RETRIEVAL
SQL. With this SQL I can get SQLCODE and MSG to get messages. The problem
is that my message file has:
--------------------------------------------------------------------------
SQL3501W The table space(s) in which the table resides will not be placed
in
backup pending state since forward recovery is disabled for the database.

SQL3109N The utility is beginning to load data from file
"/home/gregor/Apps/BLAGAJNA/IMPORT/10.07.2007_15.29.29.887/PODROCJE.IXF".

SQL2036N The path for the file or device
"/home/gregor/Apps/BLAGAJNA/IMPORT/10.07.2007_15.29.29.887/PODROCJE.IX" is
not
valid.

SQL3107W There is at least one warning message in the message file.


Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
--------------------------------------------------------------------------

but MSG_RETRIEVAL SQL only gives me:
SQL3107W There is at least one warning message in the message file.

Why? where is the problem?

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
From: Serge Rielau on 11 Jul 2007 11:31
Gregor Kovač wrote:
> But when I do LOAD I get this in my message file:
> Number of rows read = 671
> Number of rows skipped = 0
> Number of rows loaded = 671
> Number of rows rejected = 0
> Number of rows deleted = 669
> Number of rows committed = 671
Duplicates? Lots of duplicates...


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
From: The Boss on 11 Jul 2007 17:07
Serge Rielau wrote:
> Gregor Kovac wrote:
>> But when I do LOAD I get this in my message file:
>> Number of rows read = 671
>> Number of rows skipped = 0
>> Number of rows loaded = 671
>> Number of rows rejected = 0
>> Number of rows deleted = 669
>> Number of rows committed = 671
> Duplicates? Lots of duplicates...

I was thinking that as well, but wouldn't/shouldn't these just be rejected
i.s.o. loaded+committed+deleted?

--
Jeroen


From: Arun Srinivasan on 11 Jul 2007 18:41
On Jul 11, 4:07 pm, "The Boss" <use...(a)No.Spam.Please.invalid> wrote:
> Serge Rielau wrote:
> > Gregor Kovac wrote:
> >> But when I do LOAD I get this in my message file:
> >> Number of rows read = 671
> >> Number of rows skipped = 0
> >> Number of rows loaded = 671
> >> Number of rows rejected = 0
> >> Number of rows deleted = 669
> >> Number of rows committed = 671
> > Duplicates? Lots of duplicates...
>
> I was thinking that as well, but wouldn't/shouldn't these just be rejected
> i.s.o. loaded+committed+deleted?
>
> --
> Jeroen

Only 2 useful rows loaded. In this case, if you had used exception
table opton on the
load command the deleted rows will be in the exception table.If you
hadn't then either again
load(use exception), take rows /import. BUt since the number of rows
is really low(I even use
import for 50000 rows) you might as well do an import on the whole
file again...
Hope this helps

Arun

From: Serge Rielau on 11 Jul 2007 21:17
The Boss wrote:
> Serge Rielau wrote:
>> Gregor Kovac wrote:
>>> But when I do LOAD I get this in my message file:
>>> Number of rows read = 671
>>> Number of rows skipped = 0
>>> Number of rows loaded = 671
>>> Number of rows rejected = 0
>>> Number of rows deleted = 669
>>> Number of rows committed = 671
>> Duplicates? Lots of duplicates...
> I was thinking that as well, but wouldn't/shouldn't these just be rejected
> i.s.o. loaded+committed+deleted?
I think duplicate elimination is done in a post phase.
Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
 |  Next  |  Last
Pages: 1 2
Prev: Run DB2CMD commands through PowerShell
Next: SQL0332N There is no available conversion for the source code page