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

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

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* DB2FORLUW                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 FP3                                     * 
****************************************************************
Local-Fix:
None 
 
Workaround after hitting the error: 
Move the log file to active log path manually and then kickoff 
roll forward, this time it should be fine.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC94732 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.04.2013
01.08.2013
06.09.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList