RECOVERY LOG USAGE Command | unityadmin | Teradata Unity - RECOVERY LOG USAGE - Continuous Availability - Teradata Unity

Purpose

Provides a total of recovery log , data used by recovery per day for the previous 8 days, and data used by load per day for the last 8 days.

Example

unityadmin> recovery log usage;
--------------------------------------
Recovery log and load data usage for last 8 days :
12/14, Recovery log Usage: 4 GB, Data load Usage: 856 GB
12/15, Recovery log Usage: 5 GB, Data load Usage: 163 GB
12/16, Recovery log Usage: 3 GB, Data load Usage: 342 GB
12/17, Recovery log Usage: 4 GB, Data load Usage: 945 GB
12/18, Recovery log Usage: 6 GB, Data load Usage: 645 GB
12/19, Recovery log Usage: 7 GB, Data load Usage: 145 GB
12/20, Recovery log Usage: 3 GB, Data load Usage: 243 GB
12/21, Recovery log Usage: 2 GB, Data load Usage: 234 GB

--------------------------------------
Load size statistics for last 8 days :

12/14, Largest load by size: 14.305 MB, Largest load by row count: 100000 rows
12/15, Largest load by size: 25500 bytes, Largest load by row count: 500 rows
12/16, Largest load by size: 715.256 MB, Largest load by row count: 5000000 rows
12/17, Largest load by size: 255 bytes, Largest load by row count: 5 rows
12/18, Largest load by size: 7.153 MB, Largest load by row count: 50000 rows
12/19, Largest load by size: 2550 bytes, Largest load by row count: 50 rows
12/20, Largest load by size: 71.526 MB, Largest load by row count: 500000 rows
12/21, Largest load by size: 71 MB, Largest load by row count: 5000 rows

Largest load seen since last sequencer start, by size: 0 bytes, by row count: 0 rows
Largest load seen in last 8 days, by size: 715.256 MB, by row count: 5000000 rows

This table explains the output.