In some rare cases, DB2 may attempt to terminate a non-exist
save point, in turn the DB2 server is forced shutdown since the
database is marked bad.
The stack:
0x0900000000E830D4 pthread_kill + 0xD4
0x0900000007299030 sqloDumpEDU + 0x64
0x0900000007298944
sqleDoForceDBShutdownFODC__FP16sqeLocalDatabasei + 0x368
0x0900000007297F24 ForceDBShutdown__16sqeLocalDatabaseFi + 0xA80
0x0900000006E93410 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l
+ 0x1A8
0x0900000006EC3278 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x7B4
0x0900000006A0C3BC executeSection__10pvmPackageFP5sqlcaUib +
0x59FC
0x09000000069F7898 executeQuery__3PVMFUib + 0x108
0x09000000069F7B78 run__3PVMFv + 0x134
0x09000000078A4258 sqloInvokeFnArgs + 0x614
0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x175C
0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x175C
0x0900000006F4FFFC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x588
0x0900000006F4E060 sqlricall__FP8sqlrr_cb + 0x1E0
0x0900000006C22DDC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x74
0x0900000006EC4210 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0xB78
0x0900000006EC31C8 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x704
0x0900000006A0C3BC executeSection__10pvmPackageFP5sqlcaUib +
0x59FC
0x09000000069F7898 executeQuery__3PVMFUib + 0x108
0x09000000069F7B78 run__3PVMFv + 0x134
0x09000000078A4258 sqloInvokeFnArgs + 0x614
0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x175C
0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x175C
0x0900000006F4FFFC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x588
0x0900000006F4E060 sqlricall__FP8sqlrr_cb + 0x1E0
0x0900000006C22DDC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x74
0x0900000006EC4210 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0xB78
0x0900000006F672F0
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xBB0
0x0900000006F67EB0
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x1770
0x0900000006F6E1AC @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x7F8
0x0900000006F6E1AC @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x7F8
0x0900000006F6DDA0 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x3EC
0x0900000007CBD040
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
0x0900000007CBDB50
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8
0x0900000007BA8388 RunEDU__8sqeAgentFv + 0x3DCE4
0x0900000007C1D814 RunEDU__8sqeAgentFv + 0x124
0x09000000063C6D54 EDUDriver__9sqzEDUObjFv + 0x128
0x09000000061F2F84 sqloEDUEntry + 0x394
db2diag.log shows following error messages:
2014-11-27-09.43.26.642898+480 I3967150A566 LEVEL: Error
PID : 6291706 TID : 52769 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-551 APPID:
*LOCAL.db2inst1.141127010910
AUTHID : db2inst1 HOSTNAME: A-HOST-DB1
EDUID : 52769 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpSpEnd,
probe:960
MESSAGE : ZRC=0x87100020=-2028994528=SQLP_TNSV "No active save
point"
DIA8529C There were no active save points.
2014-11-27-09.43.26.643914+480 I3967717A975 LEVEL:
Severe
PID : 6291706 TID : 52769 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-551 APPID:
*LOCAL.db2inst1.141127010910
AUTHID : db2 HOSTNAME: A-HOST-DB1
EDUID : 52769 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlreesp, probe:200
MESSAGE : ZRC=0x87100020=-2028994528=SQLP_TNSV "No active save
point"
DIA8529C There were no active save points.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10054
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
<skipped>
2014-11-27-09.43.28.007170+480 I3985018A987 LEVEL:
Severe
PID : 6291706 TID : 52769 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-551 APPID:
*LOCAL.db2inst1.141127010910
AUTHID : db2 HOSTNAME: A-HOST-DB1
EDUID : 52769 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
MESSAGE : ZRC=0x87100020=-2028994528=SQLP_TNSV "No active save
point"
DIA8529C There were no active save points.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2
sqlerrmc: 32
sqlerrp : SQLRR01E
sqlerrd : (1) 0x87100020 (2) 0x00000020 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFD76 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
<skipped>
2014-11-27-09.43.47.310904+480 I4052371A3336 LEVEL: Info
PID : 6291706 TID : 52769 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-551 APPID:
*LOCAL.db2inst1.141127010910
AUTHID : db2 HOSTNAME: A-HOST-DB1
EDUID : 52769 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeLocalDatabase::ForceDBShutdown, probe:15604
MESSAGE : Regular agent EDU doing ForceDBShutdown. Force DB
shutdown agent ID
is:
DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
0-551
DATA #2 : sqeApplication_acbInfo,
PD_TYPE_sqeApplication_acbInfo, 4 bytes
x0
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000729802C ForceDBShutdown__16sqeLocalDatabaseFi +
0xB88
[1] 0x0900000006E93410
sqlrr_rds_common_post__FP14db2UCinterfaceiT2l + 0x1A8
[2] 0x0900000006EC3278
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x7B4
[3] 0x0900000006A0C3BC executeSection__10pvmPackageFP5sqlcaUib
+ 0x59FC
[4] 0x09000000069F7898 executeQuery__3PVMFUib + 0x108
[5] 0x09000000069F7B78 run__3PVMFv + 0x134
[6] 0x09000000078A4258 sqloInvokeFnArgs + 0x614
[7] 0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb +
0x175C
[8] 0x0900000006F51A68 sqlriInvokeInvoker__FP10sqlri_ufobb +
0x175C
[9] 0x0900000006F4FFFC sqlriInvokeInvoker__FP10sqlri_ufobb +
0x588 |
