Support for Teradata Tools and Utilities (TTU) 17.10 and 17.20 with SAS/ACCESS Interface to Teradata begins with SAS® 9.4M8 (TS1M8) and the SAS® Viya® platform 23.02. Earlier releases of SAS might work with TTU 17.xx but will have limited support. Customers should upgrade to SAS 9.4M8 or the SAS Viya platform 23.02 to be fully supported.
The following options for using TTU are available:
- For SAS® 9.4M3 (TS1M3) through SAS® 9.4M6 (TS1M6), use TTU 16.20 to connect to Teradata 16.xx or earlier.
- For SAS 9.4M6 on Linux and Windows systems, use TTU 17.20 with TPT=YES to connect to Teradata 16.xx or Teradata 17.xx after installing the hot fix in SAS Note 70963.
- For SAS® 9.4M7 (TS1M7), use TTU 16.20 to connect to Teradata 16.20 or earlier.
- For SAS 9.4M7, use TTU 17.10 to connect to Teradata 17.xx but only with TPT=YES.
- For SAS 9.4M8 and later, use TTU 17.10 or TTU 17.20 to connect to Teradata 17.xx.
AIX customers should review SAS KB0036387, "SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.20 and later in AIX environments" and SAS Note 70928, "SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.20 and later in AIX environments."
If you attempt to use TTU 17.xx other than described in the list above, 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