Syntax - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢
tpareset {
  [ { -xit | -x | -exit | -e } |
    { -stop | -s } |
    { -force | -f }
  ]
  [ { -panic | -p } [-nodump] | { -dump | -d } ]
  [ -yes | -y ] reason |

  { -help | -h }
}
Some strictly internal and rarely-needed options have been omitted from this discussion. Those options are documented in the tpareset command-line help.

Syntax Elements

-xit
-x
-exit
-e
Shuts down Vantage on all nodes of the system. The system must be explicitly restarted after the -x option is used.
-stop
-s
Brings PDE down on the node from which the tpareset was initiated. The other nodes go through a reset cycle, but the initiating node stays down. On an SMP system, this is equivalent to -exit.

Sets the state of the initiating node to DOWN/TDMAINT. Nodes in this state stay down until tpareset -f or a system wide shutdown and restart brings them back into the Teradata system.

-force
-f
Forces a full restart on all nodes of the system. This option has the following effects:
  • Brings any nodes that are running but in DOWN/TDMAINT state back into the Teradata system.
  • Clears the system-wide crash count

    If the crash count was preventing the database from being started, this option forces the database to be started on all nodes. -force should not be used until the condition that caused the crash loop has been corrected.

  • Forces reconcile to run
    Reconcile normally runs when any node that was down is brought back up, or when a database version switch has been requested, necessitating a system reset. Reconcile does the following:
    • validates that each node is running the same version of the various software components that comprise Vantage
    • ensures that these versions are compatible with each other
    • switches versions of specific components if such a version switch has been requested. (Such version switches are specified from the ctl utility programs.)

    The -f option forces reconcile to run during a reset, regardless of status of system nodes and regardless of whether a version switch has been requested.

  • Forces the database cache to be discarded

    The database cache may also be discarded in other reset situations when the -f option has not been specified.

    Reinitializing the cache can add several minutes to restart time.

-panic
-p
Initiates a reboot of the node where tpareset was executed. A database dump is captured from all nodes, and an operating system dump is captured on the rebooted node. The remaining nodes undergo a normal reset and restart cycle without being rebooted.

When the database restarts, the node from which tpareset was run is excluded from the parallel database system. When the problem that required the panic reset is resolved, the node can be returned to service by issuing another tpareset.

This option should be used only if the Teradata Support Center determines that a dump is necessary for problem isolation.
-nodump
Prevents the -panic option from capturing a database-level dump. However, an operating system dump will still be captured on the initiating node, initiating a node reboot.
-dump
-d
Causes a database dump to be captured before the system is reset and restarted.
This option should be used only if the Teradata Support Center determines that a dump is necessary for problem isolation.
-yes
-y
Suppresses the normal tpareset confirmation prompt.
reason
The tpareset command must end with a string that describes the reason for the reset. The reason need not be delimited by double quotation marks or apostrophes. The string cannot start with a dash (-).
-help
-h
Displays tpareset command syntax information.