A fix is available
APAR status
Closed as program error.
Error description
DB2 DDF thread ABND 04E-00D35011 LOC DSNLZGLM.DSNLZRCD:005D. The above abend may or may not also be seen with secondary abends as shown below 0C7-00000000 LOC=DSNLXGLM.DSNXROHB+03050 04E-00D35011 LOC=DSNLZGLM.DSNLZTRC:0065 04E-00D35011 LOC=DSNLZGLM.DSNLZRCD:0370 This problem occurs in a Db2 z/os and DB2 LUW configuration. Additional keywords and Symptoms: ********************************* DB2DDF DDF ABND04E ABEND04E 004E 00D35011 RC00D35011 DSNLRCD ABNDID005D 005D ABEND0C7 0C7 DSNXROBH OFFSET03050 DSNXROHB DSNLZTRC DSNLZRCD ABNDID0370 0370
Local fix
no local workaround or fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Distributed Data Facility (DDF) users * * who use Db2 12 for z/OS requester to * * retrieve a set of rows using block fetch * * from Db2 LUW server. * **************************************************************** * PROBLEM DESCRIPTION: * * Db2 z/OS requester retrieving set of * * rows from Db2 LUW server using block * * fetch can result in following * * symptoms: * * - ABND 04E-00D35011, * * DSNLZGLM.DSNLZRCD:0370. * * - ABND 0C7-00000000, * * LOC=DSNLXGLM.DSNXROHB+03050. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When fetching rows from Db2 LUW server, the query blocks returned can contain a partial row at the end so as to completely fill the query block to the desired query block size. Since the query blocks can be chained, partial row can occur in any of the block(s). Db2 z/OS requester incorrectly assumed that the partial row can only occur in last query block in the chain. Parsing problem due to the incorrect assumption led to the reported conditions.
Problem conclusion
Db2 z/OS requester code has been changed to account for partial row returned in a query block from Db2 LUW server.
Temporary fix
Comments
APAR Information
APAR number
PH33329
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-01-13
Closed date
2021-04-15
Last modified date
2021-08-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI74949
Modules/Macros
DSNLZRPA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI74949
UP21/04/23 P F104
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
20 August 2021