Tags: backup, catn0000, database, db2, image, linux, mysql, namedadosadv, node0000, oracle, restore, server, sql, torestore, windows

Backup in Db2 Linux and Restore in DB2 Windows

On Database » DB2

6,506 words with 5 Comments; publish: Thu, 03 Jan 2008 17:50:00 GMT; (250187.50, « »)

I have a backup image with name

DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.00 1 and I want to

restore it on Windows (in another server).

In Windows Server I created this folder structure:

D:\DADOSADV.0\db2\NODE0000\CATN0000\20060812\

and rename the backup image file to 230006.001

When I type (Prompt DOS) db2ckbkp -H 230006.001 and I receive this

result

=====================

MEDIA HEADER REACHED:

=====================

Server Database Name -- DADOSADV

Server Database Alias -- DADOSADV

Client Database Alias -- DADOSADV

Timestamp -- 20060812230006

Database Partition Number -- 0

Instance -- db2

Sequence Number -- 1

Release ID -- A00

Database Seed -- 6D0ED4BC

DB Comment's Codepage (Volume) -- 0

DB Comment (Volume) --

DB Comment's Codepage (System) -- 0

DB Comment (System) --

Authentication Value -- 255

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

LogPath -- /microsiga/db2/db2log/

Backup Buffer Size -- 4194304

Number of Sessions -- 1

Platform -- 12

The proper image path would be:

DADOSADV.0\db2\NODE0000\CATN0000\20060812\230006.0 01

Image header dumped -- NO VERIFICATION PERFORMED.

==================================================

But when I type (Prompt DOS) db2ckrst -d DADOSADV -t 20060812230006

-d database

I receive this error:

Error: db2ckrst - No image found for timestamp 20060812230006

Return code of -8 seen at line 1363

================================================== ========

QUESTIONS:

Its possible restore a linux backup at another system? Windows

Plataform?

What I have to do?

Id tryed many possibles but nothing work!!!

Can anybody help me?

Thanks a lot.

Abel Babini Filho

All Comments

Leave a comment...

  • 5 Comments
    • No, you cannot restore a backup from linux to windows. They are not

      binarily compatible. You can restore Windows to Windows, Linux to

      Linux and Unix to Unix. To go crossplatform you have to use db2move or

      the like.

      #1; Thu, 03 Jan 2008 17:51:00 GMT
    • jdokos wrote:

      Quote:
      === Original Words ===

      >

      No, you cannot restore a backup from linux to windows. They are not

      binarily compatible. You can restore Windows to Windows, Linux to

      Linux and Unix to Unix. To go crossplatform you have to use db2move or

      the like.

      Things have improved in V9 compared to V8. As long as the endianess between

      the backup-platform and the restore-platform is the same, you can restore

      the backup image - except for Windows. Thus, moving backups between Linux

      and the various Unix platforms is not an issue any longer:

      http://publib.boulder.ibm.com/infoc...oc/c0005960.htm

      --

      Knut Stolze

      DB2 Information Integration Development

      IBM Germany

      #2; Thu, 03 Jan 2008 17:52:00 GMT
    • "Knut Stolze" <stolze.db2.todaysummary.com.de.ibm.comwrote in message

      news:ej06ec$3bh$1.db2.todaysummary.com.lc03.rz.uni-jena.de...

      Quote:
      === Original Words ===

      Things have improved in V9 compared to V8. As long as the endianess

      between

      the backup-platform and the restore-platform is the same, you can restore

      the backup image - except for Windows. Thus, moving backups between Linux

      and the various Unix platforms is not an issue any longer:

      http://publib.boulder.ibm.com/infoc...oc/c0005960.htm

      >

      --

      Knut Stolze

      DB2 Information Integration Development

      IBM Germany

      It looks like it only helps with Linux on zSeries and Linux on Power PC

      being compatible with UNIX. DB2 backups on all other Linux platforms are

      still incompatible with DB2 UNIX backups.

      #3; Thu, 03 Jan 2008 17:53:00 GMT
    • Mark A wrote:

      Quote:
      === Original Words ===

      It looks like it only helps with Linux on zSeries and Linux on Power PC

      being compatible with UNIX. DB2 backups on all other Linux platforms are

      still incompatible with DB2 UNIX backups.

      It's the endianess that matters. I don't know about the PC-version of

      Solaris and if DB2 is supported on that platform. If it is, I'd think that

      you can move Linux little-endian backups to such an environment.

      --

      Knut Stolze

      DB2 Information Integration Development

      IBM Germany

      #4; Thu, 03 Jan 2008 17:54:00 GMT
    • Ok thanks a lot for all responses...

      []s

      Abel

      Knut Stolze escreveu:

      Quote:
      === Original Words ===

      It looks like it only helps with Linux on zSeries and Linux on Power PC

      being compatible with UNIX. DB2 backups on all other Linux platforms are

      still incompatible with DB2 UNIX backups.

      >

      It's the endianess that matters. I don't know about the PC-version of

      Solaris and if DB2 is supported on that platform. If it is, I'd think that

      you can move Linux little-endian backups to such an environment.

      >

      --

      Knut Stolze

      DB2 Information Integration Development

      IBM Germany

#5; Thu, 03 Jan 2008 17:55:00 GMT