|
Problem IC65813
|
Status: Closed |
DB2 INSTANCE MAY CRASH IN ADD_AGNT_STMT_COUNTS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 instance may crash in add_agnt_stmt_counts due to NULL
pointer being referenced.
Stack looks like :
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000041DDE24
add_agnt_stmt_counts__11sqlmon_stmtFRC18sqlmon_stmt_countsPC11sq
lmon_tqcbCUi
+ 0x418
0x090000000324762C
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N25N21CiP8sqlrr_cb
+ 0xB10
0x09000000048371CC sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i
+ 0x218
0x0900000003B171A8
sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i@glue636 +
0x88
0x09000000037AB770
sqlricls_dbmon_start__FP8sqlrr_cbP9sqlr_apdrP25sqlra_sql_context
_siblingP11sqlmon_stmtP11sqlmon_conni
+ 0x24
0x09000000037C003C sqlricls_complex__FP8sqlrr_cbilN23 + 0x20
0x09000000033DB874
@65@5@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibli
ngiN63 +
0xB8
0x09000000033DAD40 sqlracal_finalcmt_rb__FP8sqlrr_cb + 0x3B0
0x09000000033DB224 sqlracal__FP8sqlrr_cbUiT2 + 0x70
0x09000000033DB0FC
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 +
0x1A8
0x090000000351EB3C sqlrrbck__FP8sqlrr_cbiN32P13sqlxaCallInfo +
0x354
0x0900000003654DA4 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l
+ 0x498
0x0900000002AE06C0
sqlrr_prepare__FP14db2UCinterfaceP13UCprepareInfo +
0x2CC
0x0900000002B1E5DC
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP14sqljsDDMObject
+ 0x9D4
0x090000000364FF4C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2U
Cinterface
+ 0x198
0x09000000036687DC
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x28C
0x090000000366753C
@48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb +
0x94
0x090000000340379C
@48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle
+ 0xA4
0x09000000034035F4
@48@sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb +
0xD4
0x0900000003403398 sqljsDrdaAsDriver__FP17sqlcc_init_struct +
0x9C
0x09000000034043C4 sqleRunAgent__FPcUi + 0x368
0x090000000340272C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270
0x0900000003401CCC sqloSpawnEDU + 0x234
0x0900000003401798
sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst
RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU
WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb
+ 0x314
0x090000000350DEE8
sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16
sqlkdRqstRplyFmtP17sqle_connect_info
+ 0x82C
0x09000000037FC2D0
sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16sqlkdRqs
tRplyFmtT1
+ 0x44C
0x090000000357F0E0 sqlcctcpconnmgr_child__FPcUi + 0x11E0
0x090000000340272C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270
0x0900000003401CCC sqloSpawnEDU + 0x234
0x090000000420C120
sqlcctcpconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfdUs +
0x58C
0x090000000420A0D4 sqlcctcp_start_listen + 0x44
0x0900000004209FDC sqlcctcp_start_listen@glue44D + 0x74
0x0900000003824134 sqlccstrts__FP9sqlf_kcfdP15SQLCC_CONNMGR_TRUs
+ 0x2C4
0x0000000100004C10 sqleInitSysCtlr__FPi + 0xE8C
0x00000001000031D4 sqleSysCtlr__Fv + 0x320
0x0900000002ED968C
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi +
0x524
0x09000000037F85F4 sqloRunInstance + 0xAC
0x00000001000029F8 DB2main + 0x930
0x0000000100003D50 main + 0x10
</StackTrace> |
| Problem Summary: |
DB2 instance may crash in add_agnt_stmt_counts due to NULL
pointer being referenced.
Stack looks like :
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000041DDE24
add_agnt_stmt_counts__11sqlmon_stmtFRC18sqlmon_stmt_countsPC11sq
lmon_tqcbCUi
+ 0x418
0x090000000324762C
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N25N21CiP8sqlrr_cb
+ 0xB10
0x09000000048371CC sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i
+ 0x218
0x0900000003B171A8
sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i@glue636 +
0x88
0x09000000037AB770
sqlricls_dbmon_start__FP8sqlrr_cbP9sqlr_apdrP25sqlra_sql_context
_siblingP11sqlmon_stmtP11sqlmon_conni
+ 0x24
0x09000000037C003C sqlricls_complex__FP8sqlrr_cbilN23 + 0x20
0x09000000033DB874
@65@5@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibli
ngiN63 +
0xB8
0x09000000033DAD40 sqlracal_finalcmt_rb__FP8sqlrr_cb + 0x3B0
0x09000000033DB224 sqlracal__FP8sqlrr_cbUiT2 + 0x70
0x09000000033DB0FC
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 +
0x1A8
0x090000000351EB3C sqlrrbck__FP8sqlrr_cbiN32P13sqlxaCallInfo +
0x354
0x0900000003654DA4 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l
+ 0x498
0x0900000002AE06C0
sqlrr_prepare__FP14db2UCinterfaceP13UCprepareInfo +
0x2CC
0x0900000002B1E5DC
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP14sqljsDDMObject
+ 0x9D4
0x090000000364FF4C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2U
Cinterface
+ 0x198
0x09000000036687DC
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x28C
0x090000000366753C
@48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb +
0x94
0x090000000340379C
@48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle
+ 0xA4
0x09000000034035F4
@48@sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb +
0xD4
0x0900000003403398 sqljsDrdaAsDriver__FP17sqlcc_init_struct +
0x9C
0x09000000034043C4 sqleRunAgent__FPcUi + 0x368
0x090000000340272C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270
0x0900000003401CCC sqloSpawnEDU + 0x234
0x0900000003401798
sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst
RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU
WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb
+ 0x314
0x090000000350DEE8
sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16
sqlkdRqstRplyFmtP17sqle_connect_info
+ 0x82C
0x09000000037FC2D0
sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16sqlkdRqs
tRplyFmtT1
+ 0x44C
0x090000000357F0E0 sqlcctcpconnmgr_child__FPcUi + 0x11E0
0x090000000340272C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270
0x0900000003401CCC sqloSpawnEDU + 0x234
0x090000000420C120
sqlcctcpconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfdUs +
0x58C
0x090000000420A0D4 sqlcctcp_start_listen + 0x44
0x0900000004209FDC sqlcctcp_start_listen@glue44D + 0x74
0x0900000003824134 sqlccstrts__FP9sqlf_kcfdP15SQLCC_CONNMGR_TRUs
+ 0x2C4
0x0000000100004C10 sqleInitSysCtlr__FPi + 0xE8C
0x00000001000031D4 sqleSysCtlr__Fv + 0x320
0x0900000002ED968C
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi +
0x524
0x09000000037F85F4 sqloRunInstance + 0xAC
0x00000001000029F8 DB2main + 0x930
0x0000000100003D50 main + 0x10
</StackTrace> |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, FixPak 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.01.2010
13.07.2010
13.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
