Problem Note 40226: Incorrect results might occur when you specify the READBUFF= option with SAS/ACCESS® Interface to DB2 in the IBM z/OS operating environment
 |  |  |  |  |
Incorrect results might be generated when the following events occur:
- Under z/OS, you set the READBUFF= data set option to a value that is greater than the number of rows that will be fetched when you query a DB2 table using SAS/ACCESS Interface to DB2.
- The query that you submit contains a summary function for a column that accepts null values.
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 TS2M3 | 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#40226| Type: | Problem Note |
| Priority: | alert |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2010-07-07 09:51:07 |
| Date Created: | 2010-07-06 13:10:14 |