We are considering collapsing several DB2 Stogroups into one. The advantage is the more efficient use of freespace and significantly easier to manage. We believe because we are now on a SAN storage architecture with logocal volumes being presented and physical volumes being striped behind the scenes that the old concept of managing multiple storage groups is no longer necessary.
What we are considering is:
- 1 stogroup for database data
- 1 stogroup for the "a" logs
- 1 stogroup for the "b" logs.
I'd like some feedback from someone that is working with a similar configuration.