Raw devices

Troels Arvin

Sorry if this is a FAQ.

On AIX 5.3, running DB2, storing data on a SAN with various RAIDs:
Are raw devices really relevant nowadays? What performance gains are to be
expected, all things equal?

--
Troels Arvin

Jan 8 '07 #1

Subscribe Post Reply

2241

Mark A

"Troels Arvin" <tr****@arvin.dkwrote in message
news:en**********@news.net.uni-c.dk...

Sorry if this is a FAQ.

On AIX 5.3, running DB2, storing data on a SAN with various RAIDs:
Are raw devices really relevant nowadays? What performance gains are to be
expected, all things equal?
--
Troels Arvin

Given that servers today have a lot more memory (and enable use of larger
DB2 buffer pools), raw devices are less relevant than before. They never had
much of an effect on OLTP applications where queries accessed data via
indexes (unless the table is small).

If you have large data warehouses with queries that do frequent table scans,
raw devices may be justified. Otherwise, you will probably not see much of a
difference.

Jan 9 '07 #2

tsmithnj

With DIO and NO FILE SYSTEM CACHING, they are practically irrelevent.

Mark A wrote:

"Troels Arvin" <tr****@arvin.dkwrote in message
news:en**********@news.net.uni-c.dk...
Sorry if this is a FAQ.

On AIX 5.3, running DB2, storing data on a SAN with various RAIDs:
Are raw devices really relevant nowadays? What performance gains are to be
expected, all things equal?
--
Troels Arvin

Given that servers today have a lot more memory (and enable use of larger
DB2 buffer pools), raw devices are less relevant than before. They never had
much of an effect on OLTP applications where queries accessed data via
indexes (unless the table is small).

If you have large data warehouses with queries that do frequent table scans,
raw devices may be justified. Otherwise, you will probably not see much of a
difference.

Jan 10 '07 #3

by: A. Fuentes | last post by:

Fellow Oracle Netters: I have the following problem: Enviroment: Oracle9i/AIX5.2/Veritas vxvm I am trying to create an Oracle database using RAW devices UNDER the Veritas vxvm.(Veritas...

Oracle Database

DBCA and RAW devices

by: Spiros | last post by:

Hello, I am trying to create a database using DBCA on both raw devices and UFS. I want my tablespaces and redo log files on raw devices, e.g /dev/vx/rdsk/system_raw_dev, and my control files on...

Oracle Database

Medical Devices

by: Bud Cookson | last post by:

We are in the process of developing the requirements for a new medical device and the question has been raised about what development tool/language should be used. The application(s) will be...

.NET Framework

Mobile devices

by: Michael Wimmer | last post by:

Hi, could anybody tell me what the current state of technology for mobile devices is? I have seen so far that there is cHTML (imode), wml, xhtml (full or basic) to be used for mobile devices....

HTML / CSS

The old raw devices chestnut.

by: Jim Smith | last post by:

Note the cross-posting - but no flame wars please. This question was prompted by a thread on the a postgres mailing list during which someone (Gregory Williamson) claimed <quote> raw devices,...

DB2 Database

Enumerating devices: disabled devices not shown

by: gewe | last post by:

I am using the following code to enumerate devices on the local computer: ManagementObjectSearcher searcher = new ManagementObjectSearcher("SELECT * from Win32_PnPEntity");...

C# / C Sharp

How to discover devices on network

by: stacy | last post by:

I am developing an application that must look out over TCP on an ethernet connection to locate our proprietary devices. The Web application and the devices are communicating over ethernet with...

.NET Framework

No active mixer devices and CD drive playing up

by: =?Utf-8?B?ZGF2ZS5oYXJkeQ==?= | last post by:

Hi, there have been loads of posts about this problem on loads of forums and I have tried everything suggested (except the stuff Iâ€™m not comfortable with like deleting drivers and reg. edits). ...

.NET Framework

Disabling Devices by calling Setupapi.dll, or Converting Devcon to C#

by: jwgoerlich | last post by:

Hello group, My C# app needs to disable and re-enable devices. I did some research and found that I could do exactly what I wanted by using Devcon from the DDK. Devcon disable =net...

C# / C Sharp

Web pages for mobile devices

by: cj2 | last post by:

I saw a MS demo a few years back where they developed a web page and the software automatically rendered it for different devices. Is this what I'm looking for? http://www.asp.net/mobile/ ...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics