Show TOC

Creating the Configuration File for NetWorkerLocate this document in the navigation structure

Procedure

Creating the configuration file for NetWorker is a necessary step for connecting SAP MaxDB to NetWorker. By means of this configuration file, you inform Database Manager where the Networker program is located and how to address it.

Specify a parameter of Database Manager in each line in the configuration file. Specify the keyword for the parameter at the beginning of each line and then the relevant value(s).

Lines that do not begin with keywords are ignored by the system.

Syntax

<key_string> <value_string>

Table 1: Options

Option

Description

<key_string>

Keyword for a parameter

Can consist of one or more words

<value_string>

Value(s) of the parameter

Define the following parameters for connecting NetWorker to Database Manager:

Parameters

Syntax

Description

Transfers any additional parameter that can be specified for the NetWorker program MMINFO

NSR_ADDITIONAL_MMINFO_PARAMETERS <value>

This value is transferred to the NetWorker program MMINFO.

See the NetWorker documentation for permitted entries.

Transfers any additional parameter that can be specified for the NetWorker program RECOVER

NSR_ADDITIONAL_RECOVER_PARAMETERS <value>

This value is transferred to the NetWorker program RECOVER.

See the NetWorker documentation for permitted entries.

Transfers any additional parameter that can be specified for the NetWorker program SAVE

NSR_ADDITIONAL_SAVE_PARAMETERS <value>

This value is transferred to the NetWorker program SAVE.

See the NetWorker documentation for permitted entries.

Avoids a NetWorker software error

NSR_AVOIDPSSIDBUG <option>

<option> :: = NO | YES | "WITHOUT DOUBLE QUOTES"

As of NetWorker 6.0, a known software error exists in the MMINFO program when using the option -q pssid=0 (PSSID bug). You can avoid the error by defining this parameter.

NO: The NetWorker program MMINFO is called with the option -q pssid=0 (default value)

YES: The system inserts the option -o "VSS:*=off" into the NetWorker parameter list, thus getting around the software error in the MMINFO program (only for NetWorker).

"WITHOUT DOUBLE QUOTES": The system inserts the option -o VSS:*=off into the list of networker parameters and thus gets around the software error in the MMINFO program (only for NetWorker).

Character string which is used as the value for the MMINFO option -t

NSR_AVOIDTIMEBUG <value>

This specification is necessary for cases in which the NetWorker program MMINFO does not work without the option -t.

This parameter can only be used for the following database version as of the specified build numbers: 7.2.05 from build 018, 7.3.00 from build 022, 7.4.02 from build 004, 7.4.03 from build 000.

The character string must match the format expected by MMINFO. If the character string consists of multiple words, set them in single quotation marks.

Note that backups not made within the time span specified by the character string, are regarded as no longer available for restore by the database system.

Defines whether the -o option of the NetWorker SAVE program is used

NSR_AVOIDVSSBUG <value>

This specification is necessary for cases in which the NetWorker program SAVE does not work without the -o option.

Name under which the backup in NetWorker is to be saved

NSR_BACKUPNAME <name>

Any string of characters which can contain the placeholders <database_name> and/or <node>.

Default value: database name

When backing up or restoring with NetWorker, the placeholders are replaced with the database name and/or the database computer.

Client name used by Database Manager when calling the NetWorker programs MMINFO and SAVE

This name is used instead of the computer name supplied by the operating system.

NSR_CLIENT <value>

The value of this parameter must match the client name configured in NetWorker.

Once this client name has been specified or changed for the first time, any backups executed previously can only be accessed as backups from another client. These are identified as UNAVAILABLE in the backup history. Their availability can only be determined using the DBM command backup_ext_ids_get. When using this command, the previous client name and not the database computer must be entered as a parameter.

There are no other restrictions when restoring.

Specifies whether Database Manager uses backup times or NetWorker Save Set Identifiers (for restores)

NSR_EBIDTYPE <option>

<option> :: := NSAVETIME | SSID

NSAVETIME: Backups are identified by means of their backup time (default value)

This is also the recommended value since the NetWorker program RECOVER does not require any operating system user rights.

SSID: Backups are identified using the NetWorker Save Set Identifier.

Expiry date or shelf-life of backup

NSR_EXPIRE <value>

This value is transferred to the NetWorker program SAVE and overwrites the default value for the expiry date or shelf-life which was configured in NetWorker.

See the NetWorker documentation for permitted entries.

Specifies how the level specification for backups transferred with the NetWorker SAVE program is to be used,

only relevant for SAP MaxDB version 7.9.00 to 7.9.03

NSR_FULL <option>

<option> :: = SAVEDATA | DATA MIGRATION | SAVEDTNCHK | DATA RECOVERY | SAVEDATA+SAVEDTNCHK | DATA MIGRATION+DATA RECOVERY | DATA RECOVERY+DATA MIGRATION

The value is transferred to the NetWorker program.The parameter value controls which database backups made by NetWorker are marked as complete backups. This way, an additional information about the consistency of the backup is transferred to the NetWorker tool.

The parameter had special importance in previous database versions when the database system distinguished between backups for recovery (inconsistent backups) and backups for migration (consistent backups).

SAVEDATA | DATA MIGRATION: Only complete data backups made using the additional option for migration are flagged as full in NetWorker

SAVEDTNCHK | DATA RECOVERY:Only complete data backups made using without the additional option for migration are flagged as full in NetWorker.

SAVEDATA+SAVEDTNCHK | DATA MIGRATION+DATA RECOVERY | DATA RECOVERY+DATA MIGRATION: All complete data backups are flagged as full in NetWorker.

As per the system default value, a complete data backup using NetWorker is not marked as full.

See also the NetWorker documentation.

Absolute path of the directory where NetWorker is installed

NSR_HOME <absolute_path>

The NetWorker programs SAVE, MMINFO, and RECOVER are stored in this directory.

Name of the NetWorker server

NSR_HOST <name>

-

Error messages of the NetWorker program SAVE to be ignored

NSR_IGNOREERROR <error_text>

All error messages in the form <pipe_name>:<error_text> are ignored.

Repeat this parameter definition for each error message to be ignored.

Defines how the NetWorker backup tool should flag the level for all pipes of a complete data backup

Valid from SAP MaxDB Version 7.9.04

NSR_LEVELCOMPLETE <value>

The default values are as follows:

  • For the first pipe of a complete data backup: FULL

  • For all other pipes of a complete data backup: 4

The parameter value can be overruled for the first pipe using the NSR_LEVELCOMPLETE1ST parameter.

Defines how the NetWorker backup tool should flag the level for the first pipe of a complete data backup

Valid from SAP MaxDB Version 7.9.04

NSR_LEVELCOMPLETE1ST <value>

Default value: FULL

Overrules the value of the NSR_LEVELCOMPLETE parameter for the first pipe.

Defines how the NetWorker backup tool should flag the level for all pipes of an incremental data backup

Valid from SAP MaxDB Version 7.9.04

NSR_LEVELINCREMENTAL <value>

Default value: 6

The parameter value can be overruled for the first pip using the NSR_LEVELINCREMENTAL1ST parameter.

Defines how the NetWorker backup tool should flag the level for the first pipe of an incremental data backup

Valid from SAP MaxDB Version 7.9.04

NSR_LEVELINCREMENTAL1ST <value>

Default value: 6

Overrules the value of the NSR_LEVELINCREMENTAL parameter for the first pipe.

Defines how the NetWorker backup tool should flag the level for a pipe of a log backup

Valid from SAP MaxDB Version 7.9.04

NSR_LEVELLOG <value>

Default value: 9

From version 7.4, patch 4, NetWorker does not accept the -l option in the configuration any more. SAP MaxDB can use the -l option only if the variable NSR_MAST=nsradmin was set in the environment.

Valid from SAP MaxDB Version 7.9.04

NSR_MAST <definition>

<definition> :: = "" | <value>

SAP MaxDB uses the -l option of the NetWorker SAVE command to assign a level to a backup.

As per the system default, the DBM server sets the parameter NSR_MAST to the value nsradmin and overwrites an existing definition for this variable.

You can suppress this behavior if you enter MAST "" in the configuration file. This does not delete an existing definition in the configuration file.

To define a value for this parameter, enter the line NSR_MAST <value> in the file.

Specifies which of the NetWorker programs SAVE and RECOVER is started with the -v option

NSR_NOTVERBOSE <option>

<option> :: = NONE | SAVE | RECOVER | "SAVE AND RECOVER"

Set this parameter in cases in which the NetWorker programs do not support this option.

NONE: The NetWorker programs SAVE and RECOVER are started with the option -v (default value)

SAVE: The NetWorker program SAVE is started without the -v option whereas the NetWorker program RECOVER is started with the -v option.

RECOVER: The NetWorker program SAVE is started with the -v option whereas the NetWorker program RECOVER is started without the -v option.

"SAVE AND RECOVER": The NetWorker programs SAVE and RECOVER are started without the -v option.

Name of the NetWorker tape pool

NSR_POOL <name>

If you specify a name, it overwrites the default value for the tape pool which was configured in NetWorker.

Waiting time (in seconds) between two SAVE calls during parallel backups

NSR_SAVEINTERVAL <time>

Default value: 10

Date format used for analyzing the output of the NetWorker program MMINFO

NSR_SAVETIMEFORMAT <format>

<format> :: =[<separator_definition><separator>]<datetime_format>[<separator><AM_definition>][<separator><PM_definition>]

<separator_definition> :: = SEPARATOR=<new_separator>

<new_separator> ::= sign that does not occur in <date_time_format>, <AM_definition> and <PM_definition>

<separator> :: = when <separator_definition> is missing, the comma sign (' ,'), otherwise <new_separator>

<datetime_format> :: = { <year> | <month> | <day> | <hour> | <minute> | <second> | <AM> | <PM> [<datetime_separator>] }

<datetime_separator> :: = ein beliebiges Zeichen außer y, m, d, H, M, S, a, A, p, P

<year> :: = yy | yyyy

<month> :: = mm

<day> :: = dd

<hour> :: = HH

<minute> :: = MM

<second> :: = SS

<AM> :: = am | AM | a.m. | A.M.

<PM> :: = pm | PM | p.m. | P.M.

<AM_definition> :: = AM=<local_AM_string>

<local_AM_string> :: = string in any order without the sign <separator>

<PM_definition> :: = PM=<local_PM_string>

<local_PM_string> :: = string in any order without the sign <separator>

This specification is required for cases in which the current default value does not correspond to the NetWorker output.

Default values are mm/dd/yy HH:MM:SS AM: for NetWorker data outputs that are 8 characters long or

mm/dd/yyyy HH:MM:SS AM: for NetWorker date outputs that are 10 characters long.

You can only configure one format. This format is allowed to differ from the default values, providing that the specified syntax elements are used.

yy|yyyy: Year

mm: Month

dd: Day

HH: Hour

MM: Minute

SS: Second

AM | PM: in the morning or in the afternoon

Specifies how the size specification for backups transferred with the NetWorker SAVE program is to be used

NSR_SIZEROUNDUP <option>

<option> :: = NOROUNDUP | FIRSTDECIMAL | NORMAL | LASTINTEGER

This specification is necessary for cases in which the size transferred by the NetWorker program SAVE is rounded down for the backup.

NOROUNDUP: Default value. The size specification is used without being changed.

FIRSTDECIMAL: The size specification is increased by 0.1. (For example: backup size 14 GB continues to be used with 14.1 GB).

NORMAL: The size specification is increased by 0.5.

LASTINTEGER: The size specification is increased by 1.

Definition of how the value selected for NSR_CLIENT is to be used.

NSR_USECLIENTFOR <option>

<option> :: = "SAVE and MMINFO" | MMINFO

MMINFO: The selected value for NSR_CLIENT is only used for the NetWorker program MMINFO (default value).

"SAVE and MMINFO": The selected value for NSR_CLIENT is used for the NetWorker programs SAVE and MMINFO. This enables you to use a logical computer name for backups or a second network card.

By specifying "SAVE and MMINFO", you can check whether a backup is being executed with your NetWorker version and configuration and whether this is restorable. If the backup cannot be restored, select the default value MMINFO for the NSR_USECLIENTFOR parameter and contact NetWorker support.

Specifies how many .nsr files are to be used with the -f option of the Networker SAVE program

NSR_USE.NSRFILE <option>

<option> :: = YES | NO

Relevant on Unix only

YES: One common .nsr file is to be used for all backup pipes

NO: One .<pipename> file per backup pipe is to be used

The system default value is NO.

Specifies whether the output of the NetWorker program SAVE should be analyzed

NSR_USEOUTPUT <option>

<option> ::= SAVE | NONE

SAVE: The output of the NetWorker SAVE program is checked for error messages (default value).

NONE: The output of the NetWorker program SAVE is not checked for error messages. Only the return code of the program is used.

Since the program SAVE can also return the value 0 in the case of an error, we recommend that you do not use the value NONE.

More Information