Pinned topic db2 error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
hai iam unloding the data with simple select query then i got the error code -905 with sqlstate 57014.the reason is ASU TIME exceed.can u plz tell me how to resove this error in detailed manner.
Updated on 2012-06-12T14:03:30Z at 2012-06-12T14:03:30Z by SystemAdmin
SystemAdmin 110000D4XK3105 Posts
Re: db2 error2012-06-12T14:03:30ZThis is the accepted answer. This is the accepted answer.DB2 has a component call resource limit facility (RLF)
this component limits the amount of time that each query might consume
if you are not the dba, you should consult your dba about this error, he should be able to tell you what to do (either run your unload in a different time when the rlf is not active or run it with a different user / different program)
if you are the dba, you can just stop the rlf completely or change the policy so that your user will not be limited at all