473,320 Members | 2,003 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,320 software developers and data experts.

DB2_PARALLEL_IO

Hello

In our environment we have one RAID10 volume builded on 16 disks (IBM
EXP810 enclosoure) and 3 logical drives on this volume for our
databases.
All tablespaces in databases are created with 4 containers per
tablespace. (currently its not possible to change)
Also, for all tablespaces PAGESIZE=16384, EXTENTSIZE = 2,
PREFETCHSIZE=8 and the segment size on RAID10 volume is 128K.

Do i need to enable DB2 profile variable DB2_PARALLEL_IO=* or in my
case this is not optimal for disks read/write perfomance ??

DB2 9.1.2 on AIX5.3 TL4

Thanks
With best regards, Dmitry

Oct 25 '07 #1
2 4771
Hi Dmitry,
So you have a system which has as single LUN in SAN made out of 16
disk in 8+8.
And you have 3 LVM's made of this hdisk.
And you have 4 containers per Table space ?
That should mean you have more than one containers in single mount.

Did you start loading the database ? Did you monitor how much is the
disk busy (in topas) ?

If not it would be better to monitor the os and also the SAN (are you
using DS4000 Series ? ).
>From my experience, I have seen, single container per tablepspace in
san is far faster than multiple containers.
DB2_PARALLEL_IO helps in getting the number of parallelism and also
when your PREFETCHSIZE is automatic.

Probably you need change this only if your DB2 is showing far a lot of
IO problems. And if so, best way would be enable this for a day and
see how the system performs.
But if you put your prefetchsize as automatic, you may need to change
the value as DB2_PARALLEL_IO=*:8 .

Depending on your bufferpool, you can play around with the IO variable
to put more data in BP if your data access is more sequential. Its
difficult to change the EXTENDSIZE, I would have have 16 as intial
value and PREFETCH size as automatic as initial configuration of the
system.

Regards
Kiran Nair
On Oct 25, 5:05 pm, mitrofu...@gmail.com wrote:
Hello

In our environment we have one RAID10 volume builded on 16 disks (IBM
EXP810 enclosoure) and 3 logical drives on this volume for our
databases.
All tablespaces in databases are created with 4 containers per
tablespace. (currently its not possible to change)
Also, for all tablespaces PAGESIZE=16384, EXTENTSIZE = 2,
PREFETCHSIZE=8 and the segment size on RAID10 volume is 128K.

Do i need to enable DB2 profile variable DB2_PARALLEL_IO=* or in my
case this is not optimal for disks read/write perfomance ??

DB2 9.1.2 on AIX5.3 TL4

Thanks
With best regards, Dmitry

Oct 28 '07 #2
Has anybody seen any issues with this not working correctly on Linux
with DB2 9 FP3 ?
How can I verify that parallel streams are being utilizied?
I use DB2_PARALLEL_IO=*:3 and I have set no file system caching on my
tablespaces as well...

Oct 31 '07 #3

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

Similar topics

4
by: Erik Hendrix | last post by:
Hi, I have a quick question, when one sets the prefetch size = extent size, then when doing a backup we will have 1 agent (db2bm) doing the reads. If we have prefetch size a multiple of extent...
5
by: Evan Smith | last post by:
We recently upgraded the box that hosts our main DB2 database to an 8-CPU machine with 8 GB of memory. With all the extra horsepower, we were eager to test performance with intra-parallelism turned...
12
by: Nobody | last post by:
DB2 500G database, Wintel, heavily loaded OLTP (5M+ transactions a day; all transactions are extremely small, all selects are controlled (no ad-hoc), 99% of all selects are very small (no table...
10
by: Sean C. | last post by:
Helpful folks, I ran across a statement I found rather confusing in the IBM-published Advanced DBA Certification Guide and Reference for UDB V8. On page 107 the author is explaining why the a...
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...
4
by: Joachim Klassen | last post by:
Hi all, I'm currently investigating the use of MDC Tables for large data warehouse tables. My scenario: A fact table with 1000 Million Rows distributed on 12 Partitions (3 physical hosts...
3
by: Joachim Klassen | last post by:
Hi all, first apologies if this question looks the same as another one I recently posted - its a different thing but for the same szenario:-). We are having performance problems when...
46
by: dunleav1 | last post by:
I have a process that does inserts that runs 50% slower that Oracle and Mssql. Queries normally take 50% slower than normal. DB2, Oracle, Mssql all are configured on same os, same disk array...
0
by: dunleav1 | last post by:
I have a raid array that I have configured as Raid 1/0 and I have DB2 tablespaces across that array. Instead of multiple containers for each tablespace I am utilzing DB2_PARALLEL_IO=*:3. All of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.