41741 - Performance degradation related to change in SQLDA definition

Support

Submit a Problem
Update a Problem
Check Problem Status
SAS Administrators
Security Bulletins
License Assistance
Manage My Software Account
Downloads & Hot Fixes
Samples & SAS Notes

Problem Note 41741: Performance degradation related to change in SQLDA definition

Details

Hotfix

About

Rate It

Using the LIBNAME engine with hot fix E9D202 for SAS^® 9.1.3 and in subsequent SAS releases, SAS/ACCESS^® Interface to DB2 on z/OS allows access to DB2 tables that have more than 50 columns or to a table that has columns defined as a DISTINCT data type. The product is set to the maximum that DB2 allows. See SAS Note 17998 for hot fix E9D202.

However, setting the size to the maximum can cause a performance problem.

There is no workaround for this issue.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	z/OS	9.1 TS1M3 SP4	9.3 TS1M0

* 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.

A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/B94.html#41741

Type:	Problem Note
Priority:	high

Date Modified:	2010-12-28 11:07:55
Date Created:	2010-12-03 10:41:01