DB2是多线程的吗？ [英] Is DB2 multi-threaded?

问题描述

大家好，


有1个CPU，8个内核，每个内核有4个线程（32个虚拟CPU）。

我们正在探索这个选项而不是同等性能的pSeries

框。但在我们深入研究之前，我们需要一些基本的信息。


任何建议都会有所帮助。


问候，

dotyet

Hi Everyone,

It would be a real big help if anyone can shed light on whether DB2 UDB
8.2 on Solaris will make optimum use of a Sun T2000 server. The server
has 1 CPU with 8 cores and each core has 4 threads (32 virtual CPUs).
We are exploring this option againts an equivalent performance pSeries
box. But before we delve deeper, we want some basic info on that.

Any suggestions would be helpful.

Regards,
dotyet

推荐答案

dotyet写道：

大家好，
我们正在探索这个选项，而不是一个同等性能的pSeries
盒子。但在我们深入研究之前，我们需要一些基本的信息。

Hi Everyone,

It would be a real big help if anyone can shed light on whether DB2 UDB
8.2 on Solaris will make optimum use of a Sun T2000 server. The server
has 1 CPU with 8 cores and each core has 4 threads (32 virtual CPUs).
We are exploring this option againts an equivalent performance pSeries
box. But before we delve deeper, we want some basic info on that.

我认为你需要区分操作系统上的线程和虚拟的

CPU'' 。我知道DB2在pSeries上利用了虚拟CPU，并且如果在Sun上无法利用它，我会感到惊讶。

但DB2在Unix上使用进程，并没有在操作系统上使用多线程

级别。相比之下，IDS是一个多线程引擎。

再次......这与利用虚拟CPU无关。


干杯
Serge

-

Serge Rielau

DB2解决方案开发

DB2 UDB for Linux， Unix，Windows

IBM多伦多实验室

I think youneed to differentiate between threading on the OS and virtual
CPU''s. I know for fact that DB2 exploits virtual CPU''s on pSeries and
I''d be surprised if it couldn''t exploit it on Sun.
But DB2 on Unix uses processes and is not using multithreading on the OS
level. IDS by contrast is a multithreaded engine.
Again... this has nothing to do with exploitation of virtual CPU''s.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

有趣......这是一段时间以来的对话主题。

多线程ala IDS比多进程要多得多，DB2 LUW会多少钱？


不要误会我的意思 - 我是前任IDS管理员因为业务原因将我的引擎完全切换到了DB2，而且我确实喜欢DB2和Informix。这两种产品都有它们的优点和价值。 （再次，*不*寻找火焰战争！）


但是，我在HP-UX和Linux上使用IDS很长一段时间（10年）。

一旦发动机安顿下来很好地配置，我的

体验稳定性非常稳定。


IBM会不会考虑采用DB2 LUW多线程？


欢呼

aj

Serge Rielau写道：

Interesting...This was the subject of a conversation here awhile back.
How much would DB2 LUW gain by going multithreaded ala IDS rather
than multiprocess?

Don''t get me wrong - I''m a former IDS administrator who has switched
my engines completely to DB2 for primarily business reasons, and I
really like both DB2 and Informix. Both products have their pros and
cons. (Again, *not* looking for a flame war!)

However, I used IDS for a long time (10 years) on both HP-UX and Linux.
Once the engine was "settled in" and configured nicely, it was my
experience that stability was just rock solid.

Would IBM ever consider taking DB2 LUW multithreaded?

cheers
aj
Serge Rielau wrote:

dotyet写道：

大家好，

如果有人能够了解Solaris上的DB2 UDB是否能够充分利用Sun T2000服务器，那将是一个巨大的帮助。服务器有1个CPU，8个内核，每个内核有4个线程（32个虚拟CPU）。
我们正在探索这个选项，而不是一个同等性能的pSeries
盒子。但在我们深入研究之前，我们需要一些基本的信息。

Hi Everyone,

It would be a real big help if anyone can shed light on whether DB2 UDB
8.2 on Solaris will make optimum use of a Sun T2000 server. The server
has 1 CPU with 8 cores and each core has 4 threads (32 virtual CPUs).
We are exploring this option againts an equivalent performance pSeries
box. But before we delve deeper, we want some basic info on that.

我认为你需要区分操作系统上的线程和虚拟的CPU。我知道DB2在pSeries上利用了虚拟CPU，如果它不能在Sun上利用它，我会感到惊讶。
但Unix上的DB2使用进程并且没有使用OS上的多线程
级别。相比之下，IDS是一个多线程引擎。
再次......这与虚拟CPU的利用无关。

干杯
Serge

I think youneed to differentiate between threading on the OS and virtual
CPU''s. I know for fact that DB2 exploits virtual CPU''s on pSeries and
I''d be surprised if it couldn''t exploit it on Sun.
But DB2 on Unix uses processes and is not using multithreading on the OS
level. IDS by contrast is a multithreaded engine.
Again... this has nothing to do with exploitation of virtual CPU''s.

Cheers
Serge

公平，所以你能建议一些方法，脚本等，以确定我们是否会从这32个虚拟CPU中受益。我正在测试机器上设置

，所以可能是另一天或2天，直到我们在这台机器上获得一个功能性的
DB2实例。


还有一个问题就是在这个测试中显示它的面孔

阶段。我已经使用资源

控件配置了内核参数。我为db2缓冲池分配了大约25 GB的内存，所以

我的project.max-shm-memory设置为该数字。现在，在更改示例数据库中大型缓冲池的大小时，引擎说

表示没有足够的内存和缓冲池大小

更改已被保留，直到下次重启实例。很多

次，即使我在缓冲池增加了几百MB的时间，也会给出这个消息。页面大小为32K。立即使用立即。关键字确实

没有任何区别。重新启动DB2实例后，它可以正常运行，并确实分配了相关的（增加的）缓冲池内存。


本机只托管一个用户项目并且，我有公平的份额

调度程序和资源上限deamon禁用。


我在这里遗漏了什么吗？


问候，

dotyet

fair enough, so can you suggest some method, scripts etc to find out if
we would benefit from those 32 virtual CPUs. I am in process of setting
up the test machine, so maybe another day or 2 till we get a functional
DB2 instance on this machine.

there is one more issue which is showing it''s face in this testing
phase. I have configured the kernel parameters using the resource
controls. i am allocating about 25 gb of memory for db2 bufferpools, so
my project.max-shm-memory is set to that number. Now, while altering
the size of a large bufferpool in the sample database, the engine says
that suffiicient memory is not available and the bufferpool size
alteration has been deffered till the next restart of instance. many
times it gives this message even when I am increasing the bufferpool by
a few 100 MBs. The pagesize is 32 K. usage of "immediate" keyword does
not make any difference. Once the DB2 instance is restarted, it works
fine, and does allocate the relevant (increased) bufferpool memory.

This machine will host only one user project and, i have the fair share
scheduler and resource cap deamon disabled.

Am i missing something here?

Regards,
dotyet

这篇关于DB2是多线程的吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！