BTEQ Return code 2

Tools & Utilities
Highlighted
Teradata Employee

Re: BTEQ Return code 2

Glad to hear you were able to figure it all out.

You might want to double check on whether multiple sessions were actually useful to the job or or not. If an IMPORT is being done, having multiple sessions logged on may have been allowing the job to run faster by taking advantage of the database's ability to process multiple requests in parallel. If you do investigate this, I suggest looking into whether use of PACK factors could help as well. There are some good examples and explanations in BTEQ's Reference Manual on the use of a PACK factor. Basically, it allows BTEQ to use fewer trips to get import data records across to the database.

Have a great week ! :)