Backup DB
in [DB2]
|
From: John Hopfield on 15 Jun 2010 03:48 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
From: Richard on 16 Jun 2010 00:52 On Jun 15, 3:48 am, John Hopfield <Hopfi...(a)freemail.it> wrote: > 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.
|
Pages: 1 Prev: Create Role as db2inst1 Gives Error SQL0552N Next: DB2 UDF Problem |