15.00 - Miscellaneous System Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Miscellaneous System Limits

 

Parameter

Value

Maximum number of combined databases and users.

4.2 x 109

Maximum number of database objects per system lifetime.

A database object is any object whose definition is recorded in DBC.TVM.

Because the system does not reuse DBC.TVM IDs, this means that a maximum of 1,073,741,824 such objects can be created over the lifetime of any given system. At the rate of creating one new database object per minute, it would take 2,042 years to use 1,073,741,824 unique IDs.

1,073,741,824

Maximum size for a table header.

1 MB

Maximum size of table header cache.

8 x 106 bytes

Maximum size of a response spool file row.

64KB

Maximum number of change logs that can be specified for a system at any point in time.

1,000,000

Maximum number of locks that can be placed on aggregate online archive logging tables, databases, or both per request.

The maximum number of locks that can be placed per LOGGING ONLINE ARCHIVE ON request is fixed at 25,000 and cannot be altered.

25,000

Maximum number of 64KB parse tree segments allocated for parsing requests.

12,000

Maximum number of nodes per system configuration.

Limits on vprocs of each type restrict systems with a large number of nodes to fewer vprocs per node.

Systems with the maximum vprocs per node cannot approach the maximum number of nodes.

1,024