Re: DB2 direct i/o question

2010-08-01 Thread Shockley, Gerard C
We are moving away from DB2 - to Oracle LoZ. Gerard -Original Message- From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Barton Robinson Sent: Friday, July 30, 2010 2:57 PM To: LINUX-390@vm.marist.edu Subject: Re: DB2 direct i/o question But, Oracle is VERY virtual

Re: DB2 direct i/o question

2010-07-30 Thread Klaus Bergmann
On Mon, 26 Jul 2010 10:17:51 -0500 Marcy Cortes wrote After reading some more, it turns out you cannot do direct i/o on linux for z if you are using ECKD dasd, only FCP. This is a DB2 limitiation which others, e.g. Oracle on zLinux, do not have. Klaus Bergmann

Re: DB2 direct i/o question

2010-07-30 Thread Marcy Cortes
Klaus wrote: This is a DB2 limitiation which others, e.g. Oracle on zLinux, do not have. Yes. What is up with that IBM? Does this make Oracle a better fit on Linux on z than DB2? Marcy -- For LINUX-390 subscribe / signoff

Re: DB2 direct i/o question

2010-07-30 Thread Mark Post
On 7/30/2010 at 12:03 PM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: Does this make Oracle a better fit on Linux on z than DB2? That depends on how much you care about newer versions being certified sometime within your life time. Mark Post

Re: DB2 direct i/o question

2010-07-30 Thread Marcy Cortes
Mark wrote: That depends on how much you care about newer versions being certified sometime within your life time. Very good point. That's a concern too. Marcy -- For LINUX-390 subscribe / signoff / archive access

Re: DB2 direct i/o question

2010-07-30 Thread Barton Robinson
But, Oracle is VERY virtual friendly, and DB2 is VERY virtual HOSTILE. From a system performance perspective, I REALLY LIKE Oracle. Mark Post wrote: On 7/30/2010 at 12:03 PM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: Does this make Oracle a better fit on Linux on z than DB2? That

Re: DB2 direct i/o question

2010-07-27 Thread Rob van der Heij
On Tue, Jul 27, 2010 at 2:24 AM, Shane G ibm-m...@tpg.com.au wrote: Short answer, no. On Tue, Jul 27th, 2010 at 1:17 AM, Marcy Cortes wrote: Is there a way to limit the amount of memory used for page cache? Longer answer: only by not giving Linux a lot of memory in the first place... by

Re: DB2 direct i/o question

2010-07-26 Thread Marcy Cortes
immediately by reply e-mail and delete this message. Thank you for your cooperation. -Original Message- From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Rob van der Heij Sent: Saturday, July 24, 2010 1:58 AM To: LINUX-390@vm.marist.edu Subject: Re: [LINUX-390] DB2 direct i/o

Re: DB2 direct i/o question

2010-07-26 Thread Shane G
Short answer, no. This was discussed earlier in the year - see: http://www.mail-archive.com/linux-390@vm.marist.edu/msg55911.html Shane ... On Tue, Jul 27th, 2010 at 1:17 AM, Marcy Cortes wrote: Is there a way to limit the amount of memory used for page cache?

Re: DB2 direct i/o question

2010-07-24 Thread Rob van der Heij
On Sat, Jul 24, 2010 at 4:28 AM, Shane G ibm-m...@tpg.com.au wrote: Does this imply that the best setting for Linux on z is to use the FILE SYSTEM CACHING (Direct i/o disabled)? Now that DB2 can, that's probably a good motivation for doing measurements... I have mixed feelings about their

DB2 direct i/o question

2010-07-23 Thread Marcy Cortes
From the DB2 9.5 doc Prior to Version 9.5, the keyword FILE SYSTEM CACHING was implied if neither NO FILE SYSTEM CACHING nor FILE SYSTEM CACHING was specified. With Version 9.5, if neither keyword is specified, the default, NO FILE SYSTEM CACHING, is used. This change affects only newly

Re: DB2 direct i/o question

2010-07-23 Thread Shane G
On Sat, Jul 24th, 2010 at 10:20 AM, Marcy Cortes wrote: Does this imply that the best setting for Linux on z is to use the FILE SYSTEM CACHING (Direct i/o disabled)? I won't presume to be able to answer that, but I will observe that Linus has made some very harsh comments about database