Problem Note 13528: Using more than 11 conditions with the DBSLICE= data set option with
SAS/ACCESS Interface to DB2 on zOS will result in an abend
Due to the fact that the TKWAITS from MVS is limited to 128 events and
DB2 issues roughly 12 events per slice, specifying more than 11 slices
will result in an abend. The most common abend is a 202 but a 301
abend may also occur. Below is a sample of the 202 abend.
SYSTEM COMPLETION CODE=202 REASON CODE=00000000
TIME=12.05.20 SEQ=09352 CPU=0040 ASID=00C5
PSW AT TIME OF ERROR 070C1000 80FF1F5C ILC 2 INTC 0D
NO ACTIVE MODULE FOUND
NAME=UNKNOWN
DATA AT PSW 00FF1F56 - 00181610 0A0D0B0C 1FCC5490
GR 0: 84000000 1: 84202000
2: 00000000 3: 00000C00
4: 00000030 5: 007CA510
6: 0000CE70 7: 00F59D00
8: 00FF1AA1 9: 00000000
A: 7FFABB50 B: 007FECA8
C: 00000C38 D: 000B48D0
E: 00FE2D00 F: 00000000
END OF SYMPTOM DUMP
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013528
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013528
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9 TS M0 | 9.1 TS1M3 SP1 |
*
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 |
Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2004-12-20 14:01:55 |
Date Created: | 2004-10-04 14:21:14 |