At my client's site we've created the database with a default page-size of 8K. I've got tablespaces and bufferpools of 8, 16 & 32K and system- and usertemp spaces of 8, 16 & 32K.
So far so good. Driven by advancing insight I want to setup tablespaces and bufferpools of 4K for some small fry and indexes.
Now I wonder: do I have to setup temporary tablespaces of 4K as well or will db2 always switch over to temp-spaces with bigger page-sizes when it finds out that the 4k temp is lacking?
You will often see that housekeeping tasks on 16K tables results in db2 using the 32k temp-space..... but can I trust that this is always the case?