SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.20 and later in AIX environments


TTU 17.20 is supported on AIX in SAS® 9.4M8 (TS1M8) with a hot fix. For more information, see SAS Note 70928, “SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.20 and later in AIX environments.”

Prior to the release of the hot fix, TTU 17.20 was not supported with SAS/ACCESS Interface to Teradata on AIX. This limitation extended to the following products, which have dependencies on SAS/ACCESS Interface to Teradata:

Without the hot fix, the only workaround for this issue is to use TTU 16.20.

The following options for using Teradata on AIX are available:

Customers on other operating systems should refer to SAS KB0036364, "SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.xx in UNIX and Microsoft Windows environments."

If you attempt to use TTU 17.20 and later with earlier SAS releases, you might encounter symptoms that include failures, a lack of response, and/or errors, such as the following: 


ERROR: FastExport either failed before connecting to SAS or timed out before invoking the access module.

ERROR: Multiload failed to invoke the access module. Possible causes include:
(a) Invalid restart table name
(b) Slow network delaying Multiload login to Teradata
(c) MultiLoad unable to find the access module
(d) No space in database to create the restart table.

SAS WTABORT (Program program-name.sas) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
 Please Contact Technical Support.
 Tasks
[MAIN    ] [WAITING ] pri[   5] reb[8C252AE0] WC[0] WN[1]
[IDLETASK] [READY   ] pri[   9] reb[8C252AE0]
[EVENTTSK] [WAITING ] pri[   0] reb[8C252AE0] WC[0] WN[1]
[sasxkern] [WAITING ] pri[   3] reb[8C252AE0] WC[0] WN[1]
[Session ] [WAITING ] pri[   3] reb[8FF984E0] WC[0] WN[1]
[TKSRV   ] [WAITING ] pri[   3] reb[8FF98B80] WC[0] WN[1]
[Program ] [RUNNING ] pri[   7] reb[8FF996A0]
[DOS Moni] [WAITING ] pri[   7] reb[8FF9EBA0] WC[0] WN[1]

ERROR: Extension Load Failure: OS Error: -1 (Symbol resolution failed for SASHOME/SASFoundation/9.4/sasexe/sasiotpt.so because:
        Symbol
       __ct__Q5_3ncr8teradata6client3API10ConnectionFv (number 34) is not exported from dependent
          module /usr/lib/libtelapi.so.
        Symbol
       __dt__Q5_3ncr8terad)
TERADATA: trrlbk: ROLLBACK WORK