16.20 - UTY9010 Successful connection takes more time due to configuration file setting. - 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

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.