Problem Note 67877: Using the X versions of Teradata views with CAS libraries might cause performance degradation
 |  |  |  |  |
When SAS® Cloud Analytic Services (CAS) libraries interact with SAS/ACCESS® Interface to Teradata, you might observe the following issues:
- Poor performance
- No Teradata tables are listed in a CAS library
These issues can occur because SAS® software refers to the X versions of Teradata views, and these views take security into consideration. Non-X views are faster; however, they do not consider security.
Unconditional SELECT statements that are executed on non-X views might cause the result to exhaust the available spool space of the user. For more information about querying X views versus non-X views, refer to the Teradata documentation.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After you install the hot fix, in order to use non-X views, you need to set the environment variables SAS_NON_XVIEWS and SAS_NON_XVIEW_TABLES.
On each CAS node, use a text editor to edit the cas_usermods.settings file:
Add the following lines:
export SAS_NON_XVIEWS
SAS_NON_XVIEW_TABLES=YES
export SAS_NON_XVIEW_TABLES
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Linux for x64 | V.03.05 | 2021.1.6 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata |
| Date Modified: | 2021-05-10 10:39:51 |
| Date Created: | 2021-05-07 10:21:30 |