Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    VA
    Posts
    14

    Arrow Unanswered: Setting DFT_QUERYOPT

    I plan to adjust the setting for DFT_QUERYOPT and would like to find out what other things I need to do after the parameter is changed.

    Are these steps necessary? Am I missing anything else?
    1. Recycle instance
    2. Run db2rbind
    3. Execute FLUSH PACKAGE CACHE

    Please advise and thank you in advance for your assistance.

    Clara

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    pray......
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2004
    Location
    VA
    Posts
    14
    Yes, prayers certainly helped : )

    Thank you and I was able to resolve the temp tablespace full error after adjusting the DFT_QUERYOPT cfg parameter.

    Thanks again!

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by clara View Post
    2. Run db2rbind
    No use. The queryopt value cannot be overruled. You will have to bind again, rebind of existing packages will have no effect.

Posting Permissions

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