Calculating Region Size (Teradata ARC 8.0 or Earlier) - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
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.
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.