Defining a storage pool

A storage pool needs to be added when during the configuration. A storage pool is a named collection of storage volumes that are associated with one device class. Each storage pool represents a collection of volumes that are the same media type. The storage pool setup defines the storage hierarchy for the appropriate environment.

Procedure

  1. Define a storage pool for the SAP system data: define stgpool sap_incr device_class_name maxscr=5
  2. Define a storage pool for the data files containers: define stgpool sap_db device_class_name maxscr=20
  3. Define a storage pool for the first copy of offline redo log files offline log files: define stgpool sap_log1 device_class_name maxscr=3
  4. It is advised that you back up the offline redo log files twice on two different IBM Storage Protectâ„¢ volumes. Define an extra storage pool for the second copy of offline redo log files: define stgpool sap_log2 device_class_name maxscr=3

Results

When a library tape device is associated, the maximum scratch volumes (labeled volumes that are empty or contain no valid data) that this storage pool is allowed to use (parameter maxscr) must be defined. The maximum number of scratch tapes depends on the size of the database, the capacity of the tapes, the number of scratch volumes available, and how many versions of the backup must be retained. Replace these values with appropriate estimates.