Two types of automatic transaction recovery can occur:
- Single transaction recovery
- Database recovery
The following table details what happens when the two automatic recovery mechanisms take place.
| This recovery type… | Happens when Teradata Database… |
|---|---|
| single transaction | aborts a single transaction because of:
Single transaction recovery uses the transient journal to effect its data restoration. |
| database | performs a restart for one of the following reasons:
|