


nsrsyb(8)                                               nsrsyb(8)


NNAAMMEE
       nsrsyb - BusinesSuite Module for Sybase backup command

SSYYNNOOPPSSIISS
       nnssrrssyybb <<ssaavvee ooppttiioonnss>>

DDEESSCCRRIIPPTTIIOONN
       This shell script is used by ssaavveeggrrpp(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.

       nnssrrssyybb is only run by savegrp and is not run manually.  To
       use   this  command  for  scheduled  backups,  the  client
       resource (see nnssrr__cclliieenntt(5)) should  list  nnssrrssyybb  in  the
       _b_a_c_k_u_p  _c_o_m_m_a_n_d attribute, the Sybase SQL Server userid in
       the _u_s_e_r_n_a_m_e attribute, and the SQL Server password in the
       _p_a_s_s_w_o_r_d attribute.

       There  are several configurable variables users can set in
       the command to control backups to the NetWorker server.

       VVaarriiaabbllee:: USE_CONSISTENCY_CHECK
       DDeeffaauulltt vvaalluuee:: TRUE
       DDeessccrriippttiioonn:: This variable specifies  whether  a  database
       consistency  check should be constructed as the _P_R_E_C_M_D and
       issued before the scheduled backup.  The database  consis-
       tency  check  ensures  that  the  database  is not corrupt
       before it is backed up. There are cases where the underly-
       ing  dbcc  commands can incorrectly report errors when the
       _-_o _c_k_a_l option is set (which it is by default for  Systems
       prior  to  11.5.)   See  the nnssrrssyybbcccc(8) man page for more
       information.

       Note that if the consistency check is to be performed, the
       Sybase  _u_s_e_r_n_a_m_e  and  _p_a_s_s_w_o_r_d  specified  in  the client
       resource must have sufficient permissions to run the  dbcc
       command.   Although  an  account with the Sybase _o_p_e_r role
       has sufficient permissions for doing backups, it does  not
       have sufficient permissions for performing a database con-
       sistency check.

       VVaarriiaabbllee:: DBCCOPT
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn:: This specifies the _n_s_r_s_y_b_c_c 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 _n_s_r_s_y_b_c_c command are used.  See the man
       page for nnssrrssyybbcccc(8) for more information on  the  default
       consistency check options.

       VVaarriiaabbllee:: PRECMD
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn::  This  variable  can be used to run a command



NetWorker rt_1998_4Q.Build.MMaJrFcehra0l8_,0021000                        1





nsrsyb(8)                                               nsrsyb(8)


       before database backups.  If this  command  does  not  run
       successfully  (in  other  words,  if it returns a non-zero
       status), _n_s_r_s_y_b will  not  backup  the  database(s).   The
       _P_O_S_T_C_M_D  will  be  executed,  however.  If the _U_S_E___C_O_N_S_I_S_-
       _T_E_N_C_Y___C_H_E_C_K option is  TRUE  and  the  _P_R_E_C_M_D  is  set,  a
       database  consistency  check  will  not be performed.  If
       _U_S_E___C_O_N_S_I_S_T_E_N_C_Y___C_H_E_C_K is TRUE and the _P_R_E_C_M_D is  not  set,
       the  a  database  consistency check will be constructed as
       the _P_R_E_C_M_D_.

       VVaarriiaabbllee:: POSTCMD
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn:: This variable can be used to  run  a  command
       after  database  backups  have completed.  This command is
       always run, even if _n_s_r_s_y_b_s_v returns a non-zero exit code.

       VVaarriiaabbllee:: NSR_DATA_VOLUME_POOL
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn:: 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  pol-
       icy is set up at the server, backups will be directed into
       the default pool.

       VVaarriiaabbllee:: NSR_LOG_VOLUME_POOL
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn:: 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.

       VVaarriiaabbllee:: NSR_COMPRESSION
       DDeeffaauulltt vvaalluuee:: FALSE
       DDeessccrriippttiioonn::  This environment variable determines if com-
       pression is performed on the data.  The default  value  is
       _F_A_L_S_E  indicating  no  compression should take place.  Set
       this value to _T_R_U_E to turn on client-side compression.

       VVaarriiaabbllee:: PATH
       DDeeffaauulltt                     vvaalluuee::/bin:/usr/sbin:/opt/net-
       worker/bin:/usr/bin:/usr/sbin/nsr
       DDeessccrriippttiioonn::  Set up PATH environment variable.  This must
       be configured to include the path to  the  NetWorker  pro-
       grams nnssrrssyybbssvv(8), nnssrrssyybbcccc(8),aanndd mmmmiinnffoo(8).

       VVaarriiaabbllee:: SYBASE
       DDeeffaauulltt vvaalluuee:: NONE
       DDeessccrriippttiioonn::  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



NetWorker rt_1998_4Q.Build.MMaJrFcehra0l8_,0021000                        2





nsrsyb(8)                                               nsrsyb(8)


       file  in the user's home directory.  Because nsrsyb is run
       as root, it is extremely unlikely that the  Sybase  inter-
       faces file will be found in the user's home directory.


OOPPTTIIOONNSS
       Please  see  the  ssaavvee(8)  man  page  for a description of
       options supported  by  nnssrrssyybb..   There  are  a  number  of
       options   supported   by  ssaavvee(8)  that  are  accepted  by
       nnssrrssyybbssvv(8) but are  not  used.   See  the  man  page  for
       nnssrrssyybbssvv(8) for a description of which options are used by
       nnssrrssyybbssvv(8).

SSEEEE AALLSSOO
       mmmmiinnffoo(8),   nnssrr__cclliieenntt(5),   nnssrrssyybbssvv(8),    nnssrrssyybbcccc(8),
       nnssrr__ppooooll(5), nnwwaaddmmiinn(8), ssaavvee(8), ssaavveeggrrpp(8).

DDIIAAGGNNOOSSTTIICCSS
   EExxiitt CCooddeess
       00      Normal  exit. This means that the save set was cor-
              rectly created on the server.
       11      Abnormal exit.  A save set was not  correctly  cre-
              ated on the server.

   MMeessssaaggeess
       This  is  a  listing of messages that nnssrrssyybb can generate.
       It may also produce any errors that nnssrrssyybbssvv and  nnssrrssyybbcccc
       can generate.

       nnssrrssyybbssvv rreettuurrnneedd ssttaattuuss ooff _n_u_m_b_e_r
              nnssrrssyybb eexxiittiinngg..

              This  indicates  that  nsrsybsv returned a non-zero
              status and that the save set was not correctly cre-
              ated on the server.






















NetWorker rt_1998_4Q.Build.MMaJrFcehra0l8_,0021000                        3


