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 IT09671 Status: Closed

TOO MANY LOGS CAUSING READS ON STANDBY DATABASE TO CRASH

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
In the db2diag.log you will see messages like this: 
 
2015-06-11-14.30.15.143760-300 I163341A515          LEVEL: 
Warning 
PID     : 12976138             TID : 42664          PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-12                 APPID: *LOCAL.DB2.150607221510 
HOSTNAME: SERVER02 
EDUID   : 42664                EDUNAME: db2redom (SAMPLE) 0 
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1435 
MESSAGE : Almost too many logs 
DATA #1 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes 
0 
 
2015-06-11-14.44.17.672907-300 I177884A1014         LEVEL: Error 
PID     : 12976138             TID : 42664          PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-12                 APPID: *LOCAL.DB2.150607221510 
HOSTNAME: SERVER02 
EDUID   : 42664                EDUNAME: db2redom (SAMPLE) 0 
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1434 
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic 
Error" 
          DIA8526C A fatal error occurred in data protection 
services. 
DATA #1 : String, 14 bytes 
Too many logs. 
DATA #2 : String, 64 bytes 
logStreamId / lowtranlsn / minbufflsn / minPseudoLsn / recordLsn 
DATA #3 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes 
0 
DATA #4 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes 
000035705576C71F 
DATA #5 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes 
00003570BDFB4858 
DATA #6 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes 
FFFFFFFFFFFFFFFF 
DATA #7 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes 
00003570BEE383EF 
 
Then the database crashes.  The cause is that the logs are not 
being cleaned up on the standby, creating the "too many logs" 
scenario.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 fix pack 7.                              * 
****************************************************************
Local Fix:
Stop and start standby database to clear up the logs.
Solution
First fixed in DB2 10.5 fix pack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.06.2015
27.01.2016
27.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList