Problem Note 13614: Updates to database performed after each modification to a row in a
Teradata table when using the DBKEY= option
Currently, the SAS/ACCESS Interface to Teradata executes a COMMIT WORK
to the Teradata database after each update to a Teradata table when the
DBKEY= option is used. This can cause degradation in performance when
all records are successfully inserted into the table. The correct
behavior of the SAS Teradata engine is to commit to the database based
on the specification of the DBCOMMIT= option. This option enables you
to issue a DBMS commit statement automatically after a specified number
of rows have processed.
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013614
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013614
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Teradata | z/OS | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP1 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2004-12-20 13:36:40 |
| Date Created: | 2004-10-14 09:50:12 |
