Example 3: Archive Script for Multiple-Node Backup - Tivoli

Teradata Extension for Tivoli Storage Manager Administrator Guide

Product
Tivoli
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2019-03-22
dita:mapPath
beb1489436039198.ditamap
dita:ditavalPath
beb1489436039198.ditaval
dita:id
wkq1486409855180
Product Category
Teradata Tools and Utilities

The next example performs a ARCMAIN backup that originates from multiple client nodes or multiple security domains with the default TSM administrator for the Tivoli EDW001 pseudo node.

To create this type of backup:

  1. Ensure that the file pointed to by ARCDFLT environment variable is dsm.opt.
  2. On the command line, type:

    tivarc <arcin.txt

Output

arcin ARC Script

Logon td1/dba1 , pwd;
Archive data tables (db1)
,  release lock
,  file=  db1_data;
Logoff  ;

dsm.opt File

TCPSERVERADDRESS 128.00.00.00
PASSWORDACCESS   PROMPT
COMMMETHOD       TCPIP
NODENAME				 EDW001
PASSWORD EDW_PASSWORD
Backup Information in the TSM Catalog
  • Node = EDW001
  • Filespace = Teradata
  • High Level = db1_data
  • Low Level = F0000, F0001, F0002, and so on

Other Considerations

The considerations described above for archive also apply to restore. The TSM Administrator password is stored indsm.opt. Therefore, you might want to restrict who can read this special Options file, as explained in Security for Files that Contain Passwords.

If password expiration is in effect for this TSM Administrator, regularly update dsm.opt on every node where an ARCMAIN job references it to reflect the new password or sets the password.

Define TSM nodes for multiple Teradata servers (such as, when there is a production and a development server in the data center). In this case, the ARCMAIN command line is similar to the one shown above, but a different dsm.opt file that indicates the appropriate node name and password for that server can be pointed to. Therefore, use the correct Teradata logon in the ARCMAIN script.