数据库之间的内存共享 [英] Memory Sharing between Databases
问题描述
我想知道缓冲池和代理内存是否可以在
a EE UDB实例中共享（现在运行7.2 AIX 5但是转到V8 0.1）。我们的
商业模式要求我们每月增加1-2分贝（每个客户需要一个分贝），这就消耗了内存。
这些dbs中的一些不是高度活跃的，但是一旦db被激活，在
最少，缓冲池与
代理的init_pool一起被分配。有没有办法让缓冲池和代理在
数据库之间共享，就像其他RDBMS一样？
谢谢你，期待你的答案。
Selma
您可以通过将所有数据放入
来实现最大的CPU和内存共享数据库，并为每个客户使用不同的架构。并且，将
的数据放在不同的表空间中。缓冲池由
数据库分配，因此不能由不同的数据库共享。但是，如果你不喜欢上面的模式方法，那么在v8缓冲池中为非活动的
数据库的大小可以非常小。
Selma_g写道：
我想知道缓冲池和代理内存是否可以在一个EE UDB实例中共享（现在运行7.2 AIX 5但转到V8.1）。我们的商业模式要求我们每月增加大约1-2分贝（每个客户一分贝），这会消耗内存。
其中一些db不高度活跃但是一旦db被激活，至少缓冲池将与
代理的init_pool一起分配。有没有办法让缓冲池和代理在
数据库之间共享，就像其他RDBMS一样？
谢谢你，期待你的答案。
Selma
感谢您的建议，Blair。但是，由于数据的敏感性，我们的商业合同
禁止在客户之间混合数据。我被困一个月创造1-2 dbs。我记得几年前我在Sybase工作的时候，内存空间是全球共享的。在
事实上sybase声称他们可以支持像32K数据库这样的东西！
有没有人有UDB的解决方案？我不能调整不太活跃的dbs
小缓冲池的大小，因为客户可能会在一天中使用它。
这是否是UDB / DB2中的一个弱点优秀的数据库引擎
？
期待您的回答。
Selma
Blair Adamache< ba ******* @ 2muchspam.yahoo.com>在消息新闻中写道：< c1 ********** @ hanover.torolab.ibm.com> ...
你可以做最大的CPU和内存共享将所有数据放在一个数据库中，并为每个客户使用不同的模式。并且，将他们的数据放在不同的表空间中。缓冲池由数据库分配，因此不能由不同的数据库共享。但是，如果你不喜欢上面的模式方法，那么在v8缓冲池中，非活动数据库的大小可以非常小。
Selma_g写道：
< blockquote class =post_quotes>
我想知道缓冲池和代理内存是否可以在一个EE UDB实例中共享（现在运行7.2 AIX 5但是转到V8.1） 。我们的商业模式要求我们每月增加大约1-2分贝（每个客户一分贝），这会消耗内存。
其中一些db不高度活跃但是一旦db被激活，至少缓冲池将与
代理的init_pool一起分配。有没有办法让缓冲池和代理在
数据库之间共享，就像其他RDBMS一样？
谢谢你，期待你的回答。
Selma
" Selma_g" < SE ********* @ yahoo.com>在留言中写道
新闻：a3 ************************** @ posting.google.c om ...谢谢你的建议，Blair。但是，由于数据的敏感性，我们的业务合同禁止客户之间混合数据。我被困一个月创造1-2 dbs。我记得几年前我在Sybase工作时，内存空间是全局共享的。事实上sybase声称他们可以支持像32K数据库这样的东西！
有没有人有UDB的解决方案？我无法确定那些不太活跃的dbs
小缓冲池的大小，因为客户可能会在一天中使用它。
这是否是UDB / DB2中的一个弱点，否则它是一个优秀的数据库引擎
？
期待你的答案。
Selma
对我来说就像一个定义问题。如果Sybase数据库可以共享
缓冲池，那么它们的数据库可能不像DB2 LUW
数据库那样独立。 DB2 for OS / 390数据库共享缓冲池（显然类似于/ b $ b Sybase），最多可以有65217个数据库，但DB2 for UNIX，Linux和
Windows数据库不具备分享缓冲池（如你所知）。
也许你对术语数据库感到困惑。 （对于不同的DBMS产品，它具有不同的含义
），您应该能够为多个用户提供所需的
安全性，这些用户拥有自己的架构和单个数据库。 />
Hi,
I am wondering if the bufferpools and agent memory canbe shared within
a EE UDB instance (running 7.2 AIX 5 now but going to V8.1). Our
business model requires us to add about 1-2 db''s per month (one db per
customer), and this consume the memory.
Some of these dbs are not highly active but once a db is activated, at
least the bufferpools are allocated along with the init_pool of
agents. Is there a way for bufferpools and agents be shared between
databases, like other RDBMS do ?
Thank you and look forward to your answers.
Selma
You could do maximum CPU and memory sharing by putting all the data in
one databases, and using a different schema for each customer. And, put
their data in distinct table spaces. Bufferpools are allocated by
database, so cannot be shared by different databases. However, if you
don''t like the schema approach above, in v8 bufferpools for inactive
databases can be sized quite small.
Selma_g wrote:
Hi,
I am wondering if the bufferpools and agent memory canbe shared within
a EE UDB instance (running 7.2 AIX 5 now but going to V8.1). Our
business model requires us to add about 1-2 db''s per month (one db per
customer), and this consume the memory.
Some of these dbs are not highly active but once a db is activated, at
least the bufferpools are allocated along with the init_pool of
agents. Is there a way for bufferpools and agents be shared between
databases, like other RDBMS do ?
Thank you and look forward to your answers.
Selma
Thanks for your suggestion, Blair. However, our business contract
forbids mixing data between customers due to the sensitive nature of
the data. I am stuck creating 1-2 dbs a month. As I recall when I
worked in Sybase years ago, the memory space is shared globally. In
fact sybase claimed they can support something like 32K databases!
Does anyone have a solution for UDB? I can''t size the less active dbs
small bufferpools because the customers may use it throughout the day.
Is this a weakness in UDB/DB2 in what otherwise an excellent db engine
?
Look forward to your answers.
Selma
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c1**********@hanover.torolab.ibm.com>...
You could do maximum CPU and memory sharing by putting all the data in
one databases, and using a different schema for each customer. And, put
their data in distinct table spaces. Bufferpools are allocated by
database, so cannot be shared by different databases. However, if you
don''t like the schema approach above, in v8 bufferpools for inactive
databases can be sized quite small.
Selma_g wrote:Hi,
I am wondering if the bufferpools and agent memory canbe shared within
a EE UDB instance (running 7.2 AIX 5 now but going to V8.1). Our
business model requires us to add about 1-2 db''s per month (one db per
customer), and this consume the memory.
Some of these dbs are not highly active but once a db is activated, at
least the bufferpools are allocated along with the init_pool of
agents. Is there a way for bufferpools and agents be shared between
databases, like other RDBMS do ?
Thank you and look forward to your answers.
Selma
"Selma_g" <se*********@yahoo.com> wrote in message
news:a3**************************@posting.google.c om...Thanks for your suggestion, Blair. However, our business contract
forbids mixing data between customers due to the sensitive nature of
the data. I am stuck creating 1-2 dbs a month. As I recall when I
worked in Sybase years ago, the memory space is shared globally. In
fact sybase claimed they can support something like 32K databases!
Does anyone have a solution for UDB? I can''t size the less active dbs
small bufferpools because the customers may use it throughout the day.
Is this a weakness in UDB/DB2 in what otherwise an excellent db engine
?
Look forward to your answers.
Selma
Sounds to me like a definition issue. If Sybase databases can share
bufferpools, then maybe their databases are not as separate as DB2 LUW
databases. DB2 for OS/390 database share bufferpools (apparently like
Sybase) and you can have up to 65217 databases, but DB2 for UNIX, Linux, and
Windows databases do not share bufferpools (as you know).
Maybe you are fixated on the term "database" (which has different meanings
for different DBMS products) and you should be able to provide the required
security with multiple users having their own schema with a single database.
这篇关于数据库之间的内存共享的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
