UTY2821 Sessions set to 1 to ensure UPSERT integrity with Serialize=OFF. - Teradata Tools and Utilities

FastExport, MultiLoad, and TPump (UTY Prefix) Messages

Product
Teradata Tools and Utilities
Release Number
15.10
Language
English (United States)
Last Update
2018-10-12
dita:id
B035-1096-UTY
lifecycle
archive
Product Category
Teradata® Tools and Utilities

UTY2821 Sessions set to 1 to ensure UPSERT integrity with Serialize=OFF.

Explanation:

TPump UPSERT may go to an inconsistent state when PackFactor > 1 and Sessions > 1 with Serialize=OFF. To avoid this problem TPump sets PackFactor and Sessions to 1 and continues.

Generated By:

UTYMSG

Remedy:

TPump will change PackFactor and Sessions to 1 and continues after giving above warning message to the user.