Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Db2 9.5
0 views
Skip to first unread message
Message has been deleted
Serge Rielau
Mar 31, 2008, 7:09:22 AM3/31/08
to
dcrun...@aim.com wrote:
> 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.
>
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.
> 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.
>
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
0 new messages