Vital Infrastructure and Crashdumps | Teradata Vantage - Teradata Vital Infrastructure and Crashdumps - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageâ„¢

Under normal circumstances, Teradata Services personnel handle crashdumps directly using the TVI.

Each system at your site must be registered with its own site ID so that Teradata will have all the proper information on the configuration of each specific system on your site.

If you have created and registered a site ID for each system at your site, you should have TVI software already installed so that it can begin monitoring your Teradata database. When a 3610 error or an 033-12123-00 error occurs, this triggers an incident to be created. If you need to open an incident:
  1. Go to https://support.teradata.com.
  2. Log in.
  • A 3610 error indicates an internal error produced by a request sent to Vantage which has caused a snapshot dump and aborts the given request. This is done instead of restarting the system.
  • A 033-12123-00 message represents a task snapshot dump and an event is logged when a program requests a snapshot dump on itself.

TVI, through the TVI Manager and Auto Incident Create (AIC) server, will automatically notify Teradata Services personnel who will try to troubleshoot the problem to determine the root cause or may work with field engineers if there is a hardware problem. They will engage your local site team and may also escalate the incident to Teradata developers, if necessary.

Every customer site team is different: some local site teams may start collecting crashdumps and have them already ready in the event that your Teradata Services personnel asks for the crashdump to be sent in to Teradata. Other site teams will wait until instructed by the Teradata Services to send the crashdump information.

If there are multiple users on the system at once and you are not sure who caused it or where the bad request or error came from, Teradata Services personnel may need to extract the problem SQL from the crashdump and ask you to run TSET on that SQL and send in the TSET pack file to continue the investigation.