DB2 - Problem description
Problem IT03975 | Status: Closed |
WHEN TABLESPACES ARE RESTORED FROM ONLINE BACKUP, ROLLFORWARD MA Y FAIL WITH SQL4970 IF NO LOG RECORDS EXIST FOR THE TABLESPACES. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
When restoring a subset of table spaces from an online backup the rollforward may fail if there are no log records present for the table spaces that have been restored. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * WHEN TABLESPACES ARE RESTORED FROM ONLINE BACKUP, * * ROLLFORWARD MAY FAIL WITH SQL4970 IF NO LOG RECORDS EXIST * * FOR THE TABLESPACES. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW version 10.1 fp5 * **************************************************************** | |
Local Fix: | |
Turn off log skipping with DB2_COLLECT_TS_REC_INFO registry variable. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.08.2014 20.03.2015 20.03.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 | |
10.5.0.5 |