[U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem
We have been dealing with performance issues with our system and it seems to be I/O bound when we look at the stats using nmon and topas. We have our SAN engineers looking at it from the backend to make sure that it is tuned well, plus IBM looking from an AIX point of view. One thing I was asked is does the database have the ability to take advantage of AIO / CIO / DIO . From what I remember from the internals classes (taken over 10 years ago) for the U2 products they take advantage of the generic filesystem and are not compiled to use any filesystem variants. Is this still a true statement today? Thanks in advance for all feedback Daniel Goble Unidata DBA INTERLINE BRANDS, INC. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem
Yes. UniData uses standard C runtime calls for file system file access. In general, you want to tune your SAN to optimize for random access. RAID0+1 with small (64K range) stripe size. Lots of small disk vs a few large disks. [AD] Rocket Professional Services are an excellent resource for UniData system tuning. Regards, Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, May 10, 2011 9:23 AM To: U2 Users List Subject: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem We have been dealing with performance issues with our system and it seems to be I/O bound when we look at the stats using nmon and topas. We have our SAN engineers looking at it from the backend to make sure that it is tuned well, plus IBM looking from an AIX point of view. One thing I was asked is does the database have the ability to take advantage of AIO / CIO / DIO . From what I remember from the internals classes (taken over 10 years ago) for the U2 products they take advantage of the generic filesystem and are not compiled to use any filesystem variants. Is this still a true statement today? Thanks in advance for all feedback Daniel Goble Unidata DBA INTERLINE BRANDS, INC. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem
Thanks Wally for confirming what I thought. Much appreciated, -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, May 10, 2011 11:31 AM To: U2 Users List Subject: Re: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem Yes. UniData uses standard C runtime calls for file system file access. In general, you want to tune your SAN to optimize for random access. RAID0+1 with small (64K range) stripe size. Lots of small disk vs a few large disks. [AD] Rocket Professional Services are an excellent resource for UniData system tuning. Regards, Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, May 10, 2011 9:23 AM To: U2 Users List Subject: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem We have been dealing with performance issues with our system and it seems to be I/O bound when we look at the stats using nmon and topas. We have our SAN engineers looking at it from the backend to make sure that it is tuned well, plus IBM looking from an AIX point of view. One thing I was asked is does the database have the ability to take advantage of AIO / CIO / DIO . From what I remember from the internals classes (taken over 10 years ago) for the U2 products they take advantage of the generic filesystem and are not compiled to use any filesystem variants. Is this still a true statement today? Thanks in advance for all feedback Daniel Goble Unidata DBA INTERLINE BRANDS, INC. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
