|
Problem IC94732
|
Status: Closed |
SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF BACKUP" OPTION) ON DB2 FOR WINDOWS. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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: *
* 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: |
|
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.08.2013
03.03.2014
03.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
