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

    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
    Posts
    4,292
    Provided Answers: 5
    You have to do the BIND again to get a new queryopt.

    Andy

Posting Permissions

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