See DB2 Magazine article "Cut Query Times in Half" Q4, 2001, Figure 2, DMS vs SMS, for a performance benchmark that was completed on DB2 V7.1 AIX: http://www.db2mag.com/db_area/archives/2001/q4/hayes.shtml#fig2
This particular machine and performance test showed measurable CPU and SORT time savings by using DMS, which is important if your machine is CPU bound, as most DB2 UDB applications tend to be. During one recent analysis of a Siebel DB2 AIX implementation, we found that over 20% of all CPU time was consumed by one SQL statement. Anyway, hopefully you will find the entire article helpful. Links to additional DB2 UDB performance articles can be found at: http://www.breakthroughdb2.com/resources.shtml http://www.breakthroughdb2.com/siebel/ Regards, Scott Hayes DGI Achieving Breakthrough Performance Results for IBM DB2 UDB http://www.BreakthroughDB2.com/ROI/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Saunders Sent: Thursday, January 10, 2002 9:40 AM 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]
