|
Problem IC64538
|
Status: Closed |
SQL0970N DURING RESTORE ... WITHOUT ROLLING FORWARD WHILE THE ORIGINAL OVERFLOWLOGPATH IS INACCESSIBLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Restore may fail because of inaccessible OVERFLOWLOGPATH saved
in the backup image, i.e. the OVERFLOGLOGPATH of the source
database where the backup was taken. This can be caused for
example by incorrect file access permissions or a non-existent
directory path on the target system where the restore is being
performed. Under such conditions the restore will fail with
SQL0970N. A good eyecatcher is error -970 from "sqludProcessLFH,
probe:1149" reported in the DB2 diagnostic log file.
.
Example:
========
+ db2 restore database source continue
SQL0970N The system attempted to write to a read-only file.
SQLSTATE=55009
.
db2diag.log:
============
2009-11-10-13.47.43.502353-300 I9133A578 LEVEL: Error
PID : 4403420 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID: *LOCAL.db2inst1.091110184735
AUTHID : DB2INST1
EDUID : 1801 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, data protection services,
sqlpRemoveRetrievedLogFiles, probe:20
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code was "".
.
2009-11-10-13.47.43.508938-300 E9712A551 LEVEL: Severe
PID : 4403420 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID: *LOCAL.db2inst1.091110184735
AUTHID : DB2INST1
EDUID : 1801 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities,
sqludProcessLFH, probe:1149
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-970 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users performing redirected restores and having the *
* OVERFLOWLOGPATH set to an inaccessible path. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Restore may fail because of inaccessible OVERFLOWLOGPATH *
* saved in the backup image, i.e. the OVERFLOGLOGPATH of the *
* sources database where the backup was taken. This can be *
* caused for example by incorrect file access permissions or a *
* non-existent directory path on the target system where the *
* restore is being performed. Under such conditions the *
* restore will fail with SQL0970N. A good eyecatcher is error *
* -970 from "sqludProcessLFH,probe:1149" reported in the DB2 *
* diagnostic log file. *
* *
* Example: *
* ======== *
* + db2 restore database source continue *
* SQL0970N The system attempted to write to a read-only file. *
* SQLSTATE=55009 *
* . *
* db2diag.log: *
* ============ *
* 2009-11-10-13.47.43.502353-300 I9133A578 *
* LEVEL: Error PID : 4403420 TID : 1801 *
* PROC : db2sysc INSTANCE: db2inst1 NODE : 000 *
* DB : SAMPLE APPHDL : 0-7 APPID: *
* *LOCAL.db2inst1.091110184735 AUTHID : DB2INST1 *
* EDUID : 1801 EDUNAME: *
* db2agent (SAMPLE) FUNCTION: DB2 UDB, data protection *
* services, *
* sqlpRemoveRetrievedLogFiles, probe:20 *
* RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access *
* Denied" *
* DIA8701C Access denied for resource "", operating system *
* return code was "". . *
* *
* 2009-11-10-13.47.43.508938-300 E9712A551 LEVEL: Severe *
* PID : 4403420 TID : 1801 PROC : db2sysc *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* APPHDL : 0-7 APPID: *LOCAL.db2inst1.091110184735 *
* AUTHID : DB2INST1 *
* EDUID : 1801 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, database utilities, sqludProcessLFH, *
* probe:1149 *
* DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes *
* -970 *
****************************************************************
* RECOMMENDATION: *
* Install version 9.7 FixPak 2 *
**************************************************************** |
| Local Fix: |
Modify file and directory permissions at operating system level
in order to allow the instance owner to access the path
specified in the OVERFLOWLOGPATH. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in version 9.7 FixPak 2
The fix is to ignore the value of OVERFLOWLOGPATH should it not
be accessible to DB2 during the RESTORE process. The output will
be as follows:
$ db2 restore database source from /TCDIR/BKUPS taken at
20091109181255
on /TCDIR/TARGET_PATH dbpath on /TCDIR/TARGET_DB into source
redirect
without rolling forward without prompting
SQL1277W A redirected restore operation is being performed.
Table space configuration can now be viewed and table spaces
that do not use automatic storage can have their containers
reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
$ db2 restore database source continue
DB20000I The RESTORE DATABASE command completed successfully.
and in db2diag.log:
2009-11-10-13.56.27.903814-300 I9133A578 LEVEL: Error
PID : 2596926 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SOURCE
APPHDL : 0-8 APPID: *LOCAL.db2inst1.091110185622
AUTHID : db2inst1 EDUID : 1801 EDUNAME: db2agent
(SOURCE)
FUNCTION: DB2 UDB, data protection services,
sqlpRemoveRetrievedLogFiles, probe:20
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system
return code was "".
2009-11-10-13.56.27.921783-300 I9712A620 LEVEL: Error
PID : 2596926 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SOURCE
APPHDL : 0-8 APPID:
*LOCAL.db2inst1.091110185622
AUTHID : db2inst1
EDUID : 1801 EDUNAME: db2agent (SOURCE)
FUNCTION: DB2 UDB, database utilities, sqludProcessLFH,
probe:1159
MESSAGE : Error -2079391743 when deleting log files in the
OVERFLOWLOGPATH DB
configuration parameter /TCDIR/SOURCE/OVLOGS/. DB2
will
ignore this error and continue with the restore.
Please note that after the completion of the restore, the
configuration parameter will not be blanked out and will still
contain the original value that was stored in the backup image.
Thus it will be up to the database administrator to ensure that
the OVERFLOWLOGPATH value is modified to the proper value after
completion of the redirected restore. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.11.2009
18.05.2010
18.05.2010 |
| 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.2
|
 |
