Results 1 to 3 of 3

Thread: Batch Program giving error after inserting 38,000 records

  1. Feb 23rd, 2009, 10:04 AM #1
    adish1234
    adish1234 is offline Member
    Join Date
    Jan 2009
    Posts
    33

    Post Batch Program giving error after inserting 38,000 records

    Hi,
    I am using DB2 database. My batch program is to read from fixed length flat file and inserting into a table. It is giving error SQLCODE: -904(Error: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON , TYPE OF RESOURCE , AND RESOURCE NAME) after inserting 38,880 records.
    Is it is the Batch Size or memory Problem .. Please help..

    Thanks
    Reply With Quote Reply With Quote
  2. Feb 23rd, 2009, 12:39 PM #2
    Dave Syer
    Dave Syer is offline Senior Member
    Join Date
    Jun 2005
    Posts
    4,232

    Default

    What's the commitInterval? Maybe the DB connection / session timed out?
    Reply With Quote Reply With Quote
  3. Feb 23rd, 2009, 01:17 PM #3
    adish1234
    adish1234 is offline Member
    Join Date
    Jan 2009
    Posts
    33

    Default

    Thanks Dave . It was DB Problem...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules