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

SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF
BACKUP" OPTION) ON DB2 FOR WINDOWS.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Problem Description: 
An error message "SQL1042C An unexpected system error occurred. 
SQLSTATE=58004" while applying transaction logs (till "end of 
backup" option) on DB2 for Windows. 
 
EDU db2loggr reports following error: 
EDUID   : 3692                 EDUNAME: db2loggr (<dbname>) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgTransferLogBackToActivePath, probe:220 
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
 
Example diaglog messages: 
 
2013-01-17-08.32.48.914000-480 I3522881F634         LEVEL: Error 
PID     : 2228                 TID : 2356           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
dbname 
APPHDL  :  apphdl                 APPID:  appid 
AUTHID  :  authid        HOSTNAME: hostname 
EDUID   : 2356                 EDUNAME: db2agent 
FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, 
probe:1230 
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
 
2013-01-17-08.32.48.945000-480 E3523517F607         LEVEL: 
Severe 
PID     : 2228                 TID : 2356           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
dbname 
APPHDL  : apphdl                 APPID:  appid 
AUTHID  : authid               HOSTNAME: hostname 
EDUID   : 2356                 EDUNAME: db2agent 
FUNCTION: DB2 UDB, data protection services, sqlpRfwFillSQLCA, 
probe:11500 
MESSAGE : SQL1042C  An unexpected system error occurred. 
DATA #1 : String, 19 bytes 
Roll Forward Error: 
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes 
0x870F0016
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2LUW                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Problem Description:                                         * 
* An error message "SQL1042C An unexpected system error        * 
* occurred.                                                    * 
* SQLSTATE=58004" while applying transaction logs (till "end   * 
* of                                                           * 
* backup" option) on DB2 for Windows.                          * 
*                                                              * 
* EDU db2loggr reports following error:                        * 
* EDUID   : 3692                 EDUNAME: db2loggr (<dbname>)  * 
* 0                                                            * 
* FUNCTION: DB2 UDB, data protection services,                 * 
* sqlpgTransferLogBackToActivePath, probe:220                  * 
* MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing * 
* violation."                                                  * 
*           DIA8519C A file sharing violation has occurred,    * 
* filename was "".                                             * 
*                                                              * 
* Example diaglog messages:                                    * 
*                                                              * 
* 2013-01-17-08.32.48.914000-480 I3522881F634         LEVEL:   * 
* Error                                                        * 
* PID     : 2228                 TID : 2356           PROC :   * 
* db2syscs.exe                                                 * 
* INSTANCE: DB2                  NODE : 000           DB   :   * 
* dbname                                                       * 
* APPHDL  :  apphdl                 APPID:  appid              * 
* AUTHID  :  authid        HOSTNAME: hostname                  * 
* EDUID   : 2356                 EDUNAME: db2agent             * 
* FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery,    * 
* probe:1230                                                   * 
* MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing * 
* violation."                                                  * 
*           DIA8519C A file sharing violation has occurred,    * 
* filename was "".                                             * 
*                                                              * 
* 2013-01-17-08.32.48.945000-480 E3523517F607         LEVEL:   * 
* Severe                                                       * 
* PID     : 2228                 TID : 2356           PROC :   * 
* db2syscs.exe                                                 * 
* INSTANCE: DB2                  NODE : 000           DB   :   * 
* dbname                                                       * 
* APPHDL  : apphdl                 APPID:  appid               * 
* AUTHID  : authid               HOSTNAME: hostname            * 
* EDUID   : 2356                 EDUNAME: db2agent             * 
* FUNCTION: DB2 UDB, data protection services,                 * 
* sqlpRfwFillSQLCA,                                            * 
* probe:11500                                                  * 
* MESSAGE : SQL1042C  An unexpected system error occurred.     * 
* DATA #1 : String, 19 bytes                                   * 
* Roll Forward Error:                                          * 
* DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes                          * 
* 0x870F0016                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.5 fixpack 3                               * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.08.2013
03.03.2014
03.03.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList