JR26935: INSTANCE CRASH DURING BINARY SORT.

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• Instance crash during binary sort.
  
  Within a function which handles the decimal sort key,
  the size of the packed decimal value is not correctly handled.
  We're over-reading the data from the input insert-buffer by 1
  extra byte. This can cause traps or violations when this last
  byte happens to fall right at the end of the insert-buffer
  allotted memory.
  
  The stack seen with this problem (only the top of the stack is
  shown):
  00000032 in <?LOAD_BINARY_WORD@@YAKPAEH@Z> <sqlsbsort.h:496>
  <?bsortPadBlanks>
  <sqlsgetfirstpkey.C:2364>
  <?bsortGetFirstPartialKey>
  <?bsortGetFirstPartialKey> <sqlsgetfirstpkey.C:553>
  <?qlsBinSort> <sqlsbsort.C:570>
  <?sqlsUseBinSort>
  

Local fix

• A workaround is to use the DB2_BINSORT registry variable to
  disable binary sorts, as follows:
  
  - db2set DB2_BINSORT=NO
  - db2stop
  - db2start
  

Problem summary

• Users Affected: ALL
  
  Problem Description:
  
  Instance crash during binary sort.
  
  The stack seen with this problem (only the top of the stack is
  shown):
  00000032 in <?LOAD_BINARY_WORD@@YAKPAEH@Z> <sqlsbsort.h:496>
  <?bsortPadBlanks>
  <sqlsgetfirstpkey.C:2364>
  <?bsortGetFirstPartialKey>
  <?bsortGetFirstPartialKey> <sqlsgetfirstpkey.C:553>
  <?qlsBinSort> <sqlsbsort.C:570>
  <?sqlsUseBinSort>
  
  Problem Summary:
  
  Within a function which handles the decimal sort key,
  the size of the packed decimal value is not correctly handled.
  We're over-reading the data from the input insert-buffer by 1
  extra byte. This can cause traps or violations when this last
  byte happens to fall right at the end of the insert-buffer
  allotted memory.
  

Problem conclusion

• Problem was first fixed in Version 8 FixPak 16 (s080111)
  )
  

Temporary fix

• see LOCAL FIX
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  JR27767 JR27768 JR28154

Modules/Macros

• Sort
  

Fix information

• Fixed component name

  DB2 UDB WSE WIN

• Fixed component ID

  5765F3501

Applicable component levels

• R820 PSY

     UP