SUPPORT / SAMPLES & SAS NOTES
Problem Note 41741: Performance degradation related to change in SQLDA definition
 |  |  |  |  |
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 |