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

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
```

Parameter	Value
Database Name	cert1
User Name	DBM
Password	DBM

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.

dbmcli on testdb> backup_template_create BackData2 TO BACKUPTOOL BACKINT PIPE \\.\pipe\pipe_mem1 NAMED mem1 PIPE \\.\pipe\pipe_mem2 NAMED mem2 CONTENT DATA BLOCKSIZE 8

dbmcli on testdb> backup_template_create BackPages2 TO BACKUPTOOL BACKINT PIPE \\.\pipe\pipe_mem3 NAMED mem3 PIPE \\.\pipe\pipe_mem4 NAMED mem4 CONTENT INCREMENTAL BLOCKSIZE 8

dbmcli on testdb> backup_template_create BackLog TO BACKUPTOOL BACKINT PIPE \\.\pipe\pipe_mem5 NAMED mem5 CONTENT LOG BLOCKSIZE 8

UNIX Client

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
```

Parameter	Value
Database Name	cert1
User Name	DBM
Password	DBM

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.

dbmcli on testdb> backup_template_create BackData2 TO BACKUPTOOL BACKINT PIPE /sapdb/testdb/files/m0 NAMED m0 PIPE /sapdb/testdb/files/m1 NAMED m1 CONTENT DATA BLOCKSIZE 8

dbmcli on testdb> backup_template_create BackPages2 TO BACKUPTOOL BACKINT PIPE /sapdb/testdb/files/m2 NAMED m2 PIPE /sapdb/testdb/files/m3 NAMED m3 CONTENT INCREMENTAL BLOCKSIZE 8

dbmcli on testdb> backup_template_create BackLog TO BACKUPTOOL BACKINT PIPE /sapdb/testdb/files/m4 NAMED m4 CONTENT LOG BLOCKSIZE 8

Example

numstreams 
 2 
 CvInstanceName 
 Instance001 
 CvClientName 
 magnum_SN