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 IC75360 Status: Geschlossen

DB2 CAN RECEIVE UNEXPLAINED SHARING VIOLATION ERRORS LEADING TO
UNPREDICTABLE BEHAVIOUR.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
DB2 starts a child process for a number of database operations, 
e.g. backup, log archive, load from federated data source or 
load with load copy yes TSM option. 
 
The child process that is created , inherits the file handles of 
the parent process and closes them after the fork api call 
completes. 
On busy systems, the delay in the execution of the fork can 
cause the parent process to receive "ETXTBSY" - file sharing 
errors whilst the fork call takes place. 
 
The DB2 code has a retry loop to handle retry the operation when 
receiving such an error, but sometimes the delay is even longer 
than this retry loop which may cause undesirable behaviour of 
DB2, including in worst case scenario a panic of the server. 
 
Note that in apar IC70039, the above mentioned retry loop was 
already extended significantly. 
This apar fix extends the retry logic of apar IC70039 even 
further so that receiving the file sharing violation error 
becomes near impossible. 
An architectural solution for this problem has been deferred to 
a major release 
 
 
A typical db2diag.log error may show : 
 
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
CALLED  : OS, -, open 
 
The behaviour of the product will then depend on which area of 
the code the error was received.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Sharing violation error can be received by DB2 during an     * 
* internal fork operation, this can lead to unexpected DB2     * 
* behaviour including a server abend.                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 and Fix Pack 8                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 Version 9.5 and Fix Pack 8
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC76027 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.03.2011
21.07.2011
21.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.5.0.8 FixList