Results 1 to 2 of 2

Thread: STMM and sorts

  1. #1
    Join Date
    Jun 2006
    Posts
    7

    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

    Sheapthres=0

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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
  •