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

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢
The utility described is not available for as-a-service customers.

The TPA Reset utility, tpareset, resets Analytics Database. 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 Analytics Database has been reconfigured
  • to activate new versions of Analytics Database 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.