UTY9010 Successful connection takes more time due to configuration file setting. - FastExport - MultiLoad - Parallel Data Pump

FastExport, MultiLoad, and TPump (UTY Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
MultiLoad
Parallel Data Pump
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2021
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata® Tools and Utilities

UTY9010 Successful connection takes more time due to configuration file setting.

Explanation: Longer connection time. If the user didn t specified the TENACITY in script command (The default value is TENACITY=4 hours and SLEEP=6min). And configuration file settings RETRYOTHERCONNECT=10RETRYCONNECTINTERVAL=1800
Specified 10 retry times and retry connect interval 30 min, Hence after the 10 retires if the connection is not established, it takes 5 hours to complete the job (10X30min), which will exceed the tenacity value 4 hours. In this scenario, the tpump job has to display output like below after retrying for a successful session connection:
Extract from the output: **** 19:56:50 UTY6609 Starting to log on sessions... **** 20:01:48 UTY0846 Warning: RDBMS or network down. Trying to logon again. **** 20:16:42 UTY0846 Warning: RDBMS or network down. Trying to logon again. **** 20:35:37 UTY0846 Warning: RDBMS or network down. Trying to logon again. **** 20:49:52 UTY0846 Warning: RDBMS or network down. Trying to logon again. **** 21:04:38 UTY0846 Warning: RDBMS or network down. Trying to logon again. **** 21:19:06 UTY0846 Warning: RDBMS or network down. Trying to logon again. UTY9010 successful connection takes more time due to configuration file setting Generated By: TLDCLI Remedy: It is an informational message.