| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC91266 | Status: Closed |
SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF BACKUP" or POINT IN TIME OPTION) ON DB2 FOR WINDOWS. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| 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 | |
| Problem Summary: | |
**************************************************************** * 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. | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC94732 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.04.2013 01.08.2013 06.09.2013 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.3 |
|
| 10.1.0.3 |
|