|
Problem IC68534
|
Status: Closed |
INSTANCE MAY CRASH WHEN STATEMENT MONITOR IS ON AND LOTS OF QUERIES INCLUDING SOME SAME QUERIES ARE PREFORMED CONCURRENTLY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
Instance may crash with the following stacks when the statement
monitor is on and lots of queries including some same queries
are preformed concurrently on the federated environment.
<StackTrace>
-------Frame------ ------Function + Offset------
0x000000000000F498 ?unknown + 0x0
0x090000000577253C
locate_or_add_stmt__18sqlqg_remote_stmtsFP24sqlqg_anchor_remote_
stmtPUciPP30sqlqg_remote_stmt_monitor_info
+ 0x314
0x090000000579D96C
rollup__18sqlqg_remote_stmtsFP30sqlqg_remote_stmt_monitor_info +
0x84
0x0900000004175CC4
@79@sqlqg_rollup_remote_stmt__FP8sqeAgentPcP30sqlqg_remote_stmt_
monitor_info
+ 0x1F8
0x0900000004136AEC sqlqgClose__FP12sqlri_rquerys + 0x834
0x09000000041361FC sqlqgClose__FP12sqlri_rquerys@glue710 + 0x74
0x0900000005E8C3F0
sqlricjpInfrequent__FP8sqlrr_cbPP12sqlri_opparml + 0x204
0x090000000606299C sqlricjp__FP8sqlrr_cbP12sqlri_opparmilT4 -
0x1D0
0x090000000608F53C sqlricls_complex__FP8sqlrr_cbilN23 - 0x590
0x0900000006090440 @87@sqlricls__FP8sqlrr_cbiN32 + 0x64
0x0900000006200250 sqlrr_process_close_request__FP8sqlrr_cbiN32
+ 0xE4
0x0900000003D5FC0C
sqlrr_process_close_request__FP8sqlrr_cbiN32@glueD7B + 0x80
0x0900000004CE8BA0
sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x23C
0x0900000006203DD8
sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x910
0x090000000620344C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x4
0x090000000604FD3C
.sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface_fdprpro_clone_15
6
+ 0x278
0x0900000006036330 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x4BC
0x0900000005EF4464
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
0x0900000005EF42CC
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
0x0900000005EF3CF0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0xD8
0x0900000006175D4C RunEDU__8sqeAgentFv + 0x13C
0x0900000006175A94 EDUDriver__9sqzEDUObjFv + 0x94
0x090000000617BCAC sqloEDUEntry + 0x4
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* As same as Error description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.1 FixPack 10. *
**************************************************************** |
| Local Fix: |
Turn off the statement monitor. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.1 FixPack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.05.2010
16.06.2011
16.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
