Problem Note 47899: Joining 32 or more DB2 tables in an SQL procedure query might result in a performance issue or an error
Currently, SAS/ACCESS® Interface to DB2 on a z/OS system might not efficiently handle a PROC SQL query that contains 32 DB2 tables.
Instead of the query being passed to DB2, the data is retrieved from all of the DB2 tables and SAS handles the processing of the query. As a result, the query might take longer than it would have had DB2 done the processing.
If your query contains 33 or more DB2 tables, an error similar to the following might occur:
ERROR: DBMS table open failed. The maximum number of DBMS opens for this
engine (32) has been reached.
The only way to work around this issue is to divide the query into multiple queries.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-10-17 10:10:29 |
| Date Created: | 2012-09-17 14:15:59 |
