Troubleshooting Character Set Use - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Archive objects in the same character set class as the character set class from which they originated. It might not be possible to restore an object to a database that does not support alternate character sets. The name of a new table and a table that is part of the archive created using an alternate character set will not appear to be the same, and Teradata ARC considers the table as dropped during its restore of the archive.

If the Teradata Database fails to restore or copy a table or database that is archived, specify the following to perform a restore or copy operation:

  • XN form for this object
  • Session character set as the same character set as the one used to archive the object

If it is not possible to use the same character set for a restore operation as was used for the archive, specify the XN form of the object name for the particular table. The XN form will not be the normal internal form that was stored in the dictionary. Instead, it is the hexadecimal form of the object name stored in the archive. For example, to specify the XN name of an object in the COPY/RESTORE command:

COPY DATA TABLES
 (mkw.'8ABF8E9A6575635F3235355F636F6C5F746162'xn)
 (from ('616263'xn.'8ABF8E9A6575635F3235355F636F6C5F746162'xn)),
release lock,
FILE = ARCHIV1;

Teradata ARC might still not be able to locate the object during the archive because of collation differences between character sets and single-byte uppercasing applied to the object. Teradata ARC might fail to locate a object that was part of an archive when copying the table using ASCII or EBCDIC character sets because single-byte uppercasing was applied to the object.

If Teradata ARC cannot locate the object on the archive via the XN format, copy the object to a system that uses the character set of the archive, then archive it again. If the object name has non-Latin characters, rename the object to a valid Latin character name before archiving.

Object names must be no longer than 30 characters.