|
Problem IC71102
|
Status: Closed |
DURING MIGRATION ONLINE BACKUPS ARE MARKED AS EXPIRED WITHOUT CONSIDERING RETENTION OR NUMBER OF BACKUP DB CONFIGURATIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In the process of migration all online backups are marked as
expired. These are the steps to reproduce the problem:
1. In old version make sure the following database
configurations are set:
db2 update db cfg using AUTO_DEL_REC_OBJ ON
db2 update db cfg using REC_HIS_RETENTN <value>
db2 update db cfg using NUM_DB_BACKUPS <value>
2. Take both online and offline backups and verify the images
are
there.
3. Migrate to new version
4. Verify that after migration all the images are still there
5. Take a backup on the new version.
6. Verify that all online images have been deleted.
The db2diag.log will contain entries such:
2010-09-05-06.36.31.030284-360 E702762A514 LEVEL: Info
PID : 1044698 TID : 7223 PROC : db2sysc
0
INSTANCE: xxxx NODE : 000 DB : xxx
APPHDL : 0-1556 APPID: *LOCAL.xxxx.100905123020
AUTHID : xxxxx
EDUID : 7223 EDUNAME: db2agent (xxxx) 0
FUNCTION: DB2 UDB, database utilities,
sqluhPruneHistoryDeleteFile, probe:1112
MESSAGE : ADM8504I Successfully deleted the backup image with
timestamp
"20100502063031". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All migrating from v95 *
****************************************************************
* PROBLEM DESCRIPTION: *
* In the process of migration all online backups are marked as *
* expired. *
* The online backups will not be available for recovery if the *
* migration fails. *
****************************************************************
* RECOMMENDATION: *
* Apply FP4. *
* As a preventive measure follow the recommended migration *
* process. That incldes a full offline backup. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 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 fixed first in v97 FP4 |
| Workaround |
NA |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2010
19.05.2011
19.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
