Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    4

    Unanswered: Performance tuning on an existing package

    I have a package that compiles with 0 errors however there are a lot of procedures performing redundant opeartions. how can I tune the package .please help

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    What is the indication that "tuning" is needed?

    If you explain what all this does and which are the redundant pieces, someone may have a suggestion.

    With what you have posted, there is little to work with.
    Last edited by papadi; 10-25-12 at 16:29.

  3. #3
    Join Date
    Sep 2012
    Posts
    4
    My question is that can we find a explain plan for a a package ?
    to see where the cost is more ?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by marshella View Post
    My question is that can we find a explain plan for a a package ?
    Use db2exfmt if the package was bound with the EXPLAIN YES option.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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