Db2 9.5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dcruncher4@aim.com - 31 Mar 2008 00:40 GMT

I am going thru the documentation of IBM DB2 9.5. It seems it is
now a truly multi-threaded architecture like informix. db2sysc
is the only process seen via ps -ef (like oninit) and other EDUs
are shown as threads within that process.

This seems to be a major major upgrade for db2 and I am sure
a great one from performance point of view. Way to go IBM.

Reply to this Message

Serge Rielau - 31 Mar 2008 12:09 GMT

> I am going thru the documentation of IBM DB2 9.5. It seems it is
> now a truly multi-threaded architecture like informix. db2sysc
[quoted text clipped - 3 lines]
> This seems to be a major major upgrade for db2 and I am sure
> a great one from performance point of view. Way to go IBM.

Tx. The biggest performance gain is on Linux actually where the gap
between process and threads appears to be the most pronounced.
The true benefit of multi-threading (which btw was always used by DB2 on
Windows) is that it flattens the memory landscape. All the self-tuning
memory features in DB2 9.5 draw on this.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

dcruncher4@aim.com - 31 Mar 2008 22:45 GMT

>Tx. The biggest performance gain is on Linux actually where the gap
>between process and threads appears to be the most pronounced.
>The true benefit of multi-threading (which btw was always used by DB2 on
>Windows) is that it flattens the memory landscape. All the self-tuning
>memory features in DB2 9.5 draw on this.

Is there a good site where db2 documentation is available online.

thanks

Reply to this Message

The Boss - 31 Mar 2008 23:33 GMT

>> Tx. The biggest performance gain is on Linux actually where the gap
>> between process and threads appears to be the most pronounced.
[quoted text clipped - 5 lines]
>
> thanks

The "DB2 Information Center" for version 9.5:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp

for version 9.1:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp

for version 8:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp

Cheers!

Signature

Jeroen

Reply to this Message