Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    6

    Smile Unanswered: EXTENTSIZE - multiple of RAID stripe size

    Usually, EXTENTSIZE is suggested to be multiple of number of containers, in case of RAID, it is suggested to be multiple of RAID stripe size, here my question is when we say that "EXTENTSIZE - multiple of RAID stripe size" is it assumed that each table space has single container?

    For instance, I have RAID 5 with stripe size 4, I have identified 7 table-spaces in all. Shall I have single container for all of them with EXTENTSIZE 4 * 16k ... ?

    Any comments for performance...

    thanks
    Amol

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by amol17
    RAID 5 with stripe size 4
    That does not sound right.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2009
    Posts
    6
    might be I have not exact stripe size with me, what is the usual stripe size for RAID 5? Am sure that I have RAID 5 with me.

    Any ways, my original doubts was(let me write more abt it),

    shall we have more than two containers on RAID?

    if so what should be the extent size?

    what should be the extentsize if container is 1?

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    The extent size will also depend on whether you have a datawarehouse environment or an OLTP environment......

    In a data warehouse environment it makes sense to have a larger extent size since it would involve less reads between disk and bufferpool..... however in an OLTP for large extent size you would also end up reading unnecessary data and hence smaller the better....
    IBM Certified Database Associate, DB2 9 for LUW

Posting Permissions

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