Problem Note 31862: A U1314 abend might occur when a job sorts an SQL procedure view that references a DB2 table
 |  |  |  |  |
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 Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
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#031862A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#031862| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2008-05-14 15:36:19 |
| Date Created: | 2008-04-22 12:30:33 |