Error Loading Data into the Table.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vvsaucse
Participant
Posts: 16
Joined: Thu Aug 27, 2009 11:23 pm
Location: BAngalore

Error Loading Data into the Table.

Post 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.
Subbu
TCS BAngalore
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”