1 Set the InstallFlag column to Y for all character sets you want to activate. The limit is 16 active character sets.
UPDATE DBC.CharTranslationsV SET InstallFlag=’Y’ WHERE CharSetId = charactersetid;
or
UPDATE DBC.CharTranslationsV SET InstallFlag=’Y’ WHERE CharSetName = ‘charactersetname’;
2 Perform a full restart of Teradata Database, using the tpareset utility.
Note: If more than 16 rows are flagged as Y at tpareset, the system sorts CharSetName values in ascending ASCII sequence and enables the rows in alphabetical order until the 16 set limit is reached.
For usage information, see tpareset in Utilities.