473,466 Members | 1,430 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

storing DMS on RAID

When creating a DMS tablespace in a container on a logical disk that is in
fact mapped to a RAID 5 how much performance benefit does DB2 for LUW
get from a DMS tablespace? With such an architecture, contiguous placement
of disk blocks and prefetching has a different behavior than when a single
physical device is used.

I'm more interested in results from rigorous measurements than I am
intuitive feeling, subjective observations, off-the-cuff expectations, etc.,
as between my own and others I have enough of these to go around for now.

My own feeling is that the contiguous placement of DMS still helps, but
not as much as with a logical device that is mapped 1-1 to a physical disk.

Thoughts?

Joseph
Nov 12 '05 #1
0 1164

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Bernie | last post by:
I will be doing some performance testing on financial application next month. Without going into a lot of details, I suspect I will have a potential bottleneck when writing to the log file. My...
5
by: Don Vaillancourt | last post by:
I'm building a system when one can upload a document to the website. I will be storing the document on the hard-drive for quick/easy access, but I was also thinking of storing it in an existing...
8
by: Joseph | last post by:
I've been thinking about the benefits or lack thereof of deploying DMS tablespaces for RAID, say RAID 5. The point of DMS is to get reasonable size extents of contiguous disk space so that minimal...
4
by: esmith2112 | last post by:
We replaced an aging system with a newer (faster 4-way) and presumably better system. Perfomance for most queries has improved as one would expect. However, we're getting slaughtered on performance...
13
by: Dave | last post by:
RAID 5 beats RAID 10 Can I get some feedback on these results? We were having some serious IO issues according to PerfMon so I really pushed for RAID 10. The results are not what I expected. ...
1
by: serge | last post by:
I have a database that is around 2 to 4 GB. If I were to estimate some numbers like 4x growth or even 10x, the database size could reach 40GB. The new server will be running SQL Server 2005. I...
17
by: boa | last post by:
I'm currently planning disk layouts and use for a new version of our database. The current version has all data and indexes in the default filegroup, placed on one big raid-5 array(6 drives) along...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
6
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 Not trying to start a flame war or anything, but does anyone have an opinion regarding whether to use Raid 5 or Raid 10 w/ DB2? We have an EMC SAN (a Clariion...
1
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...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.