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

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

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.

Syntax

RECOVERY LOG USAGE;

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.

Output Description
Recovery log and load data usage for last 8 days Shows the amount of recovery log used, and the amount of space used in /data, per day.
Load size statistics for last 8 days

Shows the largest load by size of data packets, as well as by row count, per day.

Additionally, also shows the largest load since last time this sequencer was started/became active, as well as largest load seen in last 8 days.