In general, the amount of system resources (that is, memory and processing power) that are required to support the archive or recovery increases with the number of sessions. The impact on a particular system depends on the specific configuration.
Teradata ARC uses at least two (or three) control sessions to control archive and recovery operations. The LOGON statement always connects these sessions no matter what type of operation being performed. Teradata ARC connects additional data sessions based on the number indicated in the SESSIONS parameter. These sessions are required for the parallel processing that occurs in archive and restore or copy operations.
If additional data sessions are required, Teradata ARC connects them at one time. Teradata ARC calculates the number of parallel sessions it can use, with maximum available being the number of sessions indicated with this parameter. Any connected sessions that are not actually used in the operation result in wasted system resources.
The following table indicates the data session requirements for archive and restore operations.
Operation | Data Session Requirements |
---|---|
All-AMPs archive | No more than one session per AMP. |
Cluster or specific archive |
Calculates the nearest multiple of online AMPs for the operation and assigns tasks evenly among the involved AMPs For example, if four AMPs are archived with nine sessions specified, Teradata ARC actually uses eight sessions (two per AMP). The extra connected session wastes system resources since it is unused. |
Restore/copy |
ARC HAS REQUESTED 14 SESSIONS, TASM HAS GRANTED IT 4 SESSIONS.