Sample Header Ad - 728x90

In DB2 LUW, When should I use a 4K, 8K, or 16K tablespace rather than just creating a 32K tablespace and being done with it?

3 votes
3 answers
2067 views
We're using DB2 LUW 10.5 & 11.1 on Windows & Linux systems, in case it's relevant to he answers. Question: Is there a time where it would be correct to use 4K rather than 32K? If so, why? (Does it perform better when it can be used?) Or, is it just a legacy appendage from some prehistoric time when 4K was just the page size? Background: I have always just created a 4K, 8K, 16K, & 32K tablespaces and associated bufferpools when I create DB2 db's. My manager is challenging me on this. (Good for him - I should know this!) He thinks we should just create a 32K tablespace and be done with it. I'm not able to find anything that tells me, for instance, that when the row size allows it, we should use 4K rather than 32K because XYZ. It tells me I *CAN* do this, but not that/when I should.
Asked by Joe Hayes (335 rep)
Jun 6, 2019, 06:13 PM
Last activity: Apr 15, 2024, 03:02 AM