SUPPORT / SAMPLES & SAS NOTES
Problem Note 65384: Reading in a DB2 table that contains a column defined as a ROWID might result in an 0C4 abend
 |  |  |  |  |
Reading a DB2 table that contains a column that is defined as a ROWID data type might result in an 0C4 abend.
Here are some of the errors that have been encountered due to this issue:
SYSTEM COMPLETION CODE=0C4 REASON CODE=00000010
TIME=12.31.35 SEQ=54569 CPU=0000 ASID=005A
PSW AT TIME OF ERROR 078D1000 A25B159A ILC 4 INTC 10
ACTIVE MODULE ADDRESS=00000000_225AE000 OFFSET=
NAME=SASVM
DATA AT PSW 225B1594 - A7F4002A 18375E30 70081939
AR/GR 0: 007F2934/00000001_00000000 1: 00000001/00000000
2: FFFFFFFF/00000000_00000000 3: FFFFFFFF/00000000
4: FFFFFFFF/00000000_225B32F8 5: FFFFFFFF/00000000
6: FFFFFFFF/FFFFFFFF_243C88B8 7: FFFFFFFF/00000000
8: FFFFFFFF/00000000_00000001 9: FFFFFFFF/FFFFFFFF
A: FFFFFFFF/00000000_00000006 B: FFFFFFFF/00000000
C: FFFFFFFF/00000000_8004A000 D: FFFFFFFF/00000000
E: 00000000/00000001_233C0000 F: 00000000/00000000
END OF SYMPTOM DUMP
TIME=12.31.35 SEQ=54569 CPU=0000 ASID=005A
PSW AT TIME OF ERROR 078D1000 A25B159A ILC 4 INTC 10
ACTIVE MODULE ADDRESS=00000000_225AE000 OFFSET=
NAME=SASVM
DATA AT PSW 225B1594 - A7F4002A 18375E30 70081939
AR/GR 0: 007F2934/00000001_00000000 1: 00000001/00000000
2: FFFFFFFF/00000000_00000000 3: FFFFFFFF/00000000
4: FFFFFFFF/00000000_225B32F8 5: FFFFFFFF/00000000
6: FFFFFFFF/FFFFFFFF_243C88B8 7: FFFFFFFF/00000000
8: FFFFFFFF/00000000_00000001 9: FFFFFFFF/FFFFFFFF
A: FFFFFFFF/00000000_00000006 B: FFFFFFFF/00000000
C: FFFFFFFF/00000000_8004A000 D: FFFFFFFF/00000000
E: 00000000/00000001_233C0000 F: 00000000/00000000
END OF SYMPTOM DUMP
ERROR: System abend 0C4 occurred in module SASVM function VMZCMBN at offset 000
ERROR: Traceback will be attempted...
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASVM VMFREE 000392 0
NOTE: SASXDBI DBIGBFT 00009A 0
NOTE: SASXDBI YOECLOS 00018C 0
NOTE: SASYOIO YOCLOSE 001168 0
NOTE: SASZCPY COPYF 001DFC 0
NOTE: SASZCPY COPY 000DA0 0
NOTE: SASZCPY ZUTCOPY2 0000BA 0
NOTE: SASQUTIL UTCPYFI 000658 0
NOTE: SASQUTIL UTXXXXX 000D2C 0
NOTE: SASQUTIL UTILRUN 00A208 0
NOTE: SASQUTIL UTRSTMT2 000654 0
NOTE: SASQUTIL UTRSTMT 0000C4 0
NOTE: SASXSHEL YSPPROC 000806 0
NOTE: SASQUTIL XSPARSE 00010A 0
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASVM VMFREE 000392 0
NOTE: SASXDBI DBIGBFT 00009A 0
NOTE: SASXDBI YOECLOS 00018C 0
NOTE: SASYOIO YOCLOSE 001168 0
NOTE: SASZCPY COPYF 001DFC 0
NOTE: SASZCPY COPY 000DA0 0
NOTE: SASZCPY ZUTCOPY2 0000BA 0
NOTE: SASQUTIL UTCPYFI 000658 0
NOTE: SASQUTIL UTXXXXX 000D2C 0
NOTE: SASQUTIL UTILRUN 00A208 0
NOTE: SASQUTIL UTRSTMT2 000654 0
NOTE: SASQUTIL UTRSTMT 0000C4 0
NOTE: SASXSHEL YSPPROC 000806 0
NOTE: SASQUTIL XSPARSE 00010A 0
ERROR: System abend 0C4 occurred in module SASIODB2 function db2m_fetch at offset
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASXDBI YOEGET 0013BE 0
NOTE: SASYOIO YOGET 0004B6 0
NOTE: SASDSX DSISSR 0001F2 0
NOTE: UNKNOWN UNKNOWN DF893E 0
NOTE: SASWGH VGEXEC 0000A0 0
NOTE: SASDSX DSXXEXC 0000DC 0
NOTE: SASDS DSEXEC 0000AC 0
NOTE: SASDS SASDS 002F3E 0
NOTE: SASHOST UNKNOWN 002E2C 0
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASXDBI YOEGET 0013BE 0
NOTE: SASYOIO YOGET 0004B6 0
NOTE: SASDSX DSISSR 0001F2 0
NOTE: UNKNOWN UNKNOWN DF893E 0
NOTE: SASWGH VGEXEC 0000A0 0
NOTE: SASDSX DSXXEXC 0000DC 0
NOTE: SASDS DSEXEC 0000AC 0
NOTE: SASDS SASDS 002F3E 0
NOTE: SASHOST UNKNOWN 002E2C 0
Click the Hot Fix tab in this note to access 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.4 TS1M6 | 9.4 TS1M7 |
| z/OS 64-bit | 9.4 TS1M6 | 9.4 TS1M7 | ||