Down AMP recovery |
- Always occurs.
- Active only during an AMP failure.
- Journals only fallback tables.
- Used to recover the AMP after the AMP is repaired, discarded afterward.
|
Transient |
- Always occurs.
- Logs BEFORE images for transactions.
- Used by system to roll back failed transactions aborted by user or system.
- Captures the following:
- Begin/End Transaction indicators.
- BEFORE row images for UPDATE and DELETE statements.
- Row IDs for INSERT statements.
- Control records for CREATE, DROP, DELETE, and ALTER statements.
- Keeps each image on the same AMP as the row it describes.
- Discards images when the transaction or rollback completes.
|
Permanent |
- Occurs as you specify.
- Is available for tables or databases.
- Can contain BEFORE images (which enable rollback), or AFTER images (which enable rollforward), or both BEFORE and AFTER images.
- Provides rollforward recovery.
- Provides rollback recovery.
- Provides full recovery of nonfallback tables.
- Reduces need for frequent, full-table archives.
|