Problem Note 4982: CPU time significantly higher with SQL pass-through to DB2
The CPU time needed to run an SQL pass-through job accessing DB2 in
Version 8 may be significantly higher than in Version 6. This occurs
when the SQL query generates a warning message from DB2. When the
warning occurs, the SAS/Access to DB2 engine calls DB2 to retrieve the
warning message. DB2 reloads its message retrieval routine for every
call to the routine, and thus for every row that the DB2 engine
fetches. In Version 6, SAS does not go through this message retrieval
process for warnings.
A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#004982
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#004982
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 9 TS M0 |
*
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: | 2002-04-22 16:08:24 |
| Date Created: | 2001-05-17 09:11:44 |
