|
Problem IC78523
|
Status: Closed |
RESTORE DB WITH TRANSPORT FAILS WITH ERROR SQL2590N DUE TO LOG ARCHIVING FAILURE ON STAGING DATABASE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
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). |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 FixPak x |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91763
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.09.2011
27.03.2013
27.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
| 9.7.0.8
|
|
