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

FastExport, MultiLoad, and TPump (UTY Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

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.