Page 1 of 1

Error Loading Data into the Table.

Posted: Mon Jan 31, 2011 12:11 pm
by vvsaucse
I was trying to load data into a DB2 table when i encountered the below error message. I understand this could possibly be DB Connectivity issue, but not sure why this is coming up now. The volume of data is around 45 Million and almost the same as it has successfully run previously.

SQL_ERROR; SQLSTATE = 40003; NativeErrorCode = -1224; Message = [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated your particular request due to a problem with your request. SQLSTATE=55032.

Posted: Mon Jan 31, 2011 3:58 pm
by ray.wurlod
DB2 is rejecting your connection requests because it says it is too busy at that time. Have a word with your DBA about scheduling.