PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

Latest

Repairing Data Corruption

Data Corruption

Table Rebuild is a utility that repairs data corruption. It does so by rebuilding tables on a specific AMP vproc based on data located on the other AMP vprocs in the fallback cluster. Table Rebuild can rebuild data in the following subsets: The primary or fallback portion of a table An entire table (both primary and fallback portions) All ...

Teradata Support contact checklist !!

If you notice your system is having problems and you want to contact Teradata Customer Support to report an incident, Before contacting Teradata support collect as much information about your system as possible. The list below is not exhaustive and is meant only to help you begin gathering details.   Note that not all of the questions ...

Restart After Client or Teradata ARC Failure

If the client system or Teradata ARC Failure happens during an archive, restore, or recovery procedure, restart the operation. Teradata ARC responds to the failure by logging all its sessions off the Teradata Database. The Teradata Database does not journal Teradata ARC statements, therefore Teradata ARC takes no recovery action at logoff. Database locks placed ...

Solving Partitioning and RI Validation Errors

You can use the following procedures and tools to detect and correct errors in tables that use partitioning and referencing. (For details, see “Partitioned and Nonpartitioned Primary Indexes” and “FOREIGN KEY … REFERENCES Constraints” in Database Design.)     IF you want to … THEN … correct a partitioning expression that is causing transaction rollbacks due to an evaluation error ...

How can we rectify spool space issues.

Troubleshooting Spool Space Problems The system automatically creates and drops spool files which it uses as temporary work tables to execute queries. Sometimes, one of two potential problems can occur with the spool files: Leftover spool. Leftover spool occurs when the system fails to properly drop the spool file after the execution of a query completes. The ...

Teradata : Parsing Workload Selection

As of Teradata Database 14.10.05 and 15.00.03, a simplified approach to determining which workload will support session management and parsing has been adopted , This posting describes this more straightforward approach which will be used starting in these 14.10 and 15.0 releases, and going forward in all future releases. An earlier posting titled:  “A Closer Look at ...

Teradata 14.10 : Autostats in Teradata

Everyone with a Teradata Database collects statistics.  No way around it.  Good query plans rely on it, and we’ve all gotten used to it. But starting in Teradata Database 14.10 there’s some big changes.  Numerous enhancements to the optimizer, some important database changes, a new set of APIs, an added data dictionary table, and a brand ...