Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012

    Unanswered: Change default Reopt value for all applications?

    I'm using a DB2 9.7 on AIX and want to change the REOPT parameter for all connecting clients to "REOPT ONCE" (from the default "REOPT NONE"). As far as I read the documentation, I can only set that on client side (either by setting the value or by setting the default package name to NULLIDR1). Is there any more elegant possibility? I also thought about perhaps optimization profiles but that seems to be bound to specific statements and not all...

  2. #2
    Join Date
    Nov 2011

Posting Permissions

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