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)

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply