Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: Question on data placement re Raid10 array

    Running DB2 8.2 on AIX5.2

    When a new application was installed, a consultant recommended that
    large tablespaces be defined with just one container, given that the
    container was striped into a raid10 array of discs.

    There are 2 or 3 other heavy hit tablespaces that share that array.

    In this type of raid10 environment, is there any performance advantage
    to be gained by breaking up a heavy hit tablespace into separate
    containers onto separate hdisks in that array?

    Have checked a number of resources .i.e Database Performace Tuning on
    AIX.

    Is that the best resource possible for the data placement aspect of
    tuning in reagrds to Raid arrays?

    Thanks in advance.
    Gerry

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by SnowCrash7
    In this type of raid10 environment, is there any performance advantage
    to be gained by breaking up a heavy hit tablespace into separate
    containers onto separate hdisks in that array?
    Not likely.

    How did you determine that it's the physical layout of containers that impacts the performance of your system?

  3. #3
    Join Date
    Mar 2004
    Posts
    55

    Got it

    Quote Originally Posted by n_i
    Not likely.

    How did you determine that it's the physical layout of containers that impacts the performance of your system?

    When we would get reports of slow performance we noticed ceretain in topas that certain hdiscs were getting slammed. IBM just replied that there is no performance gain to be had by going to multiple containers on a raid 10 and recommended a REdbook..DB2 Performance Guide for OLTP that I am going through now.

Posting Permissions

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