Fixes are available
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
DB2 instance might crash with SEGV when executing a certain SQL query. The crash only occurs in an SMP enabled environment and the stack traces should be similar to the following: sqldAdjustSeqDetPFAmount sqlriNljnAdjustPfAmount sqlriNljnNonPiped sqlriSectInvoke ....
Local fix
Turn off SMP by setting DBM configuration parameter INTRA_PARALLEL to OFF
Problem summary
**************************************************************** * USERS AFFECTED: * * the users who execute a certain SQL query in an SMP enabled * * environment. * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 instance might crash with SEGV when executing a certain * * SQL query. The crash only occurs in an SMP enabled * * environment and the stack traces should be similar to the * * following: * * * * sqldAdjustSeqDetPFAmount * * sqlriNljnAdjustPfAmount * * sqlriNljnNonPiped * * sqlriSectInvoke * * ...... * **************************************************************** * RECOMMENDATION: * * Turn off SMP by setting DBM configuration parameter * * INTRA_PARALLEL to OFF * ****************************************************************
Problem conclusion
Problem was first fixed in Version 9.5 Fix Pack 5
Temporary fix
Comments
APAR Information
APAR number
JR33261
Reported component name
DB2 UDB ESE WIN
Reported component ID
5765F4101
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-05
Closed date
2010-01-19
Last modified date
2010-01-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB ESE WIN
Fixed component ID
5765F4101
Applicable component levels
R950 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 January 2010