A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00C90101 DSNIBNRF ERQUAL5007 when a SELECT uses an SPROC and a workfile sort. The error occurs due to the SPROC using an invalid null indicator value.
Local fix
REORG the tablespace to circumvent the error.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of rows with * * Basic Row Format and missing a nullable * * numeric column data (SMALLINT, INTEGER, * * BIGINT or FLOAT), which has been added * * without a new table version. * **************************************************************** * PROBLEM DESCRIPTION: * * An ABEND04E RC00C90101 DSNIBNRF:5007 * * may occur when fetching a row in a * * Basic Row Format without data on a * * nullable numeric column (SMALLINT, * * INTEGER, BIGINT or FLOAT), which * * has been added without a new table * * version. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** An ABEND04E RC00C90101 DSNIBNRF ERQUAL(7) may occur when fetching a row in a Basic Row Format without data on a nullable numeric column (SMALLINT, INTEGER, BIGINT or FLOAT), which has been added without a new table version. The reason for the abend is that Db2 has failed to generate correct assembled code for the default value of the nullable SMALLINT (INTEGER ,BIGINT OR FLOAT) column which is missing in a Basic Row Format row but the table is with current version.
Problem conclusion
Db2 is modified to generate correct assembled code to supply the default value for the missing nullable SMALLINT, INTEGER, BIGINT or FLOAT columns in a Basic Row Format row.
Temporary fix
Comments
APAR Information
APAR number
PH46494
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
2022-05-16
Closed date
2022-07-05
Last modified date
2022-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PH47668 UI81302
Modules/Macros
DSNIZMOV
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI81302
UP22/07/13 P F207
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.
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2022