Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT05192 Status: Closed

"DB2PD -STACK ALL" CAUSE THE RESTORE FAILURE IN FUNCTION
"SQLUREADFROMFILEDEVICE"

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7Fix Pack 11.                       * 
****************************************************************
Local Fix:
Avoid running "db2pd -stack all" during restore.
Solution
First fixed in Version 9.7Fix Pack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.10.2014
25.11.2015
25.11.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FIX
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.