Steve, And on top of that we came across a nasty bug with intra_parallel on Linux which managed to crash the DB2 instance (albeit we were at FP6 at the time).
I'll check the status of this (we had an APAR open with IBM but I'll need to check with the sysadmin whether he got a resolution). Phil On Sat, 08 Feb 2003 10:59:14 -0700, Ian D. Bjorhovde wrote: >steve shapero wrote: >> hi group >> so i installed my second processor and have already seen dramatic >> results. i was reading the db2 manual (imagine that) and in chapter 29, >> scaling your configuration through adding processors, mention is made of >> the "enable intra-partition parallelism" (intra_parallel) param. this >> sounds like a param i would like to set to system at the very least... >> but when i do db2set -lr i don't see it. i looked around in the control >> center and didn't see it either... i also didn't see anything about >> max_querydegree. i set default degree (dft_degree) to -1 (system >> decides), guessing that this was a good starting point. can someone a) >> tell me how to set these params and b) confirm that letting the system >> decide is a good idea? i am running UDB 7.1 fp5 on red hat 7.2. > >INTRA_PARALLEL is a database manager configuration option. Check with > > db2 get dbm cfg > >and look for INTRA_PARALLEL. > >You need to consider the effects of turning this on. This will enable >the optimizer to execute the different plan subsections of a query in >parallel, but this may result in more contention for your system's >resources. If you're running an OLTP app INTRA_PARALLEL is generally >a bad idea. > >With only 2 CPUs you'll need to gauge carefully the kind of queries and >how many users are running queries simultaneously to make the best >decision. > >Setting DFT_DEGREE to -1 is a good idea with only 2 CPUs. > > >Good luck, > >- >::: 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
