var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: -904 resource limit was exceeded
Can any one help me to problem reslove -904 the problme,
While i am tying to execute the query,
LEFT OUTER JOIN QNIMCMA.TIM_CD_CUSTOMER CDC
ON TMP.CIDN = CDC.CIDN
i am getting following error -
Unsuccessful execution because DB2 resource limit was exceeded. Resource name =
ASUTIME, limit = 000000000003.
please direct, me to overcome this problem,
thanks and regards,
It is -904 or -905 ????
Your DBA would have limited the CPU seconds permitted for each SQL statement (or ASUTIME) ... check with the DBA team ..
If you can live without the ORDER BY Clause, your statement should perform much better (and may fall within your ASUTIME limit)
Visit the new-look IDUG Website
, register to gain access to the excellent content.
Sathyaram, thanks for your response,
Sorry for typo error the error i 'm getting is -905, by contacting DBA group, i shor it out the issue
Thanks and Regards