Linux MLOAD client can't connect via script but interactivly

Connectivity
Supporter

Linux MLOAD client can't connect via script but interactivly

Hi,

 

I am facing a strange behaviour.

I installed the linux TTU on a linux client.

If start mload interactively I can connect to the database:

$ mload -c utf8
**** 08:43:49 UTY2407 Run time parameters in effect are: UTF-8.
     ========================================================================
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.15.10.01.06               =
     =          Platform LINUX                                              =
     =          PID      3325                                               =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1990-2016 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 08:43:49 UTY2411 Processing start date: TUE NOV 15, 2016
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
.LOGTABLE inslogtable;

.logon localVM/uli,$tdwallet(neo-uli);
0001 .LOGTABLE inslogtable;

0002 .logon localVM/uli,;
**** 08:43:54 UTY8400 Teradata Database Release: 15.10.01.01
**** 08:43:54 UTY8400 Teradata Database Version: 15.10.01.01
**** 08:43:54 UTY8601 Character set specified: UTF8                          
**** 08:43:54 UTY8400 Current RDBMS has interval support
**** 08:43:54 UTY8400 Current RDBMS has UDT support
**** 08:43:54 UTY8400 Current RDBMS has Large Decimal support
**** 08:43:54 UTY8400 Current RDBMS has TASM support
**** 08:43:54 UTY8400 Maximum supported buffer size: 1M
**** 08:43:54 UTY8400 Data Encryption supported by RDBMS server
**** 08:43:54 UTY6211 A successful connect was made to the RDBMS.
**** 08:43:54 UTY6217 Logtable 'TEST_DB_ULI.inslogtable' has been created.
     ========================================================================
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ========================================================================

but when I run the same code via a script I get

$ more ml_script.log 
**** 08:42:16 UTY2407 Run time parameters in effect are: UTF-8.
     ========================================================================
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.15.10.01.06               =
     =          Platform LINUX                                              =
     =          PID      3271                                               =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1990-2016 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 08:42:16 UTY2411 Processing start date: TUE NOV 15, 2016
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
0001 .LOGTABLE inslogtable;

0002 .logon localVM/uli,;
**** 08:42:16 UTY9009 CLI 207 error: RDBMS or network down. No retry limit is
     specified. The job is terminating.
**** 08:42:16 UTY8400 Network or RDBMS down,Cli error 207
**** 08:42:16 UTY2410 Total processor time used = '0 Seconds'
     .       Start : 08:42:16 - TUE NOV 15, 2016
     .       End   : 08:42:16 - TUE NOV 15, 2016
     .       Highest return code encountered = '12'.

BTEQ is showing the same behaviour.

Also it is not related to the TD system. I validated the behaviour on two systems.

Seems a client issue. The script runs fine on a different linux client...

Any idea what to look for?

Ulrich

3 REPLIES
Junior Supporter

Re: Linux MLOAD client can't connect via script but interactivly

Hi Uli:

 

What happens when you try to connect without TDWallet (clear password)?

 

Cheers.

 

Carlos.

Supporter

Re: Linux MLOAD client can't connect via script but interactivly

The same:

works for interactive session.

error for script call

Junior Supporter

Re: Linux MLOAD client can't connect via script but interactivly

Hi Uli.

 

Strange...

 

I assume the script is OK (no garbage, no windows end of lines, etc...) The script fails both with bash and ksh?

 

Some corruption in the TTU packages perhaps...

 

Cheers.

 

Carlos.