Archives of the TeradataForum

Message Posted: Fri, 17 Mar 2006 @ 19:05:55 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Experiences with TSM and Teradata

From:		hock lim

Andy Crockett wrote (7 Feb 2006):

We just purchased a Teradata system and the current plan is to use Tivoli Storage Manager (TSM) for archive and recovery. I understand that Teradata supports TSM, but when I've searched the forum or Google, for that matter, I haven't found any references to anyone using TSM to backup their Teradata database. Have any of you used TSM with Teradata and what have your experiences been, good or bad.

Andy,

Teradata has a documentation detailing the use of Tivoli Access Module for TSM backup.

Basically the backup is still performed using the well-known arcmain utility but the data is sent via Tivoli Access Module then to the Storage Agent; the tapes are still managed by TSM Server. No magic here.

It is truly an open backup solution where almost anything goes.

However, something to look out for:

- Gigabit NIC tunables

- Need a private LAN

- No sharing of ASIC in switches

- Careful what device drivers to install for SAN

- Point to only one node per bar server to improve throughput

- How to schedule cluster archive

- Naming standards for tapes

- TSM Tape Policy

- Security of dsm.opt and archflt.txt

- Use shared drive or NAS to store scripts