Problem Note 40221: An S0C4 abend might occur when you access DB2 in the z/OS operating system
An S0C4 abend might occur when DB2 generates a non-zero return code following a fetch and when connections to DB2 are unique. The abend that appears is similar to the following:
ERROR: System abend 0C4 occurred in module SASIODB2 function D2GET at offset
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 @@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
The workaround for this problem is to make sure all of your connections to DB2 are defined as CONNECTION=GLOBAL.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 | 9.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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2020-07-30 16:34:54 |
| Date Created: | 2010-07-06 10:27:16 |
