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
