DB2 - Problembeschreibung
Problem IT08862 | Status: Geschlossen |
DB2 MAY LEAK FILE HANDLES WHEN RETRIEVING AN ARCHIVE LOG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When DB2 retrieves an archive log file, it tries to create a temporary file. This file should be deleted immediately, but if it remains for some reason, it will cause SQLO_FREV error and leak a file handle. Here is the db2diag.log example: 2015-05-12-09.46.30.847578+540 I27880345A628 LEVEL: Error PID : 23527480 TID : 4114 PROC : db2sysc INSTANCE: sminst2 NODE : 000 DB : SMDB2 HOSTNAME: y5isvdev15 EDUID : 4114 EDUNAME: db2lfr.0 (SMDB2) FUNCTION: DB2 UDB, data protection services, sqlpPathTest, probe:245 MESSAGE : ZRC=0x070F00CB=118423755=SQLO_FREV "File already exists." DATA #1 : String, 76 bytes /db2/DB/sminst2/SMDB2/sminst2/NODE0000/SQL00001/LOGSTREAM0000/LO GSTREAM0000/ DATA #2 : String, 81 bytes /db2/DB/sminst2/SMDB2/sminst2/NODE0000/SQL00001/LOGSTREAM0000/LO GSTREAM0000/.4114 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
Delete LOGPATH/LOGSTREAMxxxx/.<TID> file manually. | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.05.2015 01.02.2016 01.02.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |