How Many DBCAREAs to Use - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The application can use one DBCAREA for all the requests or a separate DBCAREA for each request, or use any combination in between. This choice is available for either multi-sessions or multi-requests.

Application Status Result
Facing space limitations

Reuse the one DBCAREA, which involves copying the Output-CLIv2-request-number, saving them, and replacing them when doing a Fetch, Rewind, or Cancel against that same Teradata SQL request.

If other fields, such as the processing options or buffer addresses or sizes, change from one request to another, they too must be saved and replaced.

Since much less information than the whole DBCAREA is saved, the application can show a significant saving of space at the small cost of unloading and reloading those fields between calls.

Able to spare the space for multiple DBCAREAs

Allocate one DBCAREA per concurrent request.

The application can show some saving of time at the cost of the space for the extra DBCAREAs.