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 Ingres PDF Print E-mail
Written by Tomas   
Saturday, 19 September 2009 12:14

Quick Start Guide

for 

Data Protector for Ingres

using IBM Tivoli Storage Manager

 

 Linux

Ingres server

Install the Ingres server binaries

download

# ./ingres_install

TSM Client

Install the Tivoli Storage Manager (Backup Archive Client)

download

# rpm -i XXX

Install the Data Protector for Ingres

download 

# rpm -i XXX 

Configure the TSM server

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

Create the backup schedule

# dsmadmc

tsmserv>define domain ingres
tsmserv>define policyset ingres standard
tsmserv>define mgmt ingres standard 30days
tsmserv>def co ingres standard 30days dest=backuppool verd=nol vere=nol reto=30 rete=30
tsmserv>def co ingres standard 30days dest=backuppool retv=30 t=a
tsmserv>assign defmgmt ingres standard 30days
tsmserv>validate policyset ingres standard
tsmserv>activate policyset ingres standard
tsmserv>register node ingres secret domain=ingres
tsmserv>def sched ingres full action=command objects="/usr/local/bin/backup.sh" startt=21:00 startd=today dur=2 duru=hour
tsmserv>define assoc ingres full ingres 

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 ingres

TCPSERVERADDRESS 10.11.12.13

SCHEDLOGNAME /var/log/dsmsched_ingres.log

ERRORLOGNAME /var/log/dsmerror_ingres.log

PASSWORDACCESS generate

NODENAME ingres
 
# 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=ingres
 
Create the backup scripts
 
# vi /usr/local/bin/backup.sh

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4Ingres/bin:/opt/Ingres/IngresII/ingres/bin/

export LANG=en_US
. /opt/Ingres/IngresII/.ingIIbash

ingresbackup -v -s demodb >> /var/log/ingresbackup.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/tsming

#!/bin/bash

export PATH=$PATH:/opt/repostor/rdp4Ingres/bin

case $1 in

   start)

            nohup dsmc -se=ingres quiet &

            ;;

esac

# chmod a+x /etc/init.d/tsming
# ln -s /etc/init.d/tsming /etc/rc2.d/S99tsming
 
Startup the service, and verify that the service gets a schedule
 
# /etc/init.d/tsming start
# cat /var/log/dsmsched_ingres.log

Setting up Ingres backups

Edit ckptml.def file:
 
# vi /opt/Ingres/IngresII/ingres/files/cktmpl.def

PSTD: /bin/echo mounting tape %M
PSTR: /bin/echo mount taping %M
PSTT: /bin/echo PARTIAL: mounting tape %K
PRTD: /bin/echo mount taping %M
PRTT: /bin/echo mount taping %K
PRTR: /bin/echo mount taping %M

 
Last Updated on Saturday, 19 September 2009 12:21
 
Repostor : Your recovery expert