Open topic with navigation
Storage groups are serviced by zero or more SMs. For a storage group to be available, it must be serviced by at least one SM.
A storage group is created using the
add storageGroup command in
nuodbmgr. The storage group assignment to an SM can also be managed by the database option,
storage-group, when initializing an archive.
The following rules apply to storage groups:
UNPARTITIONEDstorage group is serviced by every SM in the database.
Note: In a database with multiple storage groups, an SM may service more than one storage group (more than one logical partition has the same physical location) and a storage group may be serviced by more than one SM (for redundancy and availability).