Fixes are available
APAR status
Closed as program error.
Error description
In some rare instances, the Db2 server may terminate abnormally while processing a TRANSFER OWNERSHIP statement. The stack looks similar to this example: 0x0000100CEC7E4EF0 0x000010000D1F5DF4 ( = offset 0xCE95DF4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E4F20 0x000010000D1F68AC ( = offset 0xCE968AC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E5340 0x000010000D1F6064 _Z29sqlnq_transfer_ownership_stmtPP8stknode_i10actiontypePhP3loc + 0x0214 ( = offset 0xCE96064 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E5860 0x000010000C9360C4 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0254 ( = offset 0xC5D60C4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E5960 0x000010000C9256C4 _Z12sqlnp_parserP8sqlnp_cb + 0x09a4 ( = offset 0xC5C56C4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E5A90 0x000010000C92CE84 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0de4 ( = offset 0xC5CCE84 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E6540 0x000010000C301988 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x8978 ( = offset 0xBFA1988 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000100CEC7E8320 0x000010000C2F8FEC _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x002c
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.1.4.6 or later * ****************************************************************
Problem conclusion
First fixed in Db2 version 11.1.4.6
Temporary fix
Comments
APAR Information
APAR number
IT30942
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-11-14
Closed date
2021-03-31
Last modified date
2021-03-31
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 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022