Hi, I can't provide you with raw vs filesystem benchmarks as I've only ever used one or the other, never side by side, but I don't think there is more administrative overhead with raw devices.
There is more to do in setting the tablespaces up and ensuring permissions are correct. Also you cannot get space information on the lvs other than through db2, but given that this is preallocated DMS space anyway, it doesn't make much difference. Given that it's generally thought raw devices are faster I would definitely check out implementing them. Cheers, Mark Savin DBA Euler Trade Indemnity > -----Original Message----- > From: Scott Saunders [SMTP:[EMAIL PROTECTED]] > Sent: 10 January 2002 14:40 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [DB2EUG] FW: DB2EUG: Benchmarks for Raw Devices Vs. File > System Performanc e > > Arnoud; > Here is my original question. I copied the list in case it was a > temporary > problem preventing me from posting yesterday. > > Many thanks to you for running this list for us. We all really appreciate > what you have done for us. > > Scott Saunders > > > -----Original Message----- > > From: Scott Saunders > > Sent: Tuesday, January 08, 2002 6:02 AM > > To: DB2EUG (E-mail) > > Subject: DB2EUG: Benchmarks for Raw Devices Vs. File System > > Performance > > > > Hello; > > Does anyone have any actual comparisons of performance for these storage > > options? The manuals indicate that raw devices are faster. Can anyone > > confirm this and is it enough faster to justify the additional > > administrative effort in your opinion? > > > > Regards, > > Scott Saunders > > Siebel Systems, Inc. > > > > Opinions expressed are my own and not those of my employer. > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
