Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Location
    Pa.
    Posts
    10

    Unanswered: AIX AIO Servers for DB2 i/o improvement

    Hello, Has anyone used AIX servers to improve DB2 ? I have read conflicting material on this subject.
    Thanks
    George

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Yes we have used it. recommended settings are
    MaxServers The lower of 10 * number of disks or 10 times the number of processors in the machine.
    MinServers MaxServers /2.

    You could start with these values and by monitoring AIO usage, tweak those settings. You also have to properly configure numioservers, pagecleaners, and sync up your extent size, maxpgahead etc. Also use blocks in your bufferpools and proper filecache %.
    mota

  3. #3
    Join Date
    Feb 2006
    Location
    Pa.
    Posts
    10
    I have used this in a large oracle environment(35 db's) p570/64gb real, shark,san tech and have seen the wait on I/O drop tremendously. Is this what you have observed on your DB2 server ? If not, what did you measure before and after to gauge improvement ?
    Thanks,
    George

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    aioservers are not optional, i think since V8. db2 will not start without aioservers being available.

    The recommendation from dbamota is similar to what we used to decide how many to make available. Keep in mind that aioservers start as needed.

Posting Permissions

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