DB2 - Problem description
Problem IT35055 | Status: Closed |
DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Db2 may terminate abnormally during object creation when the auto_reval database configuration parameter is set to deferred force. The stack is similar to this example from Linux: 0x00002AAAAEA13604 _Z25sqlnq_ddl_create_func_endP9sqlnq_qtbbbP12sqlnq_string + 0x6a54 (/home/.../sqllib/lib64/libdb2e.so.1) 0x00002AAAB0B438DB _Z23sqlnq_create_with_errorPhihP9sqlnq_qtbS1_P3loc + 0x0beb (/home/.../sqllib/lib64/libdb2e.so.1) 0x00002AAAAE7C1803 address: 0x00002AAAAE7C1803 ; dladdress: 0x00002AAAAACE1000 ; offset in lib: 0x0000000003AE0803 ; (/home/.../sqllib/lib64/libdb2e.so.1) 0x00002AAAAE7BB82F _Z15sqlnq_resolveFnP9sqlnq_pidP12sqlnq_stringPhPiP3locisi + 0x03cf (/home/.../sqllib/lib64/libdb2e.so.1) 0x00002AAAAEA218DB _Z22sqlnq_ddl_function_refP9sqlnq_pid + 0x02ab (/home/.../sqllib/lib64/libdb2e.so.1) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.6.0 * **************************************************************** | |
Local Fix: | |
Change the auto_reval database configuration parameter to deferred and create objects in dependency order | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.6.0 * **************************************************************** | |
Comment | |
First fixed in Db2 version 11.5.6.0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.11.2020 21.06.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |