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 IC65200 Status: Closed

"INCREMENTAL/INCREMENTAL DELTA" BACKUP FOLLOWING AN INTERRUPTED
FULL BACKUP WILL SCAN EXTRA TABLE SPACES

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
If you interrupt a full backup, the subsequent 
"INCREMENTAL/INCREMENTAL DELTA" backup will scan extra table 
spaces that do NOT have eligible data for this backup. 
Normally DB2 should not scan data on these table spaces during 
"INCREMENTAL/INCREMENTAL DELTA" backup. 
However when a full backup is interrupted, DB2 wrongly sets some 
internal flags on the table spaces included in the full backup. 
As a result, DB2 believes these table spaces have eligible data 
for the subsequent "INCREMENTAL DELTA" backup. 
This problem only occurs in databases where the configuration 
parameter "TRACKMODE" is set to YES. 
 
This issue will bring a big overhead to the "INCREMENTAL DELTA" 
backup if the "extra table spaces" are large in size, as the 
scan on extra table spaces are time-consuming and totally 
unnecessary. 
 
To find out which table spaces are included in an "INCREMENTAL 
DELTA" backup, issue "list tablespaces" command when the backup 
is running to get the hexadecimal state values of the table 
spaces. 
You can then use "db2tbst" command to get the state from the 
hexadecimal state value and see which table spaces are in state 
of "Backup in Progress". 
Please note: 
Normally, at the beginning of "INCREMENTAL/INCREMENTAL DELTA" 
backup there is a short period of time during which you will see 
all table spaces are in state of "Backup in Progress". This 
because DB2 is checking some meta data on all table spaces to 
decide which of them have eligible data and will be included in 
the backup image. 
The checking on meta data will not last for long as the meta 
data is small in size. After it finishes, table spaces that do 
not have eligible data will be back to state of "Normal" and 
only table spaces that have eligible data will remain in state 
of "Backup in Progress". 
Therefore, only if a tablespace has been under the "backup in 
progress" state for a long time during the backup, should you 
consider it's indeeded being backed up. When you see table 
spaces in state of "Backup in Progress" at the beinning of 
"INCREMENTAL/INCREMENTAL DELTA" backup, they might be in stage 
of "checking on meta data". 
 
The wrong internal flags on table spaces will be changed back to 
normal after a successful backup on these spaces. And then the 
problem will be gone.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.1 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If you interrupt a full backup, the subsequent               * 
* "INCREMENTAL/INCREMENTAL DELTA" backup will scan extra table * 
* spaces that do NOT have eligible data for this backup.       * 
* Normally DB2 should not scan data on these table spaces      * 
* during "INCREMENTAL/INCREMENTAL DELTA" backup.  However when * 
* a full backup is interrupted, DB2 wrongly sets some internal * 
* flags on the table spaces included in the full backup.  As a * 
* result, DB2 believes these table spaces have eligible data   * 
* for the subsequent "INCREMENTAL DELTA" backup.  This problem * 
* only occurs in databases where the configuration parameter   * 
* "TRACKMOD" is set to YES.This issue will bring a big         * 
* overhead to the "INCREMENTAL DELTA" backup if the "extra     * 
* table spaces" are large in size, as the scan on extra table  * 
* spaces are time-consuming and unnecessary. To find out which * 
* table spaces are included in an"INCREMENTAL DELTA" backup,   * 
* issue "list tablespaces" command when the backup is running  * 
* to get the hexadecimal state values of the table spaces. You * 
* can then use "db2tbst" command to get the state from the     * 
* hexadecimal state value and see which table spaces are       * 
* instate of "Backup in Progress". Please note: Normally, at   * 
* the beginning of "INCREMENTAL/INCREMENTAL DELTA" backup      * 
* there is a short period of time during which you will see    * 
* all table spaces are in state of "Backup in Progress".  This * 
* because DB2 is checking some meta data on all table spaces   * 
* to decide which of them have eligible data and will be       * 
* included in the backup image.The checking on meta data will  * 
* not last for long as the meta data is small in size. After   * 
* it finishes, table spaces that do not have eligible data     * 
* will be back to state of "Normal"and only table spaces that  * 
* have eligible data will remain instate of "Backup in         * 
* Progress".Therefore, only if a table space has been under    * 
* the "backup in progress" state for a long time during the    * 
* backup, should you consider it's indeed being backed up.     * 
* When you see table spaces in state of "Backup in Progress"   * 
* at the beginning of "INCREMENTAL/INCREMENTAL DELTA" backup,  * 
* they might be in stage of "checking on meta data".The wrong  * 
* internal flags on table spaces will be changed back to       * 
* normal after a successful backup on these spaces.And then    * 
* the problem will be gone.                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.1 FixPak 9 or higher levels.    * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
First fixed in DB2 UDB Version 9.1 FixPak 9.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC65251 IC65252 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.12.2009
25.04.2010
25.04.2010
Problem solved at the following versions (IBM BugInfos)
9.0.,
9.1.
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 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.