When loading data from a Teradata Secure Zone to SAS^® Cloud Analytic Service (CAS) using DATATRANSFERMODE=PARALLEL, a background Teradata query against DBC.TABLESX might occur. 

A user will not notice anything, but a Teradata Database Administrator might report that the user should not be running queries that use DBC.TABLESX.  

The Teradata Query log might display the following query:

There is no workaround for this issue.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Connector to Teradata	Linux for x64	V.03.05		Viya

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

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

---

SAS generates background queries when running against Teradata. Some of those queries might be against DBC.TABLESX, which are known to cause performance concerns for busy Teradata appliances.

Type:	Problem Note
Priority:	medium

Date Modified:	2024-04-15 14:23:44
Date Created:	2024-04-02 06:24:03