473,405 Members | 2,294 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

"Devices"

What is a "Device" in creating DMS tablespaces where the storage
subsystem is RAID 0 3 or 5 0, ie, heavily striped. I'm referring to an
array of 6 disks. One or several logical volumes can be created. Are
they handled by DB2 (8.2 Win WSE) as one device, or can I configure for
more than one device?

Nov 12 '05 #1
2 1405
Ian
Stanley Sinclair wrote:
What is a "Device" in creating DMS tablespaces where the storage
subsystem is RAID 0 3 or 5 0, ie, heavily striped. I'm referring to an
array of 6 disks. One or several logical volumes can be created. Are
they handled by DB2 (8.2 Win WSE) as one device, or can I configure for
more than one device?


Search the DB2 documentation for DB2_PARALLEL_IO - this parameter tells
DB2 that the container(s) for a tablespace exist on a RAID device and
allows DB2 to submit multiple IO requests in parallel to a single
container.

Nov 12 '05 #2
Stanley, it's 10:45 and I don't have anything better than surf!!!!
No, I'm going away tomorrow and I was just clearing stuff.

Devices are "raw devices" as opposed to "cooked devices" meaning formatted.
In Windoze, a path would look like D:\foo\bar
With Windoze 2000
1) If the whole drive is not partitioned:
Use \\.\PhysicalDrive x convention.
2) If drive is partitionned but none formatted
Use \\.\x convention for your contasiner
You're "raided" so handle your tablespaces as 1 container per array as
opposed to one container per physical read/write mechanism.

RAID 5 , 5 disks. Stripe 64K
Tablespace: Extent 16 pages of 4 k
Prefetchsize: 4 devices * 16 pages = 64k
In RAID 5, you loose 1/5th of each device for parity.

You should also look at Windows Globally Unique Identifiers GUID
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Stanley Sinclair" <st*************@bellsouth.net> a écrit dans le message
de news: 11*********************@o13g2000cwo.googlegroups.c om...
What is a "Device" in creating DMS tablespaces where the storage
subsystem is RAID 0 3 or 5 0, ie, heavily striped. I'm referring to an
array of 6 disks. One or several logical volumes can be created. Are
they handled by DB2 (8.2 Win WSE) as one device, or can I configure for
more than one device?


Nov 12 '05 #3

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

Similar topics

0
by: asj | last post by:
luke: BORRRRRRRRING......the most interesting initiatives are happening on the client side - in small wireless devices such as cellphones and smartphones, where J2ME has become the de facto...
5
by: kmunderwood | last post by:
I am trying to combine "if match=" and "when test" I am a newbie, and have made both work separately, but I can not seem to combine them. This is my xml("index.xml")page(I can not change this,...
17
by: Geoff Cox | last post by:
Hello, I am trying to have 1. web pages in large font 2. web pages with smaller font for printing I am using <link rel="stylesheet" media="print" type="text/css"
99
by: Jim Hubbard | last post by:
It seems that Microsoft not only does not need the classic Visual Basic developer army (the largest army of developers the world has ever seen), but now they don't need ANY Windows developer at a...
5
by: Patrick Sannes | last post by:
Hi, At this moment I have one large sourcecode file and want to seperate it into multiple files. When I do so, the app crash after he created 6389 (156794880 bytes total) source files with the...
0
by: raludamian | last post by:
Hello! I'm trying to develop a GIS mapping software on smart devices (Pocket PC) using VS 2005, C#. I need to use a library that was written in C++. Being open source I compiled the C++ code...
8
by: Scott M. | last post by:
I've tried following the simple instructions to be able to use MyServices within C#...Add a project reference to Microsoft.VisualBasic.dll and add: "using Microsoft.VisualBasic.MyServices;" to the...
350
by: Lloyd Bonafide | last post by:
I followed a link to James Kanze's web site in another thread and was surprised to read this comment by a link to a GC: "I can't imagine writing C++ without it" How many of you c.l.c++'ers use...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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...
0
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
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,...

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.