Problem Note 40104: Performance issues might occur when you access DB2 with SAS/ACCESS® 9.2 Interface to DB2 in the IBM z/OS operating environment
 |  |  |  |  |
Starting in SAS 9.2 (TS1M0) under z/OS, SAS/ACCES Interface to DB2 changed the type of DB2 cursor that it uses to a rowset cursor in preparation for support of the READBUFF= option in the LIBNAME statement. Retrieving one row at a time with the rowset cursor is slower than retrieving one row with the previous type of cursor that was used. As a result, performance can be poor.
Currently, there is no workaround for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Applying this hot fix requires you to perform a DB2 bind with new database request module (DBRM) members. Even if you have completed the bind for the third maintenance release for SAS 9.2 (TS2M3) previously, you must perform the bind again with these new DBRM members. For more details, see SAS Note 39564, "SAS® 9.2 (TS2M3) Database Request Module (DBRM) members that are needed for the DB2 bind are not downloaded during the installation".
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS1M0 | 9.3 TS1M0 |
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#40104| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-06-29 13:27:51 |
| Date Created: | 2010-06-24 17:02:05 |