|
Problem IC68552
|
Status: Geschlossen |
Online backup (with include logs) to TSM may fail due to an inco rrect estimation of space needed for the backup and log files |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.05.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
