Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.