Restore SystemFE Database from an Earlier Release | SystemFE Macros | Vantage - 17.00 - 17.05 - Restoring the SystemFE Database from an Earlier Release - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

To restore the SystemFE database from an earlier release, you must first clean up macros that are no longer meaningful to the current system. After cleaning up the obsolete macros, you need to recreate the SystemFE.diskevents macro.

DIP must have already been run once to ensure that the supporting infrastructure is updated (for example, empty macros or views should already have been created). If DIP has been run at least once previously, run the appropriate DIP again to recreate the macro.

Two DIP files that you might have to run are:
  • DIPSYSFE - creates the macro if it is NOT already present
  • DIPPATCH - fills in for any release-dependent changes

For more information on these DIP files, see Teradata Vantageā„¢ - Database Utilities , B035-1102 .