Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Db2 Data loading problems

    I am loading a huge amount of data(10000 rows) in a DB2 table.
    After loading 5000 rows successfully I encounter an abend.

    How can I load from 5001 row , without starting the process from first.

    Plz can anyone give an explanation for this.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to post the exact command you issued and the complete error message. We may knowledgeable in DB2, but we are somewhat lacking in mental telepathy skills.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    10000 is not a huge amount, by any measure, so you can restart the LOAD from the beginning.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Mar 2009
    Posts
    2
    Definitely it's not huge.
    But Incase I have a huge amount of data and If I do not want to restart from the beginning all over.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •