You configure the MaxDB software with the aim of connecting the MaxDB database tools for backing up, restoring, importing, or exporting data to the backup tool NetWorker.
You specify a parameter of the Database Manager in every line in the configuration file. When you do this, at the beginning of each line you have to specify the keyword for the parameter and then the relevant value(s). Lines that do not begin with keywords are ignored by the system.
<key_string> <value_string>
<key_string> |
Keyword for a parameter; can consist of one or more words |
<value_string> |
Value(s) of the parameter |
You can define the following parameters for connecting NetWorker and the Database Manager:
Parameter |
Syntax |
Description |
Absolute path of the directory where NetWorker is installed |
NSR_HOME <absolute_path> |
The NetWorker programs SAVE, MMINFO, and RECOVER are 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 that was configured in NetWorker. |
Expiry date or period of the backup |
NSR_EXPIRE <value> |
This value is transferred to the NetWorker program SAVE and overwrites the default value for the expiry date or expiry period that was configured in NetWorker. See the NetWorker documentation for the allowed entries. |
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" |
This value is required in case the NetWorker programs do not support the –v option. NONE: Default value SAVE: SAVE is started without and RECOVER is started with the -v option. RECOVER: SAVE is started with and RECOVER is started without the -v option. "SAVE AND RECOVER": SAVE and RECOVER are started without the -v option. |
Specifies whether the output of the NetWorker program SAVE is analyzed when backups take place |
NSR_USEOUTPUT <option> <option> ::= SAVE | NONE |
SAVE: Default value NONE: The output of SAVE is not checked for error messages. Only the return code of SAVE is used. Since SAVE can return the value 0 even if errors occur, do not use NONE. |
Error messages of the NetWorker program SAVE that can be ignored |
NSR_IGNOREERROR <error_text> |
All error messages of the form <pipe_name>:<error_text> are ignored. Repeat this parameter definition for each error message that can be ignored. |
Specifies whether the Database Manager uses (for recoveries) the backup times or the NetWorker save set identifiers |
NSR_EBIDTYPE <option> <option> ::= NSAVETIME | SSID |
NSAVETIME: Default value 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 you want to save the backup in NetWorker |
NSR_BACKUPNAME <name> |
Default value: Name of the database instance Any string of characters that can contain the placeholders <database_name> and/or <node>. When backing up or restoring with NetWorker, the placeholders are replaced with the name of the database instance and/or the database computer. |
Avoiding a NetWorker software error |
NSR_AVOIDPSSIDBUG <option> <option> ::= YES | NO |
A software error
in the MMINFO program when using the option -q
pssid=0 (PSSID bug) is
known as of NetWorker 6.0. You can avoid this error by setting this
parameter. |
Date format that is 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>::= character which does not occur in <date_time_format>, <AM_definition> and <PM_definition> <separator>::= with missing <separator_definition> (',') otherwise <new_separator> <datetime_format>::= { <year> | <month> | <day> | <hour> | <minute> | <second> | <AM> | <PM> [<datetime_separator>] } <datetime_separator>::= any character except 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>::= any character string without the character <separator>
<PM_definition>::=PM=<local_PM_string> <local_PM_string>::= any character string without the character <separator> |
Required if current default value does not correspond to NetWorker output. Default values
are mm/dd/yyyy HH:MM:SS AM: for date output from NetWorker that is more than 10 characters long You can only configure one format. This can be a format that differs from the default values as long as the specified syntax elements are used. yy|yyyy year, mm month, dd day, HH hour, MM minute, SS second, AM | PM a.m. or p.m. |
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 |
Required if the size that was transferred by SAVE for the backup is rounded off. This parameter can be used for the following database versions as of the specified build numbers only: 7.2.05 from build 017, 7.3.00 from build 021, 7.4.03 from build 000. NOROUNDUP: Default value FIRSTDECIMAL: The size specification is increased by 0.1 (For example: Backup size 14 GB is used with 14.1 GB). NORMAL: The size specification is increased by 0.5. LASTINTEGER: The size specification is increased by 1. |
Character string that is used as the value for the MMINFO option –t |
NSR_AVOIDTIMEBUG <value> |
Required if MMINFO from NetWorker does not work without option –t This parameter can be used for the following database versions as of the specified build numbers only: 7.2.05 as of build 018, 7.3.00 as of build 022, 7.4.02 as of build 004, 7.4.03 as of 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 quotation marks. |
Client name that is used by the Database Manager when calling up the Networker Program MMINFO and also the NetWorker Program SAVE, if necessary. This is used instead of the computer name supplied by the operating system. |
NSR_CLIENT |
Can only be used with the database version 7.3.0 as of Build 032, 7.4.3 as of Build 010 or database versions larger/the same as 7.5 and has to match the client name configured in the NetWorker. Once this client name has been initially specified or changed then any backups executed prior to that can only be accessed like backups from another client. They are identified as UNAVAILABLE in the backup history. Their availability can only be determined by using the DBM command backup_ext_ids_get The previous client name should be given here as a parameter instead of the database server. There are no other restrictions when restoring. |
Determines how the selected value for NSR_CLIENT is used. |
NSR_USECLIENTFOR <option> <option> ::="SAVE and MMINFO" | MMINFO
|
MMINFO: Default value. The selected value for NSR_CLIENT is only used for the NetWorker Program MMINFO. SAVE and MMINFO: The selected value for NSR_CLIENT is used for the NetWorker program SAVE and MMINFO. In this way, you can use a logical computer name for backups or specifically use a second network card. If you select the value „SAVE and MMINFO” you are check ing whether a backup is being executed with your NetWorker version and your configuration and if it can be restored. If the backup cannot be restored then select the default value MMINFO for the parameter NSR_USECLIENTFOR and contact your NetWorker support. |
See also:
Example of a Configuration File