Introduction to SystemFE Macros - Teradata Vantage - Analytics Database

SystemFE Macros
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
Product Category
Teradata Vantage™

Using SytemFE Macros

Teradata Vantage™ - SystemFE Macros is a basic guide to a set of macros for generating reports on system events and using them as a diagnostic tool.

This document describes the macros and reports used to monitor the health of Teradata Vantage™. There are macros for preventative maintenance data, system events and fallback protection.

Why Would I Use this Content?

As database administrator, it is your responsibility to keep the database working at peak performance. The SystemFE macros enable you monitor and respond to system events.

How Do I Use this Content?

Use this guide as a reference to learn about performance monitoring, user actions, and error messages.

How Do I Get Started?

You should be familiar with Teradata SQL and Basic Teradata Query (BTEQ) facility because the SystemFE macros are run using the BTEQ facility. If you are not familiar with BTEQ or Teradata SQL, you can review the following documents:
  • Basic Teradata® Query Reference, B035-2414
  • Teradata Vantage™ - SQL Fundamentals, B035-1141
  • Teradata Vantage™ - SQL Data Manipulation Language, B035-1146

If you do not have the SystemFE macros installed on your system, run the Database Initialization Program (DIP) utility from the Supervisor window, and select the SQL script file DIPSYSFE. For Teradata session mode CDS macros, select SQL script file DIPPOST and for ANSI session mode CDS macros, select SQL script file DIPANSI. See SystemFE Macros Description.