|
Problem IC83577
|
Status: Geschlossen |
DB2 does not archive logs after changing from LOGRETAIN to DISK until the database is recycled and this may cause a hang. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97fp7 *
**************************************************************** |
| Local-Fix: |
Restart the database |
| verfügbare FixPacks: |
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
|
| Lösung |
fixed in v97fp7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.05.2012
20.02.2013
20.02.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP7
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.7
|
 |
