PH56940: ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR FOR THE QUERY USING SINGLE INDEX ACCESS
Error description
ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR when explaining
an SQL statement whose access path contains single index access.
KEYWORDS: ABEND0C4 SQLEXPLAIN SQLACCESSPATH
Local fix
Avoid Explain on the impacted SQL statement.
Problem summary
****************************************************************
* USERS AFFECTED: *
* All users of Db2 12 and Db2 13 for z/OS who *
* explain queries whose access path contains *
* single index access. *
****************************************************************
* PROBLEM DESCRIPTION: *
* ABEND0C4 at DSNXOD3 offset 04726 may *
* happen when explaining an SQL *
* statement whose access path contains *
* single index access. *
* Abend only happens when the accessed *
* storage is not available. Otherwise, *
* incorrect information may be populated *
* into column IBM_SERVICE_DATA of *
* PLAN_TABLE. *
****************************************************************
* RECOMMENDATION: *
* Apply corrective PTF when available *
****************************************************************
For example:
EXPLAIN ALL SET QUERYNO = 1 FOR
SELECT C1,C2 FROM T1
WHERE T1.C1 = 100;
Index IX(C1) is chosen to access T1. When populating data into
PLAN_TABLE, an invalid array index zero is used that may result
in ABEND0C4 at DSNXOD3 offset 04726 or incorrect information in
column IBM_SERVICE_DATA of PLAN_TABLE.
Problem conclusion
Db2 has been modified to correctly process the aforementioned
SQL statement.
Additional Keywords ABEND0C4 SQLEXPLAIN SQLINDEX