Results 1 to 2 of 2

Thread: sortheap

  1. #1
    Join Date
    Aug 2009

    Unanswered: sortheap

    What happens when SORTHEAP is AUTOMATIC and STMM is OFF? What is the value of SORTHEAP in this case? Will DB2 increase/decrease SORTHEAP in this case?

  2. #2
    Join Date
    Aug 2011
    Straight from Infocenter:

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

    Automatic tuning of this configuration parameter will only occur when self tuning memory is enabled for the database (the self_tuning_mem configuration parameter is set to ON.)

Posting Permissions

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