Experts,

While screening a group of db2 servers of one of my client, I discovered that most of the DMS on that database are 85-95% full. I was surprised to see, cause I do not have much exp with ranges and partitions.

This database is partitioned, is this normal to have 85-95% tablespaces full in such setups ?? Does this to do something with rotations ??

Any refrence will be helpful.

Regards

DBFinder

Have you checked if their tablespaces are automatic or have AUTOEXTEND ON?

-

Yes,

All tablespaces are having autoresize flag on. There are about 30 tablespaces spread across 3 physical servers. These are all autoresize.

Thanks for the clue

DBFinder