home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC99984 Status: Closed

REDIRECTED RESTORE MAY CAUSE EACCES (13) "PERMISSION DENIED"
ERRORS

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
A Redirected Restore may cause EACCES (13) "Permission denied" 
errors in db2diag.log if the source and target database are 
located on the same machine. The SET TABLESPACE CONTAINERS 
statement might attempt to access the old container paths from 
the source database/instance. In such a case you may observe the 
following messages in db2diag.log: 
 
2014-02-03-21.05.08.457378+060 E159544A1190         LEVEL: Error 
(OS) 
PID     : 11928422             TID : 11567          PROC : 
db2sysc 0 
INSTANCE: db2inst4             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-46                 APPID: 
*LOCAL.db2inst4.140203200227 
AUTHID  : DB2INST4             HOSTNAME: localhost 
EDUID   : 11567                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied" 
          DIA8701C Access denied for resource "", operating 
system return code 
          was "". 
CALLED  : OS, -, open 
OSERR   : EACCES (13) "Permission denied" 
DATA #1 : Codepath, 8 bytes 
4:11:18:20:24:40 
DATA #2 : File name, 38 bytes 
/db/data1/db2inst3/syscat.cont 
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 
4 bytes 
SQLO_REVISE, SQLO_READWRITE, SQLO_SHAREWRITE, 
SQLO_FORCE_NON_BUFFERED, SQLO_WRITETHRU 
DATA #4 : Hex integer, 4 bytes 
0x00000180 
DATA #5 : signed integer, 4 bytes 
DATA #6 : Hex integer, 4 bytes 
0x08000080 
DATA #7 : String, 105 bytes 
Search for ossError*Analysis probe point after this log entry 
for further 
self-diagnosis of this problem. 
 
This error message can be ignored and the subsequent restore 
should be successful.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 5.                      * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 Version 10.5 Fix Pack 5.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.03.2014
13.03.2015
13.03.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.5 FixList