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
3  3499 
Sumanth wrote: 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.
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
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
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:4e*************@individual.net... Sumanth wrote: 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.
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sumanth wrote: 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
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:4e*************@individual.net... Sumanth wrote: 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.
Load has specific options the let you choose how to deal with identity
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?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dan Sikorsky |
last post by:
How can I get the recordset attributes for a table field in SQL Server 2000
to report the field updatable attribute correctly ... mine keeps saying the
fields are not updatable? That is, (...
|
by: hharry |
last post by:
Hello All,
Does the BCP utility enable you to selectively import rows from a flat
file to a table ?
For example:
The first column in my flat file contains a record type - 1, 2..7
I only...
|
by: Stefan Bauer |
last post by:
Hi NG,
we've got a very urgent problem... :(
We are importing data with the LOAD utility. The input DATE field data
is in the format DDMMYYYY (for days) and MMYYYY (for months).
The target...
|
by: davvid |
last post by:
hello,
please I would like to know if it's possible to load data in
hierarchical table structure with identity column used as pk (for all
the tables) :
I mean
table root (Id_root(pk,identity...
|
by: jrthor2 |
last post by:
I have a shell script I am trying to run that loads a table from a
control file. The file I am trying to load is delimited by the "}"
character. How do I set the delimeter code? Here is my load...
|
by: Konstantin Andreev |
last post by:
Recently I became interested, - Are the data, bulk loaded in the table with
LOAD utility, consume the same disk space as loaded with IMPORT utility? The
answer turned out to be NOT !
Here is a...
|
by: clilush |
last post by:
I'm trying to fix up a database on my server by transferring all the
readable data to a new database, and then upgrading it from db2-7 to
db2-8. I'm using the export command to dump the tables...
|
by: abrahamvk |
last post by:
Hi,
How to load data into Japanese DB2 Database using DB2 Load Utility, where the table column names are in Japanese in windows environment.
We could successfully load Japanese data into a table...
|
by: Eric Davidson |
last post by:
I am try to find a way to get load to reject a record if the data is
too large and not just truncate it.
eg.
c:\temp\fred3.txt
------
a23456789012345678901234567890...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
