RECOVERY LOG USAGE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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.