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

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

APAR status

• Closed as program error.

Error 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.
  

Local fix

• Extract images manually to disk using TSM or db2adutl and run
  the restore using files on disk.
  

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                                          *
  ****************************************************************
  

Problem conclusion

• 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.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R910 PSN

     UP