load utility & identity column -- bug in db2?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sumanth - 09 Jun 2006 15:26 GMT

Hi,

We are having a strange problem that appears on Fix Pack 10.

Problem:
When using bulkloader to load data into a table that has a identity
column, the records get rejected and
are not inserted. All the records get rejected.

The moment I drop the identity column in the db2 table, all goes
fine.

Any thoughts on is this a bug in db2 or is it fixed in later fix
packs.

Thanks,
Sumanth

Reply to this Message

Serge Rielau - 09 Jun 2006 15:52 GMT

> Hi,
>
[quoted text clipped - 10 lines]
> Any thoughts on is this a bug in db2 or is it fixed in later fix
> packs.

Load has specific options the let you choose how to deal with identity
columns. Check the command reference for IDENTITYIGNORE, -OVERRIDE and
-MISSING

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Sumanth - 09 Jun 2006 16:03 GMT

Serge,

am using the ignoreidentity option. The same code works fine in
fix pack 8 but not fix pack 10.
not familiar with override and missing.

Thanks,
Sumanth

>> Hi,
>>
[quoted text clipped - 16 lines]
> Cheers
> Serge

Reply to this Message

Serge Rielau - 09 Jun 2006 16:54 GMT

> Serge,
>
[quoted text clipped - 22 lines]
>> columns. Check the command reference for IDENTITYIGNORE, -OVERRIDE
>> and -MISSING

If it's regression open a PMR. maybe something got "fixed" you
accidentally exploited, or there is indeed a bug.
Either way support is bets equipped to figure it out.

Cheers
Serge

PS: Have you checked the APAR lists fixed in FP9 and FP10?

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message