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.
<key_string> <value_string>
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 |
---|---|---|
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> |
- |
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. |
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 which of the NetWorker programs SAVE and RECOVER is started with the option -v |
NSR_NOTVERBOSE <option> <option> :: = NONE | SAVE | RECOVER | "SAVE AND RECOVER" |
You 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. |
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. |
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. |
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. |
Waiting time (in seconds) between two SAVE calls during parallel backups |
NSR_SAVEINTERVAL <time> |
Default value: 10 |
Name under which the backup in NetWorker should 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. |
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). |
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. |
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, you have to set them in single quotation marks. Note that backups that are not within the time span specified by the character string are regarded by MaxDB as no longer available for a restore. |
Client name which is used by Database Manager when calling the NetWorker program MMINFO as well as the NetWorker program SAVE where required. This name is used instead of the computer name supplied by the operating system. |
NSR_CLIENT |
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. |
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. |
Example: Configuration File for NetWorker