Load w/Discards 1 & abends?

Jessen Michael

Load w/Discards 1 & abends?
DB2 OS/390 V5.2 - DB2 Load utility.
Table is not partitioned. Does not have a PK defined, but does have a
unique index.

When I load duplicate records using LOAD RESUME YES DISCARDS 0, I get all
all duplicates in my discard dataset and no abend.

When I load duplicate records using LOAD RESUME YES DISCARDS 1, I get an
empty discard dataset and my load abends in the INDEXVAL stage with the
following reason code:
00E40323
Explanation: An error occurred during the execution of a LOAD or REORG
utility. Prior to this abend, error messages identifying the specific
problem were issued. The abend is issued so that work data sets, which
will be needed if the utility is restarted, are saved.

In the manual, it says I can either restart the job or terminate the
utility.
If I terminate the utility, the index is in a recover pending status. When
I try to recover the index, I abend because all my duplicate data was loaded

into the table on the initial load...

I'm not sure how restarting the utility would fix anything????

Any insight on how to handle this would be greatly appreciated!
Thanks!
Mike



craig patton

Re: Load w/Discards 1 & abends?
(in response to Jessen Michael)
Mike,

I am not sure what your question is in this case. Are you aware of the
function of the DISCARDS parameter? YOU are forcing the abend with DISCARDS
1 as this is the LIMIT of DISCARDED ROWS for that load. A Value of '0'
represents 'infinite', which means to keep DISCARDING rows until all invalid
rows are discarded with NO limits (other than the size of your discard DSN).

I believe that I would RECOVER your TABLESPACE for that TABLE from your last
image copy. Also, I HOPE you are taking an IMAGE copy just PRIOR to the
RESUME YES LOAD(Might want to make that a standard). If you do NOT have a
good recent copy. Perhaps you can FORCE start the index, DROP the UNIQUE
index, DELETE the duplicate rows manually, then RECREATE the UNIQUE Index.

HTH,
Craig Patton
DB2 DBA


>From: Jessen Michael <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Load w/Discards 1 & abends?
>Date: Fri, 23 Jun 2000 12:54:24 -0500
>
>DB2 OS/390 V5.2 - DB2 Load utility.
>Table is not partitioned. Does not have a PK defined, but does have a
>unique index.
>
>When I load duplicate records using LOAD RESUME YES DISCARDS 0, I get all
>all duplicates in my discard dataset and no abend.
>
>When I load duplicate records using LOAD RESUME YES DISCARDS 1, I get an
>empty discard dataset and my load abends in the INDEXVAL stage with the
>following reason code:
>00E40323
>Explanation: An error occurred during the execution of a LOAD or REORG
>utility. Prior to this abend, error messages identifying the specific
>problem were issued. The abend is issued so that work data sets, which
>will be needed if the utility is restarted, are saved.
>
>In the manual, it says I can either restart the job or terminate the
>utility.
>If I terminate the utility, the index is in a recover pending status. When
>I try to recover the index, I abend because all my duplicate data was
>loaded
>
>into the table on the initial load...
>
>I'm not sure how restarting the utility would fix anything????
>
>Any insight on how to handle this would be greatly appreciated!
>Thanks!
>Mike
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com



Rick Creech

Re: Load w/Discards 1 & abends?
(in response to craig patton)
Another option is to use the repair utility to delete the undesired row.
HTH,
Rick CReech


>From: craig patton <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: Load w/Discards 1 & abends?
>Date: Fri, 23 Jun 2000 11:19:49 PDT
>
>Mike,
>
>I am not sure what your question is in this case. Are you aware of the
>function of the DISCARDS parameter? YOU are forcing the abend with
>DISCARDS
>1 as this is the LIMIT of DISCARDED ROWS for that load. A Value of '0'
>represents 'infinite', which means to keep DISCARDING rows until all
>invalid
>rows are discarded with NO limits (other than the size of your discard
>DSN).
>
>I believe that I would RECOVER your TABLESPACE for that TABLE from your
>last
>image copy. Also, I HOPE you are taking an IMAGE copy just PRIOR to the
>RESUME YES LOAD(Might want to make that a standard). If you do NOT have a
>good recent copy. Perhaps you can FORCE start the index, DROP the UNIQUE
>index, DELETE the duplicate rows manually, then RECREATE the UNIQUE Index.
>
>HTH,
>Craig Patton
>DB2 DBA
>
>
>>From: Jessen Michael <[login to unmask email]>
>>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>>To: [login to unmask email]
>>Subject: Load w/Discards 1 & abends?
>>Date: Fri, 23 Jun 2000 12:54:24 -0500
>>
>>DB2 OS/390 V5.2 - DB2 Load utility.
>>Table is not partitioned. Does not have a PK defined, but does have a
>>unique index.
>>
>>When I load duplicate records using LOAD RESUME YES DISCARDS 0, I get all
>>all duplicates in my discard dataset and no abend.
>>
>>When I load duplicate records using LOAD RESUME YES DISCARDS 1, I get an
>>empty discard dataset and my load abends in the INDEXVAL stage with the
>>following reason code:
>>00E40323
>>Explanation: An error occurred during the execution of a LOAD or REORG
>>utility. Prior to this abend, error messages identifying the specific
>>problem were issued. The abend is issued so that work data sets, which
>>will be needed if the utility is restarted, are saved.
>>
>>In the manual, it says I can either restart the job or terminate the
>>utility.
>>If I terminate the utility, the index is in a recover pending status.
>>When
>>I try to recover the index, I abend because all my duplicate data was
>>loaded
>>
>>into the table on the initial load...
>>
>>I'm not sure how restarting the utility would fix anything????
>>
>>Any insight on how to handle this would be greatly appreciated!
>>Thanks!
>>Mike
>>
>>
>>
>>
>>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com