Haider, Here is the shmmax size: @warbird1:/home/smbuild>sysdef | grep -i shmmax 5536870912 max shared memory segment size (SHMMAX)
Thanks! Narayan -----Original Message----- From: Haider Rizvi [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:46 AM To: Gandra, Narayan Cc: 'Reys, Ellen '; '[EMAIL PROTECTED] ' Subject: Re: [DB2EUG] create bufferpool errors - help Narayan, There is a memory limit on 64-bit but it is way too high (I think 512 GB on Solaris). This problem may be due to your /etc/system settings, what is the value of shmsys:shminfo_shmmax in that file. Or sysdef | grep -i shmmax See the quick beginnings guide: http://webdocs.caspur.it/ibm/web/udb-6.1/db2cy/db2cy22.htm Also read up on db2osconf that can help you set this and various other parms: http://www.databasejournal.com/features/db2/article.php/10896_2177781_4 - Haider "Gandra, Narayan" <[EMAIL PROTECTED]> writes: > I am on UDB 64-bit. Is there any memory limit for the shared memory > allocation on 64 bit? When I want to create a bufferpool with 2GB size on > UDB 64 bit machine, Do I need tune any dbm/db cfg parameters? Any help > greatly appreciate. > > Thanks! > Narayan > > -----Original Message----- > From: Reys, Ellen > To: 'Gandra, Narayan'; [EMAIL PROTECTED] > Sent: 3/17/2004 6:45 PM > 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 - ::: 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 - ::: 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 - ::: 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
