Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

    Unanswered: extensize for system temporary tablespaces

    How do you decide what EXTENTSIZE should be set to for SYSTEM TEMPORARY TABLESPACES (SMS)?

    Based on:
    - RAID strip/stripe size
    - whether it's OLTP (smaller) or DW (larger) or mixed (?)
    - some other approach


    Thanks.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Any suggestions? Should it be any different from how you set EXTENTSIZE for permanent data/index tablespaces?
    Last edited by db2girl; 09-26-11 at 22:46.

Posting Permissions

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