Backup of Sybase IQ Server with IBM Tivoli Storage Manager (TSM)

To backup Sybase IQ Server to TSM requires:

• 1. API
     
  2. baclient
     
• repostor device driver
  
• 1. rdpdev
     
• repostor Data Protector for Sybase IQ using IBM Tivoli Storage Manager
  
• 1. rdp4SybaseIQ
     
• Linux operating system
  
• 1. SLES
     
  2. RHEL
     

Installation is simple.

Download the neede softwares from the IBM ftp server

     ftp://service.boulder.ibm.com/storage/tivoli-storage-management/

Download the device driver and repostor Data Protector software

     http://repostor.com

Install the softwares:

# rpm -i XXX.rpm

start up the device driver

# /etc/init.d/rdpdev start

setup the TSM by creating the dsm.opt / dsm.sys

# vi /path/to/your/dsm.opt

SE iq

# vi /opt/tivoli/tsm/client/api/bin64/dsm.sys

SE iq

TCPSERVERADDRESS backup.server.com

SCHEDLOGNAME /path/to/your/dsmsched.log

ERRORLOGNAME /path/to/your/dsmerror.log

PASSWORDACCESS GENERATE

NODENAME your-iq-nodename-in-tsm

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

SE iq

TCPSERVERADDRESS backup.server.com

SCHEDLOGNAME /path/to/your/dsmsched.log

ERRORLOGNAME /path/to/your/dsmerror.log

PASSWORDACCESS GENERATE

NODENAME your-iq-nodename-in-tsm

Register the node and save the password

# dsmc -se=iq

Set the environment to IQ Server

# . /opt/sybase/sybase.sh

Do the backup

# /opt/repostor/rdp4SybaseIQ/bin/sybaseiqbackup -u DBA -p sql -S localhost -s iqdemo -P 2638

(assuming that the username is DBA, password is sql, database is iqdemo, and port number is 2638)