Multiple sessions

You can use multiple tape drives simultaneously to increase the transfer rate to or from the IBM Spectrum Protect server. Several backup sessions access the database in parallel on the database server, and the data is written simultaneously to several tape drives.

Figure 1. Parallel (multiple) sessions
This graphic shows the principle of multiple sessions. Several backup sessions access the database in parallel on the database server. The data is transferred in parallel through the network and the IBM Spectrum Protect backup server writes the data simultaneously to several tape drives.

The Data Protection for SAP DB2® keyword MAX_SESSIONS is used to define the number of parallel sessions to be established with the IBM Spectrum Protect server for database backup, archive (backup of log files) and restore. When you run a database backup, the data is typically written directly to tape drives on the IBM Spectrum Protect server. The parameter that is specified in the MAX_SESSIONS keyword must match the number of tape drives that are used simultaneously.

These must be available to the management class defined as BRBACKUPMGTCLASS in the Data Protection for SAP profile. When you set up the IBM Spectrum Protect server, make sure not to activate collocation in the (tape) storage pool that is defined for the management class that is chosen as BRBACKUPMGTCLASS. In addition, ensure that as many tape drives for this management class are available as the number of sessions that are defined in MAX_SESSIONS. Multiple access to the same tape might slow down data transfer.

These must be available to the management class defined as BRARCHIVEMGTCLASS in the Data Protection for SAP profile. If you are using tape pools as primary pools for this management class, this consideration for database backups also applies to disk storage pools. Several DB2 log archive sessions can simultaneously use one or two independent disk storage pools.

The number of storage pools that are required depends on the number of backup copies that are requested for a DB2 log file.