resource limit being exceeded

reddysrc · Post by **reddysrc** » Wed Apr 02, 2008 8:46 am

HI Experts,

i am running a job using on AIX shell script.

DS v8.0, AIX .
job desc : DB2 to Hash file .... data retrived from DB2 then loading into hash file , there are no other stages.

job is running for few secs then aborted with the following error s :

SPM016FilterDuplicatesHash..Src_OLETMSTR: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000031" CPU seconds ("000000300000" service units) derived from "SYSIBM.DSNRLST01". SQLSTATE=57014

DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT B.TDLINX_STORE_CODE

it would be great help for me , any solutions u found .

DSguru2B · Post by **DSguru2B** » Wed Apr 02, 2008 2:55 pm

What happens when you run the same sql from your favour sql tool?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 02, 2008 2:56 pm

The limit is one set in DB2, not one set in DataStage. Discuss with your DBA about increasing the limits, and/or try to create a query that uses fewer resources.