467,185 Members | 1,242 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

Concurrent I/O on Aix: When?

Anybody know when DB2 is going to support Concurrent I/O on Aix... I
heard it was coming but I don't know when?

Thanks
Scott
Nov 12 '05 #1
  • viewed: 4031
Share:
2 Replies
Ian
sp******@yahoo.com wrote:
Anybody know when DB2 is going to support Concurrent I/O on Aix... I
heard it was coming but I don't know when?


It's definitely there in Stinger -- where you can create/alter
tablespaces and add a keyword 'no filesystem caching' to bypass
the filesystem cache.

I think that if you mount the filesystem with concurrent IO
enabled (i.e. mount -o cio /yourfs) DB2 will still work fine, but
I'm not 100% on that.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
Well I know that currently there is regsitry variable that supports
direct IO on AIX and is a supported configuration by db2 support. My
question about the file system no cache tablespace option would be on
AIX does that mean DB2 is going to use DIRECT I/O or Concurrent
I/O(which is DIRECT I/O w shared read locks).

Also does anyone know if I mount my filesystems with Concurrent I/O
options is that currently a supported configuration on AIX for db2? I
will probably have to call but if any one knows that would be great...

Thanks,
Scott
Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@corp.newsgroups.com>...
sp******@yahoo.com wrote:
Anybody know when DB2 is going to support Concurrent I/O on Aix... I
heard it was coming but I don't know when?


It's definitely there in Stinger -- where you can create/alter
tablespaces and add a keyword 'no filesystem caching' to bypass
the filesystem cache.

I think that if you mount the filesystem with concurrent IO
enabled (i.e. mount -o cio /yourfs) DB2 will still work fine, but
I'm not 100% on that.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gardner Pomper | last post: by
12 posts views Thread by Jean-Marc Blaise | last post: by
4 posts views Thread by Demetris | last post: by
4 posts views Thread by Yasaswi Pulavarti | last post: by
6 posts views Thread by chrisg@warpspeed.com.au | last post: by
6 posts views Thread by Troels Arvin | last post: by
9 posts views Thread by Randy.Galbraith@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.