|
Problem IC68552
|
Status: Closed |
Online backup (with include logs) to TSM may fail due to an inco rrect estimation of space needed for the backup and log files |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A backup to TSM shows incorrect size estimate. By default an
online backup will include logs. The backup image and the logs
are sent in two separate files to TSM. When the size estimate of
the database is calculated it is incorrectly applied to the logs
file as well. the result is a size estimation sent to TSM almost
twice as big as the correct size.
Example below:
==> db2adutl query db Test|more
Query for database Test
Retrieving FULL DATABASE BACKUP information.
1 Time: 20100223010001 Oldest log: S0000098.LOG DB
Partition Number: 0 Sessions: 2
==> dsmc query backup /Test/
API 90,858,508 KB 02/23/10 01:00:03 DB2DATA A
/Test/NODE0000/FULL_BACKUP.20100223010001.1 ==> data
API 90,858,508 KB 02/23/10 03:28:54 DB2DATA A
/Test/NODE0000/FULL_BACKUP.20100223010001.2 ==> log file(s)
User data is ~90 GB and log file is 4MB. And yet both backup
images are ~90GB in size. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* A backup to TSM shows incorrect size estimate. By default an *
* *
* online backup will include logs. The backup image and the *
* logs *
* are sent in two separate files to TSM. When the size *
* estimate of *
* the database is calculated it is incorrectly applied to the *
* logs *
* file as well. the result is a size estimation sent to TSM *
* almost *
* twice as big as the correct size. *
* *
* *
* *
* Example below: *
* *
* *
* *
* ==> db2adutl query db Test|more *
* *
* Query for database Test *
* *
* Retrieving FULL DATABASE BACKUP information. *
* *
* 1 Time: 20100223010001 Oldest log: S0000098.LOG DB *
* *
* Partition Number: 0 Sessions: 2 *
* *
* *
* *
* ==> dsmc query backup /Test/ *
* *
* API 90,858,508 KB 02/23/10 01:00:03 DB2DATA A *
* *
* /Test/NODE0000/FULL_BACKUP.20100223010001.1 ==> data *
* *
* API 90,858,508 KB 02/23/10 03:28:54 DB2DATA A *
* *
* /Test/NODE0000/FULL_BACKUP.20100223010001.2 ==> log file(s) *
* *
* *
* *
* User data is ~90 GB and log file is 4MB. And yet both backup *
* *
* images are ~90GB in size. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack. *
**************************************************************** |
| 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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.05.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
