|
Problem IC65190
|
Status: Closed |
In DB2 LUW, DB2ADUTL VERIFY HEADONLY command and DB2ADUTL QUERY command may show incorrect result for multi-session BACKUP. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
1. The filename returned by the db2adutl verify headeronly
command does not match the header information when a backup is
taken using more then one session.
Example
db2 backup database sample use tsm open 8 sessions
db2adutl verify headeronly db sample taken at 20091119140501
From below you can see it states:
Verifying file:
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001
But in per the header the file name should be
SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007
Retrieving FULL DATABASE BACKUP information. Please wait.
FULL DATABASE BACKUP image:
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.002,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.003,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.004,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.005,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.006,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007,
DB Partition Number: 0
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.008,
DB Partition Number: 0
Do you wish to verify this image (Y/N)?
Verifying file:
./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001
=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE
Server Database Alias -- SAMPLE
Client Database Alias -- SAMPLE
Timestamp -- 20091119140501
Database Partition Number -- 0
Instance -- db2inst1
Sequence Number -- 7
Release ID -- B00
Database Seed -- DBFF1C1A
DB Comment's Codepage (Volume) -- 0
DB Comment (Volume) -- A sample database
DB Comment's Codepage (System) -- 0
DB Comment (System) -- A sample database
Authentication Value -- -1
Backup Mode -- 0
Includes Logs -- 0
Compression -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 1
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- UTF-8
DB Territory --
LogID -- 1254882872
LogPath --
/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Backup Buffer Size -- 1052672
Number of Sessions -- 8
Platform -- 1E
The proper image file name would be:
SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007
2. The db2adutl query command may return several entries for the
same backup image to TSM.
db2adutl query full db SAMPLE
Query for database SAMPLE
Retrieving FULL DATABASE BACKUP information.
1 Time: 20091218011337 Oldest log: S1846095.LOG DB
Partition Number: 0 Sessions: 2
2 Time: 20091218011337 Oldest log: S1846095.LOG DB
Partition Number: 0 Sessions: 1
3 Time: 20091217011235 Oldest log: S1845626.LOG DB
Partition Number: 0 Sessions: 3
4 Time: 20091216011338 Oldest log: S1845409.LOG DB
Partition Number: 0 Sessions: 1
5 Time: 20091216011338 Oldest log: S1845409.LOG DB
Partition Number: 0 Sessions: 1
6 Time: 20091216011338 Oldest log: S1845409.LOG DB
Partition Number: 0 Sessions: 1
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for SAMPLE
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for SAMPLE
This problem happens whenever you have more than one session
that is required for a database.
This can occur even if the second session is due to an online
include logs and the backup only was defined as single session
(it automatically gets the second session for the logs phase).
3. The db2adutl keep <N> functionality may not work when the
images are not aggregated correctly.
Sample scenario is like this.
1) Check the backup images.
$ db2adutl query full db SAMPLE
Query for database SAMPLE
Retrieving FULL DATABASE BACKUP information.
1 Time: 20091218155633 Oldest log: S0004309.LOG DB
Partition Number: 0 Sessions: 2 (Online backup)
2 Time: 20091218131854 Oldest log: S0004300.LOG DB
Partition Number: 0 Sessions: 2 (Online backup)
3 Time: 20091218104953 Oldest log: S0004293.LOG DB
Partition Number: 0 Sessions: 1 (Offline backup)
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for SAMPLE
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for SAMPLE
The output is correct, one entry for one image.
2) Take a fourth online backup, and db2adutl delete with
"keep 6" option.
# su - maint1 -c db2 backup db SAMPLE online use tsm buffer
2049 include logs
Backup successful. The timestamp for this backup image is :
20091218163950
# su - maint1 -c db2adutl delete full NONINCREMENTAL keep 6
db SAMPLE without prompting
Query for database SAMPLE
Retrieving FULL DATABASE BACKUP information.
Taken at: 20091218104953 DB Partition Number: 0
Sessions: 1
The backup image which should not be deleted was deleted.
3) Check the backup images again.
$ db2adutl query full db SAMPLE
Query for database SAMPLE
Retrieving FULL DATABASE BACKUP information.
1 Time: 20091218163950 Oldest log: S0004315.LOG DB
Partition Number: 0 Sessions: 1
2 Time: 20091218163950 Oldest log: S0004315.LOG DB
Partition Number: 0 Sessions: 1
3 Time: 20091218155633 Oldest log: S0004309.LOG DB
Partition Number: 0 Sessions: 1
4 Time: 20091218155633 Oldest log: S0004309.LOG DB
Partition Number: 0 Sessions: 1
5 Time: 20091218131854 Oldest log: S0004300.LOG DB
Partition Number: 0 Sessions: 1
6 Time: 20091218131854 Oldest log: S0004300.LOG DB
Partition Number: 0 Sessions: 1
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for SAMPLE
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for SAMPLE
Two entries are listed for each backup image.
This problem does not occur in V8 and V9.1. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* V9.1 all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* The filename returned by the db2adutl verify *
* headeronlycommanddoes not match the header information when *
* a backup is takenusing more then one session.Exampledb2 *
* backup database sample use tsm open 8 sessionsdb2adutl *
* verify headeronly db sample taken at20091119140501From below *
* you can see it states:Verifying *
* file:./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001B
* in per the header the file name should *
* beSAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007Retrie
* FULL DATABASE BACKUP information. Please wait.FULL DATABASE *
* BACKUP *
* image:./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.002,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.003,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.004,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.005,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.006,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007,DB *
* Partition Number: *
* 0./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.008,DB *
* Partition Number: 0Do you wish to verify this image *
* (Y/N)?Verifying *
* file:./SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.001=
* HEADER REACHED:=====================Server Database Name *
* -- SAMPLEServer Database Alias -- *
* SAMPLEClient Database Alias -- SAMPLETimestamp *
* -- 20091119140501Database Partition Number *
* -- 0Instance -- db2inst1Sequence *
* Number -- 7Release ID -- *
* B00Database Seed -- DBFF1C1ADB Comment's *
* Codepage (Volume) -- 0DB Comment (Volume) -- A *
* sample databaseDB Comment's Codepage (System) -- 0DB Comment *
* (System) -- A sample databaseAuthentication Value *
* -- -1Backup Mode -- 0Includes *
* Logs -- 0Compression -- *
* 0Backup Type -- 0Backup Gran. *
* -- 0Status Flags -- 1System Cats inc *
* -- 1Catalog Partition Number -- 0DB *
* Codeset -- UTF-8DB Territory *
* --LogID -- 1254882872LogPath *
* *
* --/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/Backup *
* Buffer Size -- 1052672Number of Sessions *
* -- 8Platform -- 1EThe proper image *
* file name would *
* be:SAMPLE.0.db2inst1.NODE0000.CATN0000.20091119140501.007 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.1 FP9 *
**************************************************************** |
| 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 |
Fixed in V9.1 FP9 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65392 IC65412
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.12.2009
22.04.2010
02.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
