Storage groups

A storage group is used to group together volumes of a particular BS2000 catalog ID under a single name.

The spaces in the ORDERCUST database are distributed over three storage groups

• Storage group STOGROUP1
  for the catalog Space and the user spaces as well as the DA-LOG files.

• Storage group STOGROUP2
  for the CAT-REC and die CAT-LOG files

• Storage group STOGROUP3
  for the backup copies of the catalog space and the user spaces.

In the supplied version of the ORDERCUST demonstration database, all three storage groups are created in the default pubset of the BS2000 ID. It is therefore possible to access the database irrespectively of the current runtime environment.

However, in productive use the CAT-REC file should be created on a storage medium other than that used for the catalog space and the user spaces so that media recovery remains possible even after the loss of a storage medium.

For more information on the structure of a SESAM/SQL database and on media recovery, refer to section “SQL objects of a SESAM/SQL database” and to section “Media recovery”.