PH46494: ABEND04E 00C90101 DSNIBNRF ERQUAL5007 5007 WHEN USING A SELECT WITH AN SPROC

Obtain the fix for this APAR.

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 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.