|
Problem IC83577
|
Status: Closed |
DB2 does not archive logs after changing from LOGRETAIN to DISK until the database is recycled and this may cause a hang. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 does not archive logs after changing from LOGRETAIN to DISK
until the database is recycled and this may cause a hang
situation.
when DB2 hits a disk full issue with LOGRETAIN on, changing from
LOGRETAIN to DISK cannot make DB2 start to archive logs until db
is recycled.
The disk full issue may cause dual log array full, so you can
see the following message indicating the problem that dual log
array is full and DB2 does not archive logs.
2012-04-15-18.04.20.632309-180 I5237A453 LEVEL: Info
PID : 3670842 TID : 7198 PROC : db2sysc 0
INSTANCE: <instance> NODE : 000
EDUID : 7198 EDUNAME: db2loggw (<dbname>) 0
FUNCTION: DB2 UDB, data protection services, sqlpgStartMfhEntry,
probe:7240
DATA #1 : <preformatted>
Dual log array is full. Checking if any new logs have been
archived.
end: 739763, lowestUnarchivedExtNum: 739758, path: 10 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97fp7 *
**************************************************************** |
| Local Fix: |
Restart the database |
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
fixed in v97fp7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.05.2012
20.02.2013
20.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
