Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008

    Unanswered: Issue with stored procedure

    Hi all,

    I am trying to execute a stored procedure and it executes until a certain point and stops at a certain query.
    (How we know it stucks at a certain query -- we have logging into a table after every query is executed in the stored proc)

    When we run the query (which runs slow) by itself it completes in 38 secs.

    So anyone have any ideas what could be the issue?

    DB2V9 on RHL

    Thank you all in advance

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You need to generate an access plan for the Stored procedure and make sure that it is what you are get for the standalone query. If they are different,
    then maybe rebinding the package(s) of the SP will fix the issue.


  3. #3
    Join Date
    Jul 2008
    Thanks Andy,

    You were right the plan was different for both standalone query and the stored procedure.

Posting Permissions

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