473,320 Members | 2,117 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.

Registry Variable for linux

Hello All,

Has any one used either one of the below mentioned registry variables
in any of the environments. Were there any performance issues related
with this. Any inputs regarding these variables, regarding to the db2
performance will be greatly helpful.

DB2_SKIPDELETED / DB2_SKIPINSERTED Default=OFF
Values: ON OFF

DB2LINUXAIO (Linux)

DB2MAXFSCRSEARCH Default=5
Values: -1, 1 to 33 554

Cheers !!

Dec 4 '06 #1
3 1535
db2_d_b_a wrote:
DB2_SKIPDELETED / DB2_SKIPINSERTED Default=OFF
Values: ON OFF
DB2_SKIPINSERTED should be set to ON. I expect the default to be moved
to ON in a future release.
DB2_SKIPDELETED and DB2_EVALUNCOMMITED are a bit more interesting,
semantically.
None of them are "performance" variables. all of them are "concurrency"
variables. I.e you won't see a change in single user mode, but if you
are suffering from dead locks and/or lock waits the relief will be major.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Dec 4 '06 #2
Thanks Serge ! .. Thanks for your valuable inputs. Will try to enable
these and see how it works for our environment !

Serge Rielau wrote:
db2_d_b_a wrote:
DB2_SKIPDELETED / DB2_SKIPINSERTED Default=OFF
Values: ON OFF
DB2_SKIPINSERTED should be set to ON. I expect the default to be moved
to ON in a future release.
DB2_SKIPDELETED and DB2_EVALUNCOMMITED are a bit more interesting,
semantically.
None of them are "performance" variables. all of them are "concurrency"
variables. I.e you won't see a change in single user mode, but if you
are suffering from dead locks and/or lock waits the relief will be major.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Dec 5 '06 #3
"db2_d_b_a" <su*****@gmail.comwrites:
DB2LINUXAIO (Linux)
What do you want to know about db2linuxaio? It allows using
asynchronous i/o in Linux, and is a specific performance lineitem. I'd
suggest to turn it on on db2 v8.2.
See http://ldp.rtin.bz/HOWTO/DB2-HOWTO/kernels.html
From that doc:
--------------------------------------------
Asynchronous I/O handling

Asynchronous I/O is a kernel processing enhancement that allows applications to submit I/O requests, and then continue working without having to wait for the I/O request to be completed.

As mentioned in a few of the distribution-specific instructions, this requires the installation of the libaio package, and the setting of the DB2LINUXAIO DB2 UDB configuration parameter.
--------------------------------------------
On db2 9 it is deprecated.

--
Haider
Dec 5 '06 #4

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

Similar topics

2
by: QyRoN | last post by:
Hi I need to install python-2.3 on my computer. The problem is that python and many programs written in python (pythonwin for example) use registry for storing parameters on python installation....
2
by: fabrice | last post by:
hello, Is it possible to read a registry key in ASP, and use the value in an application via a session variable. I'm using II6 on windows server 2003. I'd like to create a key in the registry...
9
by: Swami | last post by:
I was wondering how I can programmatically find out the path of an installed program. I have an application that needs access to a config file that resides in the folder of another application. ...
8
by: Mark A | last post by:
Here is the description of a new feature in 8.2.2 (FP9) from the InfoCenter: "DB2_SKIPINSERTED registry variable You can use the DB2_SKIPINSERTED registry variable to skip uncommitted inserted...
2
by: Abby | last post by:
I'm sorry that I post this question in this newsgroup, but I don't know where is the right place to post. I have a question if I can get to CPU's registry to modify its clock cycle so that I can...
3
by: Slimo | last post by:
Hello, I'm searching some example of code (VB) for reading remote registry subkeys and keys. Thanks
6
by: Boris | last post by:
Has anyone ever managed to read a Windows registry key in a PHP webpage? I installed the PHP extension win32std and saved their sample script from...
1
by: dunleav1 | last post by:
I read in the Db2 9 Administration Planning guide that DB2LINUXAIO was depreciated in DB2 9. In 8.2, it improved my db2 i/o performance on a DB2 implementation on Linux with Raid. Why was this...
1
by: projectVBA | last post by:
Hi , I wrote some add in for PowerPoint and i'm trying to find an automatic way to load it every time PowerPoint starts. I found Microsoft Code example (see below ) BUT the problem is : I can't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
1
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: 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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.