SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 31862: A U1314 abend might occur when a job sorts an SQL procedure view that references a DB2 table

DetailsHotfixAboutRate It

A job might end with a U1314 abend if the job uses the SORT procedure to sort a PROC SQL view that references a DB2 table.

For example, if you run the job in batch mode, you might get output similar to the following with the 1314 abend code:

   IEA995I SYMPTOM DUMP OUTPUT
      USER COMPLETION CODE=1314
     TIME=17.15.04  SEQ=04566  CPU=0000  ASID=0106
     PSW AT TIME OF ERROR  078D1000 9D33CF8C   ILS 2  INTC 0D
       ACTIVE LOAD MODULE          ADDRESS=1D336C80  OFFSET=0000630C
       NAME=SASHOST
       DATA AT PSW 1D33CF86 - 00181610  0A0D0000  00000000
       AR/GR 0:  80BFF8D0/80000000   1: 00000000/80000522
             2:  00000000/1E2AB290   3: 00000000/1E2B4800
             4:  00000000/1D459480   5: 00000000/1D457A84
             6:  00000000/00000522   7: 00000000/1E2AB278
             8:  00000000/00000522   9: 00000000/1D4597A0
             A:  00000000/1E1657E0   B: 00000000/FFFFFFFC
             C:  00000000/8000C000   D: 00000000/1E2AB290
             E:  00000000/9D457B36   F: 00000000/1D33CF48
      END OF SYSTEM DUMP     

This error occurs because memory is not being freed appropriately.

Select the Hot Fix tab in this note for information on how to obtain the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.1 TS1M3 SP49.2 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.