Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: -904 resource limit was exceeded

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2005
    Posts
    4

    Hi

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •