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

DB2DIAG.LOG GROWING VERY FAST WITH MANY MESSAGES FROM
SQLPLOGALLOCCANDIDATEPOOL::REFRESH, PROBE:60

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
On HADR standby, the db2diag.log file is growing very fast with
many messages like the following:

2019-01-25-18.12.54.513886+000 I4134509E612 LEVEL: Info
PID : 17686 TID : 140122481747712 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
HOSTNAME: host1
EDUID : 27 EDUNAME: db2logalloc.0 (TESTDB) 0
FUNCTION: DB2 UDB, data protection services,
sqlpLogAllocCandidatePool::refresh, probe:60
MESSAGE : cpStartExtPos is greater than cpEndExtPos. Forcing
extCount to 0.
DATA #?1 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
798
DATA #?2 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
797

This is a boundary condition, on a new standby database (after
initialization or after takeover command).  The messages will
stop after some work on the primary has generated new log files
for the standby.  Note that in the above example, the value
shown in DATA #1 (which is 798) is the log file number that
would end the boundary condition (ie. the messages will stop
when the primary database is producing log files 798 and
beyond).
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* HADR standbys                                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to the latest fix pack                               *
****************************************************************
Local Fix:
Perform work on the primary to generate new log files for the
standby database to process.
Solution
Workaround
Perform work on the primary to generate new log files for the
standby database to process.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
07.02.2019
31.10.2019
31.10.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)