Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC65813 Status: Geschlossen

DB2 INSTANCE MAY CRASH IN ADD_AGNT_STMT_COUNTS.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
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:
verfügbare FixPacks:
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

Lösung
First fixed in DB2 UDB Version 9.7, FixPak 2.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.01.2010
13.07.2010
13.07.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.2 FixList