Tags for pack
BTEQ .PACK and deadlock
I am trying to understand why BTEQ .PACK command creates dead lock on tables with NUPI. I had a scenario where I needed to load nearly 2 million rows on mutiset table with NUPI. I had lot of duplicates on NUPI columns. When sessions set to 4, PACK set to 2000, my bteq script's run time output displayed the following: *** Growing Buffer to 399 *** Failure 2631 Transaction ABORTed due to deadlock. Statement# 1, Info =0 *** Warning: Attempting to resubmit last request. *** Failure 2631 Transaction ABORTed due to deadlock.
bteq deadlock pack
BTEQ Reference 13.10
This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.
udf load teradata bteq lob sql export import compile xsp pack batch btet tdpid logon v_tools