Support for remote backupserver configurations with Delphix 4.2.x and SAP ASE
Let's say you have a sybase host, and target, and perhaps even a staging host where you would like to link a dsource on a remote host from a new full backup, most recent backup, or a specific backup filename.
In this example, the dump is taken from the source ASE onto the source host file system.
Let's say that the target/staging ASE instance name is RH65_ASE16_TGT_S1
local backupserver name is SYBASE_01_BS
database name is 'bucks'
the source host name is tacksyb16-src
and the target host name is tacksyb16-tgt
After you have successfully discovered the SAP ASE environments, select a source database to create a dsource.
From the source host, login to the ASE using isql and dump the database.
1> dump database bucks to '/tmp/backups/bucks.dmp'
2> go
The source server is the remote, relative to the target/staging server.
So, in the Add Dsource gui wizard:
The backup location is on the source host. /tmp/backups
The field "load backup server name" is set to the source host backupserver. SYBASE_01_BS
The staging host is tacksyb16-tgt.
Once you have selected the staging host, it will list the discovered ASE instances on that host.
Pick the one that you want. In the example below, it is RH65_ASE16_TGT_S1
The remote backupserver is checked and the same source host backupserver is listed in the server name field. SYBASE_01_BS
The remote host field is actually the source, tacksyb16-src.
The remote user is the OS user you have on tacksyb16-src. In my example below, sybase.
To do this, you need this backupserver listed in the target/staging ASE instance master..sysservers table and the correct entry in the target/staging host interfaces file for SYBASE_01_BS.
sql to staging host:
Here is an example:
1> select srvname, srvnetname, srvclass from master..sysservers where name = 'SYBASE_01_BS'
2> go
srvname srvnetname srvclass
---------------------------------- ----------------------------------------
SYBASE_01_BS SYBASE_01_BS ASEnterprise
if it doesn't exist, or is incorrect, run this command:
sp_addserver SYBASE_01_BS
go
Then exit out and check the interfaces file:
vi $SYBASE/interfaces
SYBASE_01_BS
master tcp ether {hostname_or_ip_of_source} {port}
query tcp ether {hostname_or_ip_of_source} {port}
Select “most recent backup”, and it should work.
Using the source backup server to dump to the staging backup server is not supported. Only load database/tranlog is supported.
#Tip