Simon, the following site: http://publib-b.boulder.ibm.com/cgi-bin/searchsite.cgi?query=performance Gives you the Redbooks published on various performance issues of DB2 and others. N0. 19 DB2 UDB V7.1 Performance Tuning Guide will give you very good tuning tips. You will need to tune the intra-parallel, max_query_degree parms at the dbm level as well as the default_degree parm at the db cfg level. With !GB of memory available, you should obviousle address the size of your buffer pool(s) first. I'd recommend as a start point to run the Performance Smart Guide from the Control Center. Don't run the output but save it to script, print it and review so you can change what fits your environment. HTH, Pirre. "Dimoline, Simon" wrote: > Dear User group, > I am currently using a single processor and 256Mb RAM to run my DB2 database > (version 4 I'm afraid!). Does anyone know what sort of performance increase > I should expect from increasing RAM to 1 Giga byte and upgrading to a dual > processor? > > Also, do I need to do any tuning to take advantage of the increases? > > Many thanks for any information. > > Simon Dimoline > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > "This communication is intended solely for the addressee and is confidential and not >for third party unauthorised distribution." > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
