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

DB2LOGGR REPORTS "FILE SHARING VIOLATION" IN FUNCTION SQLPGIFL()
TO INITIALIZE A TRANSACTION LOG FILE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
1. Creation of child processes of db2sysc can be observed before 
"File sharing violation." 
 
2. The file sharing error must be reported in db2diag.log as 
follows: 
 
2011-10-28-06.44.59.880022+480 I72250072A467      LEVEL: Error 
PID     : 889178               TID  : 9768        PROC : db2sysc 
0 
INSTANCE: xxxxx             NODE : 000         DB   : xxxxx 
EDUID   : 9768                 EDUNAME: db2loggr (xxxx_ 0 
FUNCTION: DB2 UDB, data protection services, sqlpgifl, probe:130 
RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
 
3.  Log file cannot be used and logging was stopped because an 
new log isn't created successfully. 
 
2011-10-28-06.45.13.749354+480 I73016319A455      LEVEL: Error 
PID     : 889178               TID  : 9768        PROC : db2sysc 
0 
INSTANCE: xxx                NODE : 000         DB   : xxxx 
EDUID   : 9768                 EDUNAME: db2loggr (BCUP01) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgsck, probe:430 
RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File 
cannot be used" 
          DIA8414C Logging can not continue due to an error. 
 
2011-10-28-06.45.13.749704+480 I73016775A525      LEVEL: Severe 
PID     : 889178               TID  : 9768        PROC : db2sysc 
0 
INSTANCE: xxxxx            NODE : 000         DB   : xxxxx 
EDUID   : 9768                 EDUNAME: db2loggr (BCUP01) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgasn, probe:290 
MESSAGE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File 
cannot be used" 
          DIA8414C Logging can not continue due to an error. 
DATA #1 : String, 41 bytes 
Logging can not continue due to an error.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 1. Creation of child processes of db2sysc can be observed    * 
* before                                                       * 
* "File sharing violation."                                    * 
*                                                              * 
* 2. The file sharing error must be reported in db2diag.log as * 
* follows:                                                     * 
*                                                              * 
* 2011-10-28-06.44.59.880022+480 I72250072A467      LEVEL:     * 
* Error                                                        * 
* PID    : 889178              TID  : 9768        PROC :       * 
* db2sysc                                                      * 
* 0                                                            * 
* INSTANCE: xxxxx            NODE : 000        DB  : xxxxx     * 
* EDUID  : 9768                EDUNAME: db2loggr (xxxx_ 0      * 
* FUNCTION: DB2 UDB, data protection services, sqlpgifl,       * 
* probe:130                                                    * 
* RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing * 
* violation."                                                  * 
*           DIA8519C A file sharing violation has occurred,    * 
* filename was "".                                             * 
*                                                              * 
* 3.  Log file cannot be used and logging was stopped because  * 
* an                                                           * 
* new log isn't created successfully.                          * 
*                                                              * 
* 2011-10-28-06.45.13.749354+480 I73016319A455      LEVEL:     * 
* Error                                                        * 
* PID    : 889178              TID  : 9768        PROC :       * 
* db2sysc                                                      * 
* 0                                                            * 
* INSTANCE: xxx                NODE : 000        DB  : xxxx    * 
* EDUID  : 9768                EDUNAME: db2loggr (BCUP01) 0    * 
* FUNCTION: DB2 UDB, data protection services, sqlpgsck,       * 
* probe:430                                                    * 
* RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File   * 
* cannot be used"                                              * 
*           DIA8414C Logging can not continue due to an error. * 
*                                                              * 
* 2011-10-28-06.45.13.749704+480 I73016775A525      LEVEL:     * 
* Severe                                                       * 
* PID    : 889178              TID  : 9768        PROC :       * 
* db2sysc                                                      * 
* 0                                                            * 
* INSTANCE: xxxxx            NODE : 000        DB  : xxxxx     * 
* EDUID  : 9768                EDUNAME: db2loggr (BCUP01) 0    * 
* FUNCTION: DB2 UDB, data protection services, sqlpgasn,       * 
* probe:290                                                    * 
* MESSAGE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File   * 
* cannot be used"                                              * 
*           DIA8414C Logging can not continue due to an error. * 
* DATA #1 : String, 41 bytes                                   * 
* Logging can not continue due to an error.                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.5FP9 and  higher versions.                      * 
****************************************************************
Local-Fix:
N/A
verfügbare FixPacks:
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
The problem will be addressed in V9.5FP9 and higher versions
Workaround
N/A
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC79923 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2011
22.03.2012
22.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList