Is this 1.8 gb limit a unix or windows thing, or both?
"Singh, Ratnesh \(GEI, GEFA, Contractor\)"
<[EMAIL PROTECTED]>@Lugwash.org on 03/17/2004 07:55:03 PM
Please respond to "Singh, Ratnesh \(GEI, GEFA, Contractor\)"
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
cc:
Subject: RE: [DB2EUG] create bufferpool errors - help
Thats right, i faced a similar problem on 32 bit udb and IBM support told
me that the
max for all memory allocations is ~1.8 gig .
regards
ratnesh
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Reys, Ellen
Sent: Wednesday, March 17, 2004 7:45 PM
To: 'Gandra, Narayan'; [EMAIL PROTECTED]
Subject: RE: [DB2EUG] create bufferpool errors - help
Are you on UDb 32- or 64-bit?
The amount of physical memory on the box does not play a large role, if you
are on 32-bit model. You will be limited to 1.7 GB for the shared memory
allocation, and this covers bufferpool, util_heap, dbheap, package cache,
etc.
Ellen Klebaner-Reys
Data Management Services
Inovant - a Visa Solutions Company
[EMAIL PROTECTED]/650-432-1746
M/S: M2-11C Office/Cube: M2-11584
-----Original Message-----
From: Gandra, Narayan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 4:09 PM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] create bufferpool errors - help
Hi,
I am working DB2 UDB 8.1 with FP2 on Solaris 2.8. This unix box contain
around 6 GB memory and when I am trying to creating bufferpool using the
following sql:
$ db2 "create bufferpool testbp size 100000 pagesize 4k"
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect
until
the next database startup due to insufficient memory. SQLSTATE=01657
$ top
load averages: 0.07, 0.08, 0.09
93 processes: 91 sleeping, 2 on cpu
CPU states: 97.1% idle, 1.6% user, 1.3% kernel, 0.0% iowait, 0.0% swap
Memory: 6144M real, 5336M free, 2050M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
28632 war81064 1 59 0 1488K 1272K cpu3 0:00 0.03% top
941 root 10 40 0 3632K 3344K sleep 0:03 0.01% nscd
23854 war81064 1 58 0 125M 94M sleep 0:02 0.01% db2sysc
14380 root 1 58 0 5136K 3696K sleep 0:02 0.01% db2fmcd
130 root 7 58 0 3136K 1912K sleep 1:07 0.00% devfsadm
1392 root 12 58 0 2712K 2456K sleep 0:06 0.00% mibiisa
23877 war81064 1 58 0 88M 62M sleep 0:02 0.00% db2sysc
433 root 15 58 0 23M 12M sleep 0:02 0.00% vxsvc
515 root 5 58 0 3520K 2440K sleep 0:02 0.00% automountd
20 root 1 59 -19 9040K 7720K sleep 0:02 0.00% vxconfigd
125 root 14 33 0 4920K 2744K sleep 0:01 0.00% syseventd
1175 root 38 147 -20 58M 5856K sleep 0:01 0.00% rgmd
1122 root 7 100 -20 0K 0K cpu2 0:00 0.00% rpc.pmfd
26608 war81064 1 0 0 117M 74M sleep 0:00 0.00% db2sysc
26609 war81064 1 0 0 85M 43M sleep 0:00 0.00% db2sysc
Actualy I want to create a bufferpool with 2 GB size and is it possible to
create that much size bufferpool on above solaris box with 5336 M free.
Any help greatly appreciate.
Thanks!
GNR
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
******************* PLEASE NOTE *******************
This E-Mail/telefax message and any documents accompanying this
transmission may contain privileged and/or confidential information and is
intended solely for the addressee(s) named above. If you are not the
intended addressee/recipient, you are hereby notified that any use of,
disclosure, copying, distribution, or reliance on the contents of this
E-Mail/telefax information is strictly prohibited and may result in legal
action against you. Please reply to the sender advising of the error in
transmission and immediately delete/destroy the message and any
accompanying documents. Thank you.
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
