你可以创建多大的缓冲池？ [英] How large of a bufferpool can you create?

问题描述

伙计，


我在AIX 5.1上使用DB2 UDB 8.2。你可以创建多大的缓冲池？


我试图创建一个4GB缓冲池db2抱怨说不能支持
分配enogth内存。我在这个系统上有16GB。

＃db2 create bufferpool cfgbuffpool立即大小1048576 pagesize 4096
SQL20189W缓冲池操作（CREATE / ALTER）直到
由于内存不足导致下一次数据库启动。 SQLSTATE = 01657


当我重新启动数据库时出现以下错误：


＃db2start

06 / 28/2005 16:50:18 0 0 SQL1063N DB2START处理成功。

SQL1063N DB2START处理成功。

[[dbap3 @ lidp4]] / g6 / dbap3>

＃db2连接到mydb


数据库连接信息

数据库服务器= DB2 / 6000 8.2.1

SQL授权ID = DBAP3

本地数据库别名= MYDB

SQL1478W无法启动已定义的缓冲池。相反，DB2支持的每个页面大小的一个小的

缓冲池已经启动。

SQLSTATE = 01626


我尝试过创建2GB缓冲池，但也失败了。


＃db2 create bufferpool cfgbuffpool立即大小1048576 pagesize 4096

-

Hemant Shah /\ ASCII带状广告系列

电子邮件：没有************ @ xnet.com \ / ---------------------

X对抗HTML邮件

回复，删除NoJunkMail / \并张贴

来自我的电子邮件地址。

----------------- [请勿发送未经处理的大量电子邮件] ------------------

我没有忘记，上面的意见只是我的意思。

它在某处的磁带上备份。其他人可以拥有自己的。

Folks,

I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?

I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.
# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657

when I re-start database I get following error:

# db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[[dbap3@lidp4]]/g6/dbap3>
# db2 connect to mydb

Database Connection Information

Database server = DB2/6000 8.2.1
SQL authorization ID = DBAP3
Local database alias = MYDB

SQL1478W The defined buffer pools could not be started. Instead, one small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

I tried to to create 2GB bufferpool and that failed too.

# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven''t lost my mind, Above opinions are mine only.
it''s backed up on tape somewhere. Others can have their own.

推荐答案

Hemant Shah写道：

Hemant Shah wrote:

人们，

我我在AIX 5.1上使用DB2 UDB 8.2。你可以创建多大的缓冲池？

我试图创建一个4GB缓冲池db2抱怨说无法分配enogth内存。我在这个系统上有16GB。

＃db2 create bufferpool cfgbuffpool立即大小1048576 pagesize 4096
SQL20189W缓冲池操作（CREATE / ALTER）直到
下一个才会生效由于内存不足导致数据库启动。 SQLSTATE = 01657
当我重新启动数据库时出现以下错误：

＃db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START处理成功。
SQL1063N DB2START处理成功。
[[dbap3 @ lidp4]] / g6 / dbap3>
＃db2 connect to mydb

数据库连接信息

数据库服务器= DB2 / 6000 8.2.1
SQL授权ID = DBAP3
本地数据库别名= MYDB

SQL1478W定义的缓冲池不能开始吧相反，DB2支持的每个页面大小的一个小的缓冲池已经启动。
SQLSTATE = 01626

我试图创建2GB缓冲池，但也失败了。 />
＃db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096

Folks,

I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?

I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.
# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657

when I re-start database I get following error:

# db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[[dbap3@lidp4]]/g6/dbap3>
# db2 connect to mydb

Database Connection Information

Database server = DB2/6000 8.2.1
SQL authorization ID = DBAP3
Local database alias = MYDB

SQL1478W The defined buffer pools could not be started. Instead, one small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

I tried to to create 2GB bufferpool and that failed too.

# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096

这是一个32位还是64位版本的DB2？


干杯

Serge


-

Serge Rielau

DB2 SQL编译器开发

IBM多伦多实验室

Is this a 32bit or 64bit version of DB2?

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

" Hemant Shah" < SH ** @ typhoon.xnet.com>在消息中写道

新闻：d9 ********** @ new7.xnet.com ...

"Hemant Shah" <sh**@typhoon.xnet.com> wrote in message
news:d9**********@new7.xnet.com...

人们，
我在AIX 5.1上使用DB2 UDB 8.2。你可以创建一个多大的缓冲池？

我试图创建一个4GB的缓冲池db2抱怨说无法分配enogth内存。我在这个系统上有16GB。

＃db2 create bufferpool cfgbuffpool立即大小1048576 pagesize 4096
SQL20189W缓冲池操作（CREATE / ALTER）将不会生效
直到当我重新启动数据库时出现以下错误：

＃db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START处理成功。
SQL1063N DB2START处理成功。
[[dbap3 @ lidp4]] / g6 / dbap3>
＃db2 connect to mydb
数据库连接信息

数据库服务器= DB2 / 6000 8.2.1
SQL授权ID = DBAP3
本地数据库别名= MYDB

SQL1478W定义缓冲池无法启动。相反，DB2支持的每个页面大小的一个小的缓冲池已经启动。
SQLSTATE = 01626

我试图创建2GB缓冲池并且失败了

＃db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
Hemant Shah /" \ ASCII ribbon campaign

Folks,

I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you
create?

I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.
# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect
until
the next database startup due to insufficient memory. SQLSTATE=01657

when I re-start database I get following error:

# db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START processing was
successful.
SQL1063N DB2START processing was successful.
[[dbap3@lidp4]]/g6/dbap3>
# db2 connect to mydb

Database Connection Information

Database server = DB2/6000 8.2.1
SQL authorization ID = DBAP3
Local database alias = MYDB

SQL1478W The defined buffer pools could not be started. Instead, one
small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

I tried to to create 2GB bufferpool and that failed too.

# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
Hemant Shah /"\ ASCII ribbon campaign

如果您创建了一个32位实例，则AIX下的实例总DB2内存分配可以不超过约1.75GB（对于所有DB2内存

要求包括缓冲池）。因此，可用于
缓冲池的数量可能接近1.25 GB，具体取决于您在db和dbm配置参数中配置的
的参数。这个数量因操作系统而异。
（Solaris和Windows更多，HP / UX和Linux更少）。


如果您有64位实例，实例的最大DB2内存分配量b / b
远远超出了我知道的任何计算机的内存量。但是，请确保服务器上有足够的实内存，以便在缓冲池中指定的总金额，还允许其他DB2

内存要求。


为了创建64位DB2实例（或将32位实例转换为64位/ b $ b位），必须在64位硬件上运行64位操作系统。请咨询您的

AIX系统管理员，了解64位AIX。

If you created a 32 bit instance, then the total DB2 memory allocation for
the instance can be no more than about 1.75GB under AIX (for all DB2 memory
requirements including the bufferpools). So the amount available for
bufferpools is probably closer to 1.25 GB, depending on the parms you
configured in the db and dbm configuration parms. This amount varies by OS
(more for Solaris and Windows, less for HP/UX and Linux).

If you have a 64 bit instance, the maximum amount of DB2 memory allocation
for the instance is far beyond the amount of memory in any computer that I
know about. However, make sure you have enough real memory on the server for
the total amount you specify in the bufferpools, also allowing for other DB2
memory requirements.

In order to create a 64-bit DB2 instance (or convert a 32 bit instance to 64
bit) you must have a 64 bit OS running on 64 bit hardware. Check with your
AIX system administrator about 64 bit AIX.

" Serge Rielau" < SR ***** @ ca.ibm.com>在消息中写道

news：3i ************ @ individual.net ...

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3i************@individual.net...

Hemant Shah写道：

Hemant Shah wrote:

伙计，

我在AIX 5.1上使用DB2 UDB 8.2。你可以用
创建一个多大的缓冲池？
我试图创建一个4GB缓冲池db2抱怨说无法分配enogth内存。我在这个系统上有16GB。

＃db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W缓冲池操作（CREATE / ALTER）将不会生效
直到下一个由于内存不足导致数据库启动。 SQLSTATE = 01657


只有当旧/新的
缓冲池大小之间的差异太大，并且没有足够的连续内存时，才会出现此警告

系统扩展一些控制结构。这个

案例需要重启。

当我重新启动数据库时出现以下错误：

＃db2start
06 / 28/2005 16:50:18 0 0 SQL1063N DB2START处理是
成功。 SQL1063N DB2START处理成功。
[[dbap3 @ lidp4]] / g6 / dbap3>
＃db2连接到mydb

数据库连接信息

数据库服务器= DB2 / 6000 8.2.1
SQL授权ID = DBAP3
本地数据库别名= MYDB

SQL1478W无法启动已定义的缓冲池。相反，DB2支持的每个页面大小的一个
小缓冲池已经启动。
SQLSTATE = 01626
我试图创建2GB缓冲池，但也失败了。 />
＃db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096

Folks,

I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.

# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect until the next database startup due to insufficient memory. SQLSTATE=01657
This warning occurs only when the the difference between the old/new
bufferpool sizes is too large, and there is not enough continguous memory in
the system to expand some control structures. A restart is required in this
case.
when I re-start database I get following error:

# db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful.
[[dbap3@lidp4]]/g6/dbap3>
# db2 connect to mydb

Database Connection Information

Database server = DB2/6000 8.2.1
SQL authorization ID = DBAP3
Local database alias = MYDB

SQL1478W The defined buffer pools could not be started. Instead, one small buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

I tried to to create 2GB bufferpool and that failed too.

# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096

这是一个32位还是64位版本的DB2？

Is this a 32bit or 64bit version of DB2?

32位版本的DB2只能访问最大2GB的内存。这个

将缓冲池限制在1.7GB左右，这是由于32位AIX上共享内存基础设施中其他内存的开销和限制。


64位版本的DB2可以在没有问题的情况下访问大量内存 - IBM在过去一年中发布了使用接近
$ b的基准测试$ b 1TB的记忆。


-

Matt Emmerton

The 32-bit version of DB2 can only access a maximum of 2GB of memory. This
limits your bufferpools to around 1.7GB due to the overhead of other memory
sets and limitations in the shared memory infrastructure on 32-bit AIX.

The 64-bit version of DB2 can access large amounts of memory without
problems -- IBM has published benchmarks in the past year that used close to
1TB of memory.

--
Matt Emmerton

这篇关于你可以创建多大的缓冲池？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！