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 .
resource limit being exceeded
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.