Results 1 to 2 of 2

Thread: STMM and sorts

  1. #1
    Join Date
    Jun 2006

    Unanswered: STMM and sorts

    I have the following scenario.STMM is off and sheapthres is set to 0.Is it true that sorts will take place in shared memory although STMM is off??Or is it that STMM has to be turned on for that to take into effect

    STMM = OFF


  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    Yes, you're correct. All sorts are in shared memory (db memory) if sheapthres=0. I believe this is regardless of what STMM is set to.
    Last edited by db2girl; 03-01-09 at 14:18.

Posting Permissions

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