Skip to Content

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)

Be the first to leave a comment
You must be Logged on to comment or reply to a post.