home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList