Kevin
Have you tried the load using any of the identity or generated modifiers,
e.g. identityignore, generatedignore?
Regards
Alex
-----Original Message-----
From: Serge Rielau
[mailto:db2udbdba-ezmlmshield-x56399905.[Email address protected]
Sent: 28 December 2005 23:34
To: LazyDBA Discussion
Subject: [Maybe Spam] Re: Load error: Error requesting identity
values...


I find it highly unlikely that you manage to roll-over a BIGINT.
Was teh generated column GENARTAED ALWAYS (and has it always been like
this?
Were it's properties e.g. RESTART, INCREMENT ever changed?
What about previous loads, could it be you loaded other data
with OVERIDE
which occupied value ranges yet to be covered?
Assuming you use an incrementing generation consider selecting
the MAX()
from th table and use it (+ 1) to RESTART.

Cheers
Serge



"Kevin Knaus " <db2udbdba-ezmlmshield-x31761246.[Email address
protected]
wrote on 12/28/2005 02:56:33 PM:

> I had a cursor based load fail. The table contains a system generated
> identity column. The LOAD was done using "INSERT INTO" the table from
> the cursor.
>
> Does the error mean that the unique column identifier value generator
> has "rolled over" the limit for its datatype (in this case a bigint)?
> How do I ensure that the column is cleanly populated? Do I
need to drop
> and recreate the table periodically, or can I specify that
the generated
> identity column restart with every load?
>
> LOADID: 23247.2005-12-28-07.16.54.506755.0 (32;4)
> Error requesting identity values. -359, 0x800400d8,
Detected in file:
> sqluident.C,line 567
>
> Thank you,
>
> Kevin Knaus
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



******************************************************
The information in this E-mail and in any attachment is
confidential and is intended solely for the addressee.
Access, copying, disclosure or use of such information
by anyone else is unauthorised. If you are not the
intended recipient please contact [Email address protected]
While reasonable efforts are made to ensure these files are free
of virus infection and offensive materials, if something of this
nature is inadvertently sent to you, please destroy it, accept
our apologies and contact [Email address protected] with
details of the sender. We will ensure that action is taken
immediately to prevent any recurrence. Debenhams accept no
responsibility for any views expressed by the originator of this email.


Debenhams Retail plc (reg. no. 83395) Registered in England and Wales.
Registered office: 1 Welbeck Street, London W1G 0AA.

http://www.debenhams.com

******************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page