Advanced SQL Engine | Utilities | TPA Reset (tpareset) | Teradata Vantage - 17.10 - TPA Reset (tpareset) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
The utility described is not available for as-a-service customers.

The TPA Reset utility, tpareset, resetsAdvanced SQL Engine. All PDE tasks except for some kernel daemons are killed. All database processes, including those for AMPs and PEs, are stopped and restarted. TPA Reset options control whether dump information is collected, whether the node on which tpareset is run is rebooted, and whether the system remains down or restarts.

TPA Reset can be used:

  • after Advanced SQL Engine has been reconfigured
  • to activate new versions of Advanced SQL Engine software
  • to recover from a database hang
  • in other situations that warrant a full database shutdown and restart

Use TPA Reset only when absolutely necessary. TPA Reset has a system-wide effect. Shutting down the system and restarting not only causes system down time, but can also have a performance impact when the system starts up and runs standard recovery and reconcile operations.