resource limit being exceeded
Posted: 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 .
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 .