Syntax - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.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.
-xit
-exit
Shuts down Teradata Database on all nodes of the system. The system must be explicitly restarted after the -x option is used.
-stop
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 Database system.

-force
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 Database 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 Teradata 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 Teradata Database
    • 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
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
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
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
Displays tpareset command syntax information.