Configuring Multiple Streams for Backups and Restores

When you run multiple stream database backups and restores for the SAP MaxDB iDataAgent, you must define the path for each stream/pipe that is used for the storage media.

You must configure the SAP MaxDB parameter file (param) for both configurations to use multiple streams backups and restores. For example if you define 2 pipe mediums for the backup devices, set the numstreams parameter to 2.

Procedure

Windows Client

1. Log in to the database and run the following command from the dbm client interface:

   dbmcli -d <database name> -u <UserName,Password>

   Example

   Parameter	Value
   Database Name	cert1
   User Name	DBM
   Password	DBM

   dbmcli -d cert1 -u DBM,DBM

2. Type the following commands to define the path for the stream/pipe:

   You must use the following format:

   \\. \pipe\[pipe name]

   Note

   For each backup device, you must define two pipe mediums.

   Example

   Variable	Description
   BackData2	A vendor utility backup device that uses the DATA option and is used for full data backups.
   BackPages2	A vendor utility backup device that uses the PAGES option and is used for incremental data backups.
   BackLog	A vendor utility backup device that uses the LOG option and is used for log backups.

   medium_put BackData2\mem1 \\.\pipe\pipe_mem1 PIPE DATA 0 0 NO NO '' BACK
    medium_put BackData2\mem2 \\.\pipe\pipe_mem2 PIPE DATA 0 0 NO NO '' BACK
    medium_put BackPages2\mem3 \\.\pipe\pipe_mem3 PIPE PAGES 0 0 NO NO '' BACK
    medium_put BackPages2\mem4 \\.\pipe\pipe_mem4 PIPE PAGES 0 0 NO NO '' BACK
    medium_put BackLog \\.\pipe\pipe_mem5 PIPE LOG 0 0 NO NO '' BACK
    medium_put CompleteD G:\sdb\gb40\data\completeD FILE DATA 0 0 YES

UNIX Client

1. Log in to the database and run the following command from the dbm client interface:

   dbmcli -d <database name> -u <UserName,Password>

   Example

   Parameter	Value
   Database Name	cert1
   User Name	DBM
   Password	DBM

   bird:/opt/sdb# dbmcli -d cert1 -u DBM,DBM

2. Type the following commands to define the path for the stream/pipe:

   Note

   For each backup device, you must define two pipe mediums.

   You can specify any file path as a pipe and create the pipes in the operating system.

   Example

   Variable	Description
   BackData2	A vendor utility backup device that uses the DATA option and is used for full data backups.
   BackPages2	A vendor utility backup device that uses the PAGES option and is used for incremental data backups.
   BackLog	A vendor utility backup device that uses the LOG option and is used for log backups.

   medium_put BackData2\m0 /opt/sdb/testdb/files/m0 PIPE DATA 0 0 NO NO '' BACK 
    medium_put BackData2\m1 /opt/sdb/testdb/files/m1 PIPE DATA 0 0 NO NO '' BACK 
    medium_put BackPages2\m2 /opt/sdb/testdb/files/m2 PIPE PAGES 0 0 NO NO '' BACK 
    medium_put BACKPages2\m3 /opt/sdb/testdb/files/m3 PIPE PAGES 0 0 NO NO '' BACK 
    medium_put BackLog\m4 /opt/sdb/testdb/files/m4 PIPE LOG 0 0 NO NO '' BACK 
    medium_put CompleteF /opt/sdb/testdb/data/complete FILE DATA 0 0 YES

Example

numstreams 
 2 
 CvInstanceName 
 Instance001 
 CvClientName 
 magnum_SN