home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT08907 Status: Closed

DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO END A NON-EXIST SAVE POINT

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* n/a                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 Fixpack 11 or later.                      * 
****************************************************************
Local Fix:


Solution


The problem is firstly fixed on DB2 V97 Fixpack 11.


Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.05.2015
12.10.2015
12.10.2015


Problem solved at the following versions (IBM BugInfos)


9.7.FP11



Problem solved according to the fixlist(s) of the following version(s)


9.7.0.11

FixList