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

In DB2 LUW, RESTORE from MULTI-SESSION BACKUP using TSM V6.1 can fail with
SQL2546N.

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
When using TSM V6.1 to restore from a backup image using more 
then one session will fail with: 
 
 
SQL2546N The image on media "<media>" is not the first in 
          sequence from the backup or copy. 
 
Example: 
 
db2 backup database sample use tsm open 8 sessions 
 
db2 restore database sample use tsm taken at 20091207182244 
SQL2546N  The image on media 
"/home/db2inst1/sqllib/adsm/libtsm.a" is not the 
first in sequence from the backup or copy.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* V9.1 all platforms                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When using TSM V6.1 to restore from a backup image           * 
* usingmorethen one session will fail with:SQL2546N The image  * 
* on media "<media>" is not the first insequence from the      * 
* backup or copy.Example:db2 backup database sample use tsm    * 
* open 8 sessionsdb2 restore database sample use tsm taken at  * 
* 20091207182244SQL2546N  The image on                         * 
* media"/home/db2inst1/sqllib/adsm/libtsm.a" is not thefirst   * 
* in sequence from the backup or copy.                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.1 FP9                                          * 
****************************************************************
Local Fix:
Extract images manually to disk using TSM or db2adutl and run 
the restore using files on disk.
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
When using TSM V6.1 to restore from a backup image using more 
 
then one session will fail with: 
 
 
 
 
 
SQL2546N The image on media "<media>" is not the first in 
 
 
   sequence from the backup or copy. 
 
 
 
Example: 
 
 
 
db2 backup database sample use tsm open 8 sessions 
 
 
 
db2 restore database sample use tsm taken at 20091207182244 
 
SQL2546N  The image on media 
 
"/home/db2inst1/sqllib/adsm/libtsm.a" is not the 
 
 
first in sequence from the backup or copy.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.12.2009
22.04.2010
22.04.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 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.