Hi users,

Can any one help me to problem reslove -904 the problme,

While i am tying to execute the query,

SELECT DISTINCT
TMP.MOVEMENT_TYPE,
TMP.MOVEMENT_DT,
TMP.CIDN,
TMP.TO_OWN,
TMP.FR_OWN,
TMP.TO_BUS_CLSFCN_CD,
TMP.FR_BUS_CLSFCN_CD,
TMP.USER_ID,
CDC.CUST_ROLE_NAME,
CDC.CUST_GIV_NMS,
CDC.CUST_CRTSY_TTL,
CDC.PRIME_PTFL_CD
FROM
QNIMCMA.TIM_CD_AUX_CUSTMVE TMP
LEFT OUTER JOIN QNIMCMA.TIM_CD_CUSTOMER CDC
ON TMP.CIDN = CDC.CIDN
ORDER BY
TMP.MOVEMENT_DT,
TMP.CIDN,
TMP.TO_OWN,
TMP.FR_OWN

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,
Angurj Rathinasamy.

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)

HTH

Sathyaram

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
Anguraj Rathinasamy