nsrsyb(8)

NAME
nsrsyb - BusinesSuite Module for Sybase backup command

SYNOPSIS
nsrsyb <save options>

DESCRIPTION

This shell script is used by savegrp(8) to trigger backups on a Sybase SQL Server. This command sets environment variables, constructs a database consistency check PRECMD by default, and calls nsrsybsv to perform the backups. nsrsyb is only run by savegrp and is not run manually. To use this command for scheduled backups, the client resource (see nsr_client(5)) should list nsrsyb in the backup command attribute, the Sybase SQL Server userid in the username attribute, and the SQL Server password in the password attribute.

There are several configurable variables users can set in the command to control backups to the NetWorker server. Variable: USE_CONSISTENCY_CHECK
Default value: TRUE
Description: This variable specifies whether a database consistency check should be constructed as the PRECMD and issued before the scheduled backup. The database consistency check ensures that the database is not corrupt before it is backed up. There are cases where the underlying dbcc commands can incorrectly report errors when the -o ckal option is set (which it is by default for Systems prior to 11.5.) See the nsrsybcc(8) man page for more information. Note that if the consistency check is to be performed, the Sybase username and password specified in the client resource must have sufficient permissions to run the dbcc command. Although an account with the Sybase oper role has sufficient permissions for doing backups, it does not have sufficient permissions for performing a database consistency check. Variable: DBCCOPT
Default value: NONE
Description: This specifies the nsrsybcc options that are to be used for the database consistency check. The default value for this is none, which means that the defaults from the nsrsybcc command are used. See the man page for nsrsybcc(8) for more information on the default consistency check options. Variable: PRECMD
Default value: NONE
Description: This variable can be used to run a command before database backups. If this command does not run successfully (in other words, if it returns a non-zero status), nsrsyb will not backup the database(s). The POSTCMD will be executed, however. If the USE_CONSISTENCY_CHECK option is TRUE and the PRECMD is set, a database consistency check will not be performed. If USE_CONSISTENCY_CHECK is TRUE and the PRECMD is not set, the a database consistency check will be constructed as the PRECMD. Variable: POSTCMD
Default value: NONE
Description: This variable can be used to run a command after database backups have completed. This command is always run, even if nsrsybsv returns a non-zero exit code. Variable: NSR_DATA_VOLUME_POOL
Default value: NONE
Description: If this variable is set to name a media pool, then database (full) backups will be directed to the given media pool. If this is not set, then backups will be directed to pools based on the server policy. If no policy is set up at the server, backups will be directed into the default pool. Variable: NSR_LOG_VOLUME_POOL
Default value: NONE
Description: If this variable is set to name a media pool, then transaction log (incremental) backups will be directed to the given media pool. If this is not set, then backups will be directory to pools based on the server policy. If no policy is set up at the server, backups will be directed into the default pool. Variable: NSR_COMPRESSION
Default value: FALSE
Description: This environment variable determines if compression is performed on the data. The default value is FALSE indicating no compression should take place. Set this value to TRUE to turn on client-side compression. Variable: PATH
Default value:/bin:/usr/sbin:/opt/networker/bin:/usr/bin:/usr/sbin/nsr
Description: Set up PATH environment variable. This must be configured to include the path to the NetWorker programs nsrsybsv(8), nsrsybcc(8),and mminfo(8). Variable: SYBASE
Default value: NONE
Description: Set this variable to the directory where the Sybase "interfaces" file exists. This is the top level directory in which Sybase SQL Server was installed. If this is not set, then Sybase will look for the interfaces file in the user's home directory. Because nsrsyb is run as root, it is extremely unlikely that the Sybase interfaces file will be found in the user's home directory.

OPTIONS
Please see the save(8) man page for a description of options supported by nsrsyb. There are a number of options supported by save(8) that are accepted by nsrsybsv(8) but are not used. See the man page for nsrsybsv(8) for a description of which options are used by nsrsybsv(8).

SEE ALSO
mminfo(8), nsr_client(5), nsrsybsv(8), nsrsybcc(8), nsr_pool(5), nwadmin(8), save(8), savegrp(8).

DIAGNOSTICS

  Exit Codes
0   Normal exit. This means that the save set was correctly created on the server.
1   Abnormal exit. A save set was not correctly created on the server.

  Messages
This is a listing of messages that nsrsyb can generate. It may also produce any errors that nsrsybsv and nsrsybcc can generate.

nsrsybsv returned status of number
    nsrsyb exiting. This indicates that nsrsybsv returned a non-zero status and that the save set was not correctly created on the server.