Chat now with support
Chat with Support

NetVault Plug-in for Sybase 11.4.5 - User Guide

Configuration prerequisites

With the plug-in installed and before configuring the database environment through the NetVault Backup WebUI, ensure that the SAP ASE Server is up and running. Also verify that the SAP ASE administrator password is usable, not blank.

Checking the status of the SAP ASE Server on Linux or UNIX

1
Initiate a terminal session on the SAP ASE Server.
2
Navigate to the directory containing the SAP ASE “showserver” utility.
For example, in an environment running SAP ASE version 15.0, this utility resides in the following subdirectory of the SAP ASE installation directory, where “…” represents the path to the SAP ASE installation:
…/ASE-15_0/install/
3
From the command prompt, issue the command showserver.
In the following example, the database server is named rlgsw14.
rlgsw14# showserver
UIDPIDPPIDCSTIMETTYTIMECMD
sybase344343013:48:24pts/20:00/opt/sybase/bin/backupser
ver -SSYB_BACKUP -e/opt/sybase/install
sybase338337013:48:08?0:03/opt/sybase/bin/dataserver
r -srlgsw14 -d/opt/sybase/master.datdataserver
4
After issuing the showserver command, note whether the “-s” argument for the data server is displayed at the beginning of the argument; for example, “r -srlgsw14…”, as shown in the last line of the example.
•
If the “-s” argument is displayed, the SAP ASE Server is ready for use with the Plug‑in for SAP ASE.
•
If the “-s” argument for the data server does not appear at the beginning of the argument, NetVault Backup cannot look up the server name. In this case, perform the following steps:
a
Locate the “RUN_<server name>” file, for example, RUN_rlgsw14, as shown in the following example, at:
$SYBASE/install/
b
Edit the content of the “RUN_<serverName>” file so that NetVault Backup can successfully locate the database server name from the [dataserver] command by adding the “-s” argument.
By doing so, the command outputs the “-s” argument information first.
#! /bin/sh
#
# Adaptive Server name: rlgsw14
# Master device path: /opt/sybase/master.dat
# Error log path: /opt/sybase/install/rlgsw14.log
# Directory for shared memory files: /opt/sybase
# /opt/sybase/bin/dataserver
-srlgsw14 <----------- Note: This line was added here.
-d/opt/sybase/master.dat
-e/opt/sybase/install/rlgsw14.log
-M/opt/sybase
c
Restart the SAP ASE Server.

Setting the administrator's password

Setting the administrator’s password

The SAP ASE administrator’s password must not be set to a null value, that is, an actual value must exist. In the following example, syntax is used to create a password for the “sa” account, which currently has no password it is set to the null value. The password is changed to “NetVault”. You can select any password, that is, the password does not have to be “NetVault.”

The sp_password command is followed by the existing password, followed by the new password (NetVault), and finally the user.

#isql-Usa-P-Sbakbone
1>sp_password NULL,NetVault,sa
2>go
3>exit
#isql-Usa-PNetVault-Sbakbone

Configuring default settings

The plug-in lets you set default options for backup and restore jobs. You can override these options on a per-job basis.

1
In the Navigation pane of the NetVault Backup WebUI on the NetVault Backup Server, click Create Backup Job, and click Create New next to the Selections list.
2
In the selection tree, open the applicable client node, and select Plug‑in for SAP ASE.
3
From the Actions list, select Configure.
4
On the Configure dialog box, complete the applicable fields:
•
Sybase Installation Directory: In this field, input the exact path to the local installation of the SAP ASE Server software.
•
Sybase SYBASE_OCS: Enter the name of the subdirectory in the SAP ASE installation directory that contains the SAP ASE library files, for example, files such as “libinsck” and “libtli.” For SAP ASE 15.0 or 15.5, enter OCS-15_0.
•
Sybase SYBASE_ASE: Enter the name of the subdirectory in the SAP ASE installation directory that contains the scripts used to run the SAP ASE service. For SAP ASE 15.0 or 15.5, enter ASE-15_0.
•
Default Account Name: Enter the appropriate account name in this field. Obtain this information from your SAP ASE DBA.
 
* 
NOTE: Starting with SAP ASE 15.0, SAP ASE Servers support password encryption and extended password encryption. The plug-in supports encryption and handles it automatically, depending on how you have configured passwords on the SAP ASE Client.
•
Sybase Severity to become a NetVault Error Message: Set the severity level in this box to filter SAP ASE error messages. The higher the value, the more likely that NetVault Backup records these items in the logs. For example, if the severity level is a 9, any SAP ASE errors with a severity level of 10 or higher would not be displayed.
•
Sybase Timeout uses by the Client Library APIs: Set the SAP ASE timeout period, in milliseconds in this box. The Client Library APIs will time out after the interval specified here.
If you do not want the plug-in to wait for the result of the operations — results are handled when they are available — and to time out if the connection with the SAP ASE Server does not occur, enter a 0. Otherwise, use a value other than 0 to instruct the plug-in to wait for operations to finish.
 
* 
IMPORTANT: If the Plug‑in for SAP ASE stops responding during a browse or backup operation, adjust or change the timeout value. The default value is 0. Different versions of SAP ASE might require the use of different values.
5
To save the settings, click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating