Running the command "db2pd -stack all" in parallel with a
restore execution, the restore can fail in function
SQLUREADFROMFILEDEVICE.
In db2diag.log, the following messages can be found:
=============================================
2014-09-08-09.25.24
495100-240 I289214966E929 LEVEL: Error
PID : 24145 TID : 46942692305216PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004
EDUID : 6370 EDUNAME: db2med.5605.0 (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqluReadFromFileDevice,
probe:836
MESSAGE : Received ERROR
DATA #1 : Hexdump, 107 bytes
0x00002AB1B4462214 : 2F76 6172 2F6D 7364 6232 2F6E 7974 7874
/var/msdb2/xxxx
0x00002AB1B4462224 : 3134 302F 6462 3262 6163 6B2F 6462 326E
140/db2back/db2n
0x00002AB1B4462234 : 6764 756D 702F 6462 325F 6C6F 6164 2E37
gdump/db2_load.7
0x00002AB1B4462244 : 3339 382F 6E79 7078 7430 3830 2E72 6176
398/xxxx.rav
0x00002AB1B4462254 : 6563 722E 4E4F 4445 3130 3034 2E43 4154
ecr.NODE1004.CAT
0x00002AB1B4462264 : 4E30 3030 312E 3230 3134 3039 3033 3139
N0001.2014090319
0x00002AB1B4462274 : 3030 3535 2E30 3031 2E64 62
0055.001.db
2014-09-08-09.25.24.495403-240 I289215896E409 LEVEL: Error
PID : 24145 TID : 46942692305216PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004
EDUID : 6370 EDUNAME: db2med.5605.0 (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqluReadFromFileDevice,
probe:907
DATA #2 : Hexdump, 4 bytes
0x00002AB1B27FD0A0 : A900 0F87
....
2014-09-08-09.25.24.495597-240 E289216306E608 LEVEL: Error
PID : 24145 TID : 46942692305216PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004
EDUID : 6370 EDUNAME: db2med.5605.0 (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
probe:1266
MESSAGE : Media controller -- Problem reading from local device
/var/msdb2/xxxx/db2back/db2ngdump/db2_load.7398/xxxx.ravecr.NO
DE1004.CATN0001.20140903190055.001.db (zrc =
0x870f00a9)
2014-09-08-09.25.24.495803-240 E289216915E435 LEVEL: Error
PID : 24145 TID : 46942692305216PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004
EDUID : 6370 EDUNAME: db2med.5605.0 (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
probe:1266
MESSAGE : SQL0902C A system error (reason code = "") occurred.
Subsequent SQL statements cannot be processed.
2014-09-08-09.25.24.496144-240 E289217351E342 LEVEL: Error
PID : 24145 TID : 46942692305216PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004
EDUID : 6370 EDUNAME: db2med.5605.0 (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
probe:1266
DATA #1 : String, 3 bytes
169
2014-09-08-09.25.24.881063-240 E289217694E533 LEVEL: Error
PID : 24145 TID : 46938191817024PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004 DB : RAVECR
APPHDL : 4-159 APPID: *N4.xxxx.140907175826
AUTHID : xxxx
EDUID : 5605 EDUNAME: db2agent (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqludMRResponse,
probe:869
MESSAGE : SQL0902C A system error (reason code = "169")
occurred. Subsequent
SQL statements cannot be processed.
2014-09-08-09.25.24.945601-240 E289218228E431 LEVEL: Severe
PID : 24145 TID : 46938191817024PROC :
db2sysc 4
INSTANCE: xxxx NODE : 004 DB : RAVECR
APPHDL : 4-159 APPID: *N4.xxxx.140907175826
AUTHID : MSDB2
EDUID : 5605 EDUNAME: db2agent (RAVECR) 4
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:800
MESSAGE : Restore Terminated. |
