Storage Group Drop Considerations

Rules of DB2 specify that a storage group cannot be dropped if it contains tablespaces or indexspaces. The tablespaces or indexspaces necessary for the storage group drop are automatically dropped, and then that storage group is dropped. If the default storage group of a database is dropped, an explicit storage group name must be used when creating a tablespace or index in the database.
carcudb2
Rules of DB2 specify that a storage group cannot be dropped if it contains tablespaces or indexspaces. The tablespaces or indexspaces necessary for the storage group drop are automatically dropped, and then that storage group is dropped. If the default storage group of a database is dropped, an explicit storage group name must be used when creating a tablespace or index in the database.
When using the standard drops (S or SO), if one or more of the requested drops cannot be completed, none of the drops will be committed.