469,924 Members | 1,408 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,924 developers. It's quick & easy.

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 1420
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by fabrice | last post: by
9 posts views Thread by Swami | last post: by
8 posts views Thread by Mark A | last post: by
2 posts views Thread by Abby | last post: by
3 posts views Thread by Slimo | last post: by
6 posts views Thread by Boris | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.