dbTalk Databases Forums  

Backup DB

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Backup DB in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Hopfield
 
Posts: n/a

Default Backup DB - 06-15-2010 , 02:48 AM






Hi all,

I have the following problem:

Our customer X is using DB2 Express-C 9.5 on Windows Server 2003 (1
year of work without any problem)
Switching to a new server (Windows Server 2008 - 64 bit), apparently
db2 works correctly.
When we do an offline backup (nightly backup) , db2 generates
correctly the backup file.

But...when we try to restore this backup image, the system breaks with
an error. (backup image is not valid)
Also, if we try to check backup image db2ckbkp the check fails with
error in "header".

My feeling is that this new server (the hardware) have serious
problems with hard disks.

But...i want to know if there is a db2 backup script that make backup
AND checks if the backup image is correct so that the user can make
every day a check on his backups.

Sorry for bad english

JH

Reply With Quote
  #2  
Old   
Richard
 
Posts: n/a

Default Re: Backup DB - 06-15-2010 , 11:52 PM






On Jun 15, 3:48*am, John Hopfield <Hopfi... (AT) freemail (DOT) it> wrote:
Quote:
Hi all,

I have the following problem:

Our customer X is using DB2 Express-C 9.5 on Windows Server 2003 (1
year of work without any problem)
Switching to a new server (Windows Server 2008 - 64 bit), apparently
db2 works correctly.
When we do an offline backup (nightly backup) , db2 generates
correctly the backup file.

But...when we try to restore this backup image, the system breaks with
an error. (backup image is not valid)
Also, if we try to check backup image db2ckbkp the check fails with
error in "header".

My feeling is that this new server (the hardware) have serious
problems with hard disks.

But...i want to know if there is a db2 backup script that make backup
AND checks if the backup image is correct so that the user can make
every day a check on his backups.

Sorry for bad english

JH
You are taking a 32 bit win db2 offline (doesnt matter) backup image
and restore to 64 bit server ? You can easily check this problem by
trying to restore that image back to the original server ( perhaps
redirect to different db to not overwrite existing ).
If that goes ok, you'd know the problem is with your backup is
incompatible with your new server.

I suppose also you run db2ckbkp on new server. Try do that on the
original server.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.