Fatal: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful executi

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
sreddy
Participant
Posts: 144
Joined: Sun Oct 21, 2007 9:13 am

Fatal: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful executi

Post by sreddy »

Hi

While i am reading data from Mainframe table using DB2API stage. I am getting this Fatal Error.

Please respond with valuable information. I guess this is happing because of operation log full.

-------------------------------------------------------------------------------

MF_IML_Extract,0: Fatal Error: Fatal: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000095" CPU seconds ("000001738800" service units) derived from "SYSIBM.DSNRLST01". SQLSTATE=57014
SQLFetch: Error retrieving results from server.
sreddy
Participant
Posts: 144
Joined: Sun Oct 21, 2007 9:13 am

Post by sreddy »

Hi

I found this message in IBM site.

57014 Processing was cancelled due to an interrupt. The execution of a query is canceled due to user inter
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It may be that the number of service units you've contracted to buy has been exceeded.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply