I want to know one thing, what is best design for tablespace
containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
need to create a 64GB tablespace on this EMC RAID. Which of the
following is the best way from performance perspective?
(1) 1 64GB container
(2) 4 * 16GB containers
(3) 8 * 8GB containers
4  3556 
Your RAID architecture (0+1) presents these disks to the system as a
single disk drive containing four physical drives using striping to
spread the data on them.
Which do you think is better - a single container on a drive or eight
small containers on a drive? I'd go with a single large container to
avoid seeks switching between containers. If read access is your primary
concern; then the +1 RAID should facilitate using two containers. In
this case; you would be able to read from both copies concurrently.
Other considerations would be a future need to expand the tablespace and
potential operating system buffering effects of having large files enabled.
The best answer I know of for your question is: it depends on the
workload and performance objectives.
Phil Sherman
duoduo wrote: I want to know one thing, what is best design for tablespace
containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
need to create a 64GB tablespace on this EMC RAID. Which of the
following is the best way from performance perspective?
(1) 1 64GB container
(2) 4 * 16GB containers
(3) 8 * 8GB containers
Thanks, Philip, I really appreciate your comments.
Philip Sherman <ps******@ameri tech.net> wrote in message news:<Ff******* *********@newss vr15.news.prodi gy.com>... Your RAID architecture (0+1) presents these disks to the system as a
single disk drive containing four physical drives using striping to
spread the data on them.
Which do you think is better - a single container on a drive or eight
small containers on a drive? I'd go with a single large container to
avoid seeks switching between containers. If read access is your primary
concern; then the +1 RAID should facilitate using two containers. In
this case; you would be able to read from both copies concurrently.
Other considerations would be a future need to expand the tablespace and
potential operating system buffering effects of having large files enabled.
The best answer I know of for your question is: it depends on the
workload and performance objectives.
Phil Sherman
duoduo wrote: I want to know one thing, what is best design for tablespace
containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
need to create a 64GB tablespace on this EMC RAID. Which of the
following is the best way from performance perspective?
(1) 1 64GB container
(2) 4 * 16GB containers
(3) 8 * 8GB containers
Since you will be using Aix 4 I would only go with your option "(1) 1 64GB
container " if your are certain that it will never be bigger since 64GB file
on Aix 4 would be a "physical" limitation.
"duoduo" <du*********@gm ail.com> wrote in message
news:d3******** *************** ***@posting.goo gle.com... Thanks, Philip, I really appreciate your comments.
Philip Sherman <ps******@ameri tech.net> wrote in message
news:<Ff******* *********@newss vr15.news.prodi gy.com>... Your RAID architecture (0+1) presents these disks to the system as a
single disk drive containing four physical drives using striping to
spread the data on them.
Which do you think is better - a single container on a drive or eight
small containers on a drive? I'd go with a single large container to
avoid seeks switching between containers. If read access is your primary
concern; then the +1 RAID should facilitate using two containers. In
this case; you would be able to read from both copies concurrently.
Other considerations would be a future need to expand the tablespace and
potential operating system buffering effects of having large files
enabled.
The best answer I know of for your question is: it depends on the
workload and performance objectives.
Phil Sherman
duoduo wrote: > I want to know one thing, what is best design for tablespace
> containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
>
> For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
> need to create a 64GB tablespace on this EMC RAID. Which of the
> following is the best way from performance perspective?
>
> (1) 1 64GB container
>
> (2) 4 * 16GB containers
>
> (3) 8 * 8GB containers
Dany, Thanks for your reply.
You are definitely right. JFS on AIX 4 has a 64GB file size
limitation, and I also have a 64GB 4k page size tablespace as well. I
am doing the test to migration the DB2 from 7.2 to 8.1 and AIX 4.3.3
to AIX 5L. Currently I am living on AIX 4.3.3
"Dany" <da******@video tron.ca> wrote in message news:<ci******* **@news1.stadia .fi>... Since you will be using Aix 4 I would only go with your option "(1) 1 64GB
container " if your are certain that it will never be bigger since 64GB file
on Aix 4 would be a "physical" limitation.
"duoduo" <du*********@gm ail.com> wrote in message
news:d3******** *************** ***@posting.goo gle.com... Thanks, Philip, I really appreciate your comments.
Philip Sherman <ps******@ameri tech.net> wrote in message
news:<Ff******* *********@newss vr15.news.prodi gy.com>... Your RAID architecture (0+1) presents these disks to the system as a
single disk drive containing four physical drives using striping to
spread the data on them.
Which do you think is better - a single container on a drive or eight
small containers on a drive? I'd go with a single large container to
avoid seeks switching between containers. If read access is your primary
concern; then the +1 RAID should facilitate using two containers. In
this case; you would be able to read from both copies concurrently.
Other considerations would be a future need to expand the tablespace and
potential operating system buffering effects of having large files
enabled.
The best answer I know of for your question is: it depends on the
workload and performance objectives.
Phil Sherman
duoduo wrote:
> I want to know one thing, what is best design for tablespace
> containers, of course, it is DB2 EE 7.2 on AIX 4.3.3.
>
> For example, I have RAID 0+1 storage (8 disks) on EMC Symmetrix. Now I
> need to create a 64GB tablespace on this EMC RAID. Which of the
> following is the best way from performance perspective?
>
> (1) 1 64GB container
>
> (2) 4 * 16GB containers
>
> (3) 8 * 8GB containers This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ulrich Sprick |
last post by:
Hi all,
(DB2 V7.1 for WinNT)
I am looking for a way to determine the free space in my tablespace (containers), but I can't find out. The tablespace in question
is a system managed tablespace in a raw partition. The Control Center always reports 100% usage (although I can insert data...). The
"list tablespace containers for n show detail" command shows the number of usable pages, but they are almost equal to the total
number of pages.
...
|
by: maricel |
last post by:
Which one is better in terms of producing optimum performance:
a) Single tablespace that contain multiple containers, say 5 containers of
100MB each container
or
b)Single tablespace that that contain single container, say 1 container of
500MB - same tablespace size as in (a).
Is there any trade-off?
|
by: Stanley Sinclair |
last post by:
About to create a table which will "include" a BLOB. Am not sure how
large to make the container and the tablespace.
What I see says that BLOB is stored "separately." However, I don't
know where.
With a table kinda like:
CREATE TABLE BLOB_TABLE (
BLOB_ID INT,
|
by: Amy DBA |
last post by:
OK, I'm stumped now. I need help restoring a tablespace that has been
marked offline. Here's a little background on the problem:
1) There was a hardware failure that caused the tablespace to become marked
offline: State = 0x4000; Detailed explanation: Offline
2) I tried switching it back online and got this error: DB21034E The
command was processed as an SQL statement because it was not a valid Command
Line Processor...
|
by: mairhtin o'feannag |
last post by:
Hello,
I have a tablespace striped across three drives, call them 1,2,3, just to
be clever. :) I allocated a lot more space (DMS) than I should have,
since I didn't know a way to estimate the space required (long story, but
the original space was in one huge tablespace for all tables ((35 million
row tables)) and I needed to segregate them out into separate tablespaces
for backup and restore purposes.
So I allocated, like 4 million...
| | |
by: cbielins |
last post by:
One of our tablespaces is in an offline state:
Tablespace ID = 9
Name = xxx_xxxx
Type = Database managed space
Contents = Any data
State = 0x4000
Detailed explanation:
Offline
|
by: Lan W via DBMonster.com |
last post by:
I tried to restore DB2 UDB two databases into two different instances on AIX
server. the raw devices size of rShortSpace0 and rShortSpace1 on the two
instances are the same.
# lsvg -l datavg
datavg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
db2templv jfs 52 52 1 open/syncd /db2temp
loglv00 jfslog 1 1 1 open/syncd N/A
RegSpace0 jfs ...
|
by: Konstantin Andreev |
last post by:
Hello, all.
Let the tablespace SY810T4K is almost full:
---------------
db2 =list tablespaces show detail
...
Name = SY810T4K
Type = Database managed space
Contents = Any data
Total pages = 332800
|
by: Michel Esber |
last post by:
Hello,
LUW V8 FP 11 running Linux RH AS4 Update 3.
In regards to performance and IO parallelism, does it matter if I
create a tablespace with a single big container, or is it better to
create it with several smaller containers ?
Any ideas and links to the proper documentation is greatly appreciated.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
