Re: Larry Ellison comments on Microsoft's benchmark

In Sybase ASE 12, it provides options for slow safe file-system and fast un-safe file-system. Are there any similiar options in DB2 V7.1?

In comp.databases.sybase Blair Kenneth Adamache <adamache_at_ca.ibm.com> wrote: > Raw devices are supported by all the major databases. DB2 supports raw devices for user data and for > logging.  

> Norris wrote:  

>> In comp.databases.sybase Anthony Mandic <amandic@_start.com.au> wrote:
>> > Norris wrote:
 

>> >> In oracle, in case of data/index corruption, you can use Export/Import to resolve the optimization
>> >> and defragmentation.
 

>> > Export/Import to resolve optimization and defragmentation. You've got to be
>> > kidding me!
 

>> >> Usually, you do it less frequent than DBCC because Oracle performs the
>> >> database consistency check automatically for every update.
 

>> > For every update? That's got to slow things way down!
>>
>> In oracle, if you want to speed up the I/O operations, you can use raw device rather than file system.

-- 
http://www.cooper.com.hk