Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Jun 23
    2000

    Load w/Discards 1 & abends?

    Jessen Michael
    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
    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
    [Ciber, Inc.]
    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




    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact