|
Problem IT05907
|
Status: Closed |
-901 DURING ALTER FUNCTION STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
-901 during ALTER FUNCTION statement.. Happens during deadlock
conditions. A stack like the following could be seen
Stack trace:
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000000813AB0 pthread_kill + 0xB0
0x090000006746A79C ossPthreadKill__FCUiT1 + 0x5C
0x090000006746A890 sqloDumpEDU + 0x90
0x0900000067AE81BC sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
0x1BC
0x0900000067996B58 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x7D8
0x0900000067988078 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x58
0x0900000067988B28 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
0x428
0x0900000067E617EC sqlrrSqlCode + 0x2CC
0x09000000690520B0
sqlrl_alter_routines__FP8sqlrr_cbPUcsT2T3T2T3UcUiT2T3cP21sqlexSa
vedAuditEvents + 0xBD0
0x090000006FF451C4
sqlnq_alter_routine_stmt__FPP8stknode_i10actiontypePUcP3loc +
0x1604
0x090000006D17D2BC sqlnp_smactn__FP8sqlnp_cbi + 0x165C
0x090000006D174450 sqlnp_parser__FP8sqlnp_cb + 0x1990
0x090000006FD20A54
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xD54
0x090000006DFE4F8C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x4E4C |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Deadlock conditions *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Write applications to minimize deadlocks *
**************************************************************** |
| Local Fix: |
Applications need to be written to minimize deadlock conditions |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.12.2014
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
