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
