Events Calendar

«
<
September 2010
>
»
M T W T F S S
30 31 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 1 2 3

Select Language

Quick start Data Protector for Sybase ASE PDF Print E-mail
Written by Tomas Dalebjörk   
Friday, 01 May 2009 06:42

Quick Start Guide

for 

Data Protector for Sybase ASE

using IBM Tivoli Storage Manager

 

 Linux

Sybase server

Install the Sybase server binaries

download

# rpm -i XX

TSM Client

Install the Tivoli Storage Manager (Backup Archive Client)

download

# rpm -i XXX

Install the Data Protector for Sybase

download 

# rpm -i XXX 

Configure the TSM server

Setup the copygroups, policysets, domains, and retention times.

Create the backup schedule

# dsmadmc

tsmserv>define domain sybase
tsmserv>define policyset sybase standard
tsmserv>define mgmt sybase standard 30days dest=backuppool verd=nol vere=nol reto=30 rete=30
tsmserv>assign defmgmt sybase standard 30days 
tsmserv>validate policyset sybase standard
tsmserv>activate sybase standard
tsmserv>register node sybase domain=sybase

tsmserv>def sched sybase full action=command objects="/usr/local/bin/backup.sh" startt=21:00 startd=today dur=2 duru=hour 
tsmserv>define associations sybase full sybase 

Configure the TSM client

Filesystem setup

# vi /opt/tivoli/tsm/client/ba/bin/dsm.opt

SE filesystem

 # vi /opt/tivoli/tsm/client/ba/bin/dsm.sys

 

SE filesystem

TCPSERVERADDRESS 10.11.12.13

SCHEDLOGNAME /var/log/dsmsched.log

ERRORLOGNAME /var/log/dsmerror.log

PASSWORDACCESS generate

 

SE mysql

TCPSERVERADDRESS 10.11.12.13

SCHEDLOGNAME /var/log/dsmsched_sybase.log

ERRORLOGNAME /var/log/dsmerror_sybase.log

PASSWORDACCESS generate

NODENAME sybase
 
# ln -s /opt/tivol/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin/dsm.sys
# vi /opt/tivoli/tsm/client/ba/bin/dsm.opt

SE filesystem

 
Try a connectivity test to the TSM server
 
# dsmc -se=sybase
 
Create the backup scripts
 
# vi /usr/local/bin/backup.sh

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4Sybase/bin:/opt/sybase/OSC-15_0/bin

sybasebackup -v -u sa -p password -S instancename -a >> /var/log/sybasebackup.log 2>&1

 
# chmod a+x /usr/local/bin/backup.sh
 
Try to do a backup
 
# /usr/local/bin/backup.sh
 
Create the scheduler startup
# vi /etc/init.d/tsmsyb

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4Sybase/bin:/opt/sybase/OCS-15_0/bin

case $1 in

   start)

            nohup dsmc -se=sybase quiet &

            ;;

esac

# chmod a+x /etc/init.d/tsmsyb
# ln -s /etc/init.d/tsmsyb /etc/rc2.d/S99tsmsyb
 
Startup the service, and verify that the service gets a schedule
 
# /etc/init.d/tsmsyb start
# cat /var/log/dsmsched_sybase.log
 
Repostor : Your recovery expert