Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Zoetermeer, Holland

    Unanswered: packages bound with QUERYOPT 2 :(

    Just found out that the QUERYOPT was configured with 2. I changed the DFT_QUERYOPT and flshed the package cache and ran db2rbind.
    Now I know.... a rebind does not take the QUERYOPT from DFT_QUERYOPT so my packages are still using the (too low) value of 2.
    Is there a way to rebind and increase the QUERYOPT value? I am using V8.2 on aix.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You have to do the BIND again to get a new queryopt.


Posting Permissions

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