Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    50

    Unanswered: Sortheap / Tempspace 32 k page

    Hi

    I have a tablespace with 32 k pages.

    - Is it necessary to have a tempspace with 32 k pages too, or can I say: if my sortheap is big enough, I don't need a tempspace with 32 k because I will just have piped sorts, so the 32 k tempspace will not be used ?

    Marc

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    If you have a tablespace with a pagesize of 32K you will need a tempspace with a pagesize of 32k and a corresponding bufferpool as well.

  3. #3
    Join Date
    Jul 2003
    Posts
    50
    But if my sortheap is big enough, I don't need a big temspace, isn't it ?











    Originally posted by cchattoraj
    If you have a tablespace with a pagesize of 32K you will need a tempspace with a pagesize of 32k and a corresponding bufferpool as well.

Posting Permissions

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