Feb 23rd, 2009, 10:04 AM
Batch Program giving error after inserting 38,000 records
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..
Feb 23rd, 2009, 12:39 PM
What's the commitInterval? Maybe the DB connection / session timed out?
Feb 23rd, 2009, 01:17 PM
Thanks Dave . It was DB Problem...