Map Actions | Database Administration | VantageCloud Lake - Reviewing Recommended Map Actions - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Review the actions Teradata recommends for reassigning tables to different maps. Look for issues that may need to be resolved before any recommended changes can occur. Also consider whether the recommended actions are best for your site.
  1. Isolate any issues found during map analysis.
    Query the issues in ActionsTbl. For example:
    SELECT * FROM tdmaps.ActionsVX WHERE Issues='Y' OR Action <> 'alter';

    The Description column describes the issue.

  2. Check for space issues that may prevent recommended map reassignments. See FractionOfDBFreePerm, which lists the space left in a database after tables are redistributed. For example, if your database has 100 MB of perm space and the table being redistributed is 1 MB, FractionOfDBFreePerm is .99, indicating that 99% of permanent space in the database remains free after table redistribution.
    It is particularly important to notice this value after a system expansion, because the table header has to be written to each AMP. For example, if you upgrade from a 2-AMP system to a 100-AMP system, the table header uses 50 times more space than before, even though the table is the same size.
    Reassigning a table to another map requires an INSERT-SELECT, which uses 2 times the amount of permanent space the table requires.
  3. Give the table being reassigned additional permanent space, if necessary.
  4. Look for other issues.
    These can include the following common issue types, for example:
    • The table uses a sparse map and is reassigned to a contiguous map.
    • The table has permanent journaling enabled, so the map reassignment fails. Tables with permanent journals must use the default map.
    • The join index is invalid when the table is assigned to a new map. The DBA must drop and recreate the join index after the map reassignment. This occurs when the join index is based on these types of tables:
      • Primary AMP index (PA)
      • Nonpartitioned primary index (NOPI)
      • Column-partitioned primary index (CPPI)
    • A user-created join index does not transfer when a table is assigned to a new map. The DBA must issue a separate ALTER TABLE request for a user-created join index.
    System-defined join indexes automatically use the new map.