Currently I am working with a DB2 V8.2 32 bit on aix. The application does not allow me to upgrade to a 64 bit version of DB2 so tuning memory is a delicate matter.
I am concidering to activate connection concentrating (MAX_CONNECTIONS > MAX_COORDAGENTS) and when I read this:DB2 UDB performance tuning scenarios: Part 1, DB2 UDB OLTP tuning illustrated with a Java program I understand that this will affect the sort-behaviour of DB2. What I do understand is that all sorts are private now (so only SORTHEAP is used). What I do not understand how sort is going to behave after my change: will all sorts be shared now? Will there be a mix of shared and private sorts?