> i was wondering if anyone has any experience running db2 on redhat with > multiprocessor support. did you have to recompile the kernel? what > db2 configuration parameters do you have to tweak? any advice, > insights, war stories appreciated.
We use Mandrake because the default kernel for servers is compiled with the right parameters so this hasn't been required. Make sure you follow the how-to to setup the kernel to use the old AT&T style IPC that DB2 uses. Turn off hyperthreading (if a recent Xeon) because DB2 on Linux doesn't work very well with that. Make a choice about intra-partition parallelism. If the big queries you run are massive updates then you want it. On the other hand if you're running as an online transaction environment with lots of tiny inserts and lookups then you dont. Then shell out for the database guys to tune your installation, or at least go buy all their tools. http://www.database-guys.com/resources.shtml -HJC - ::: 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
