DB2 FOR LUW / DB2FORLUW / 970 - DB2

When performing a Restore-TRANSPORT operation using a 
backup-image created from a database with log-archiving enabled, 
the staging database will inherit the log-archive configuration. 
Since some of the activity performed on the staging database 
during the Restore-TRANSPORT generates log records, it's 
possible for the staging database to archive log files (using 
the archive log path inherited from the backup image, which it 
may not have access to).  This will fail and cause the 
Restore-TRANSPORT operation to fail with an SQL2590N error, like 
the db2diag.log entry below: 
 
INSTANCE: target_inst              NODE : 000        DB  : 
SYSTG001 
APPHDL  : 0-20                APPID: 
*LOCAL.target_inst.100816163356 
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100 
CALLED  : OS, -, mkdir 
OSERR  : EACCES (13) "Permission denied" 
DATA #1 : String, 126 bytes 
A total of 2 analysis will be performed : 
- User info 
- Path access permission 
Target file = /db1/source_inst/archlog/target_inst

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Cross instance restore, transport operation fails with Error * 
*                                                              * 
* SQL2590N since log file found on the archival log path       * 
*                                                              * 
* of Staging database is getting created on Source DB path and * 
*                                                              * 
* fails with Permission issue.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version x.xx.xxx                              * 
****************************************************************

After the first phase of the Restore-TRANSPORT operation is 
complete, before updating container paths and continuing the 
Restore, you can connect to the staging database and disable 
log-archiving (LOGARCHMETH1).

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 FixPak x

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC91763 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.09.2011
27.03.2013
27.03.2013

9.7.