Problem Note 41745: Accessing DB2 can result in System abend 0C4 in module SASIODB2
 |  |  |  |  |
In the z/OS operating environment, a 0C4 abend can occur under the following circumstances:
- You use SAS/ACCESS® Interface to DB2 to access a DB2 table via explicit pass-through processing.
- The READBUFF= option is set to a value other than 1.
- The ORDER BY statement is present outside of the explicit pass-through part of the query.
The following code illustrates one case that can produce the 0C4 abend:
proc sql;
connect to db2(readbuff=3);
create table test as
select * from connection to db2
(select * from class)
order by age;
quit;
In this case, the following error messages are generated:
ERROR: System abend 0C4 occurred in module SASIODB2 function db2m_fetch at
offset 0003A0.
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASXDBI FETCH 0007BC 0
NOTE: SASSQX @@244537 0002B0 0 sqxextr_get_next
NOTE: SASSQX @@032360 000108 0 sortgetblk_dir
NOTE: SASZSORT ZSORTK 001BE8 0
NOTE: SASZSORT ZSORTAP 001006 0
NOTE: SASSQX ZSORT 00011E 0
NOTE: SASSQX SQXZSSP 0008C2 0
NOTE: SASSQX @@719831 00010C 0 sqxsort_get_next
NOTE: SASSQX @@669285 000308 0 sqxcrta_get_next
NOTE: SASSQX @@669271 000A70 0 sqxcrta_open
NOTE: SASSQX @@669257 0001CE 0 sqxcrta_init
NOTE: SASSQX SQXEXEC 00012A 0
NOTE: SASSQX SQLLOOP 000DAC 0
NOTE: SASSQL SASSQL 000302 0
NOTE: SASXAL1 UNKNOWN 162DD0 0
A workaround to this problem is to turn off threaded sorts by changing the code to the following:
proc sql nothreads;
connect to db2(readbuff=3);
create table test as
select * from connection to db2
(select * from class)
order by age;
quit;
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.2 TS2M3 | 9.3 TS1M0 |
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#41745A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B94.html#41745| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-12-06 11:31:45 |
| Date Created: | 2010-12-03 11:45:18 |