Announcement Announcement Module
Collapse
No announcement yet.
Batch Program giving error after inserting 38,000 records Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    What's the commitInterval? Maybe the DB connection / session timed out?

    Comment


    • #3
      Thanks Dave . It was DB Problem...

      Comment

      Working...
      X