Our prod DB2 Connect enterprise is running at 1G now. Dev has 600M. You likely need more there. He doesn't do well if he has to swap a lot. Odd things happen.
For the 2 that have existing boxes you can probably get current stats off them. I don't know how to do it in AIX, but the "free" command in Linux will tell you how much is being used for buffers and cache and you can back that down from the 16G those boxes have. I'd probaby start a DB2 + MQ server at least at 1G, but it really does depend on how much work load there is. The WAS server is easiest. You can estimate pretty well by taking the size of the JVMs and adding what your Linux and base products tend to use up. It's really bad to swap the JVM. Just beware of apps with ridiculously sized JVMs. A good Java monitor is a really good idea (Introscope, ITCAM, etc ). Once you've got them up, it's pretty easy to adjust. Either use your performance monitor or simply the free/vmstat command to see how much swap is going on and reduce until you just barely don't swap :). Just set your users expectations that you are estimating and will be wanting to monitor and adjust with a reboot if you see their performance is not optimal. They like that warm fuzzy feeling that you care and are watching out for them. You swap should be in vdisk of course so if you do, 'tis not too bad. It's pretty hard to generalize. I get asked that a lot - what size are your x type servers. Well, it depends. We try really hard to get their numbers just right for them. That way you can get a 100 servers in 32M (not that I want to go back there :). Marcy "This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation." -----Original Message----- From: Linux on 390 Port [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, May 19, 2009 9:13 AM To: [email protected] Subject: [LINUX-390] DB2 on z/VM & SuSE 10.2 "box" sizing - starter values ? I'm finally in the process of firing up some "boxes" under VM to replace some aging AIX critters and I could use some advise as to real memory and swap allocations for these new guys. 1st victim was a DB2 connect enterprise unlimited server - cut it to production 2 weeks ago and everything is good. 246900k of memory and 3G of swap, so far, so good except for a small issue with java versioning v1.5 on new box, v1.3 on oldest client app - but that is a java issue that would show up on any platform with the new version. 2nd victim is a DB2 ESE and WebSphere MQ server - can't even fire up the tools database because the bufferpools don't have enough memory. This is where the advise is needed since the IBM docs don't have a recommended starting point for the z/VM environment ( DB2 9.5 fixpack 3b) and I really don't want to scarf all of the vm resources for this machine when the grand plan ( insert evil laugh here ) is to put as many AIX and intel linux onto this platform (Z) as we can and still maintain decent performance. Current AIX box is a 2-way power3 box with 16G of memory - low utilization in a development environment. 3rd victim is a WebSphere AppServer box - 6-way power4 box with 16G memory. Low to moderate utilization in a development environment with a second instance of WAS for background production use ( the moderate utilization part - when it is active ). Current VM lpar has 2 IFL, 9G cstor, 3G estor, z/VM 5.3 and SuSE 10.2 guests Thanks, Bruce ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
