SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It
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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9 TS M09.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.