Support Forums > z/OS Server

Recommended Db2 on z/OS Service, V13

(1/2) > >>

Ed_Arnold:
Placeholder for adding Db2 V13 issues surfaced by CMOD.

Db2 V13 has been/is being tested with CMOD, no issues found to date.

Ed

grahaj7:
Thanks, Ed.  Our shop is working on Db2 V13 upgrade now and I came here looking for info just like this.  If anything is found I will let the group know; although I expect it won't be ready to test around here for a couple months yet.

Ed_Arnold:
Just confirming, nothing special about Db2 V13 (yet).

CMOD isn't exploiting anything new in V13 (yet), and it's been ages since we hit anything in V12.

Ed

Ed_Arnold:
This is not a new error.  We've been running Db2 V13 for many months now.

We brought up a new Db2 back end and when we brought up ODF we hit:


--- Quote ---ARS0013E ODADMIN DB Error:  DB2 FOR OS/390  ODBC DRIVER   SQLSTATE=58004  ERRLOC=2:56:9   CAF "CONNECT" failed using DB2 system:DCDO   RC=08 and REASON=00f30055  -- SQLSTATE=58004, SQLCODE=-99999, File=arssys.c, Line=955   
                                                       
ARS4337I The ARSODF instance ARCHIVE is terminating         

--- End quote ---

Explanation is here:
 
https://www.ibm.com/docs/en/db2-for-zos/13?topic=codes-00f30055

Ended up increasing IDBACK to 500 which resolved the issue.

Ed

Ed_Arnold:
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

Navigation

[0] Message Index

[#] Next page