IC98683: ROWS MISSING WHEN LARGE RESULT SET IS PRODUCED BY NULLS FIRST SORT ON INTEGER OR BIGINT

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• If sort is done with DESC (NULLS FIRST) on INT or BIGINT data
  types and the result set is large, then it is possible that the
  query does not return part of the rows back to the user.
  

Local fix

• Do not use sort with DESC (NULLS FIRST) on INT or BIGINT data
  types.  Or, if you must use such a sort, then use the following:
  db2set DB2_TCG_DEFAULT_OPTIONS="set num_page_fast_int_sort 0"
  Then recycle the instance using db2stop followed by db2start and
  recompile any static sections that use sort with DESC (NULLS
  FIRST) on INT or BIGINT data types.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 10.1.0.4.                             *
  ****************************************************************
  

Problem conclusion

• The problem is first fixed in DB2 version 10.1.0.4.
  

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:

  IT01020

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP