IBM Support

Database Restore fails with error SQL2547N.

Technote (troubleshooting)


Problem(Abstract)

When restoring an online backup taken on version 9.1 restoring to version 9.5 or 9.7 the restore command fails with error SQL2547N.

Symptom

Restore fails with SQL2547N when trying to migrate the database from v9.1 to 9.5 or v9.7 using database restore.


Cause

This errors is caused by log compatibility between different version of db2.

Diagnosing the problem

Run 'db2ckbkp -h <backup_image_name>' If Backup Mode value is 1 this is an online backup image and it cannot be restored to a different version. If Backup Mode is some other value please contact DB2 Technical support for assistants.

Example:

db2ckbkp -h ~/SAMPLE.0.db2inst1.NODE0000.CATN0000.20130830155235.001


=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE
Server Database Alias -- SAMPLE
Client Database Alias -- SAMPLE
Timestamp -- 20130830155235
Database Partition Number -- 0
Instance -- nineone
Sequence Number -- 1
Release ID -- B00
Database Seed -- D9A84F18
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 -- 1
Includes Logs -- 0
Compression -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 21
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- UTF-8
DB Territory --
LogID -- 1377895845
LogPath -- /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Backup Buffer Size -- 3280896
Number of Sessions -- 1
Platform -- 12

The proper image file name would be:
SAMPLE.0.db2inst1.NODE0000.CATN0000.20130830155235.001


[1] Buffers processed: #################

Image Verification Complete - successful.


Resolving the problem

Take another database backup using 'OFFLINE' mode and restore the new backup image.

Document information

More support for: DB2 for Linux, UNIX and Windows
Recovery - Backup

Software version: 8.2, 9.1, 9.5, 9.7

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1648671

Modified date: 22 March 2016