Calculating Region Size (Teradata ARC 8.0 or Earlier) - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the information in this table to estimate the minimum region size (in kilobytes) needed to run Teradata ARC from z/OS.

This table provides estimates for archive or restore operations only. Copy operations might require more memory.
Minimum Region Sizes Running from z/OS
Number of Sessions Region Size for 200 Objects Region Size for 2,000 Objects Region Size for 8,000 Objects
10 2,500 KB 3,200 KB 5,620 KB
50 4,420 KB 5,140 KB 7,540 KB
100 6,820 KB 7,540 KB 9,940 KB

where:

Table Element Description
Number of Objects The number of databases + number of tables and stored procedures to be archived, restored, or copied.

The ALL keyword expands the number according to this query:

SELECT count (*) from database DBC.CHILDREN WHERE PARENT = ‘<db>’

Sessions number of data sessions to use in the operation.