Restore to new database

[mikkel]

Hello,

Im working on a project where I have to bring at production database
in house for regression testing.

The people who hosts the database (db2 version 7) has made a backup of
the base and given me a CD containing one file...

When I try to do a restore to new Database I get the dreaded SQL2542N

My command is a follows:

RESTORE DATABASE CW FROM "C:\DB2Backup_190204\" TAKEN AT
20040219030333 TO "C:" INTO CW2 WITH 2 BUFFERS BUFFER 1024 PARALLELISM
1 WITHOUT PROMPTING;

The folder contains the file I was given by the hosting company, named
"030327.001"...

IS it at timestamp problem??? I the folder only contains on backup, do
I need to specify the timestamp??

Any suggestions??

thanks in advance

Mikkel Bruun

[Anton Versteeg]

Assuming the date (20040219) is correct try:

RESTORE DATABASE CW FROM "C:\DB2Backup_190204\" TAKEN AT
20040219030327 TO "C:" INTO CW2 WITH 2 BUFFERS BUFFER 1024 PARALLELISM
1 WITHOUT PROMPTING;

mikkel wrote:

Hello,

Im working on a project where I have to bring at production database
in house for regression testing.

The people who hosts the database (db2 version 7) has made a backup of
the base and given me a CD containing one file...

When I try to do a restore to new Database I get the dreaded SQL2542N

My command is a follows:

RESTORE DATABASE CW FROM "C:\DB2Backup_190204\" TAKEN AT
20040219030333 TO "C:" INTO CW2 WITH 2 BUFFERS BUFFER 1024 PARALLELISM
1 WITHOUT PROMPTING;

The folder contains the file I was given by the hosting company, named
"030327.001"...

IS it at timestamp problem??? I the folder only contains on backup, do
I need to specify the timestamp??

Any suggestions??

thanks in advance

Mikkel Bruun

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Ian]

mikkel wrote:

Hello,

Im working on a project where I have to bring at production database
in house for regression testing.

The people who hosts the database (db2 version 7) has made a backup of
the base and given me a CD containing one file...

When I try to do a restore to new Database I get the dreaded SQL2542N

My command is a follows:

RESTORE DATABASE CW FROM "C:\DB2Backup_190204\" TAKEN AT
20040219030333 TO "C:" INTO CW2 WITH 2 BUFFERS BUFFER 1024 PARALLELISM
1 WITHOUT PROMPTING;

The folder contains the file I was given by the hosting company, named
"030327.001"...

IS it at timestamp problem??? I the folder only contains on backup, do
I need to specify the timestamp??

Any suggestions??

thanks in advance

Mikkel Bruun

Talk to your hosting site -- for a Windows platform, you need the entire
path to exist in order to restore.

For a backup taken with the command 'backup database cw to c:\db2backup',
The path would look something like:

c:\db2backup\CW.0\DB2\NODE0000\CATN0000\20040219\0 30327.001
On your server, you need the same directory structure from CW.0 on down.
For example, If you have the structure:

d:\backups\CW.0\DB2\NODE0000\CATN0000\20040219\030 327.001

Then you can restore with 'restore database cw from d:\backups ...'

Your hosting site should be able to give you the rest of the particulars
for where the file you received was located on their server.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Kelly D. Rodger]

You can also use the 'db2ckbkp' utility to determine the full backup
image directory structure if it wasn't supplied:

C:\Backups>db2ckbkp -H 172030.001

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE
Server Database Alias -- SAMPLE
Client Database Alias -- SAMPLE
Timestamp -- 20040114172030
Database Partition Number -- 0
Instance -- DB2
Sequence Number -- 1
Release ID -- A00
Database Seed -- 4035829E
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 -- 15
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- IBM-1252
DB Territory --
LogID -- 1074118829
LogPath --
D:\DB2\NODE0000\SQL00001\SQLOGDIR\
Backup Buffer Size -- 8876032
Number of Sessions -- 1
Platform -- 5

The proper image path would be:
SAMPLE.0\DB2\NODE0000\CATN0000\20040114\172030.001

Image header dumped -- NO VERIFICATION PERFORMED.
Hope that helps.
kdr

Ian wrote:

Talk to your hosting site -- for a Windows platform, you need the entire
path to exist in order to restore.

For a backup taken with the command 'backup database cw to c:\db2backup',
The path would look something like:

c:\db2backup\CW.0\DB2\NODE0000\CATN0000\20040219\0 30327.001
On your server, you need the same directory structure from CW.0 on down.

--
================================================== ===================
Kelly D. Rodger IBM Canada
DB2 UDB Development Backup & Restore
================================================== ===================

[Ian]

Kelly D. Rodger wrote:

You can also use the 'db2ckbkp' utility to determine the full backup
image directory structure if it wasn't supplied:

C:\Backups>db2ckbkp -H 172030.001

Wow, thanks. This is handy to know.

Ian
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Philip Nelson]

Ian wrote:

Kelly D. Rodger wrote:

You can also use the 'db2ckbkp' utility to determine the full backup
image directory structure if it wasn't supplied:

C:\Backups>db2ckbkp -H 172030.001

Wow, thanks. This is handy to know.

Ian
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

In addition you may want to do a redirected restore if your disk layout
(tablespace definitions) are different from the source server.

Especially useful on a Windows server where you can't create logical links
like you can on UNIX.

I've got a script which will generate a redirected restore using the source
database "LIST TABLESPACE" output as input. It's a Perl script and
designed for use on UNIX, but you may find it useful. If so feel free to
drop me an email for a copy.

Phil

--
Philip Nelson
ScotDB Limited
http://www.scotdb.com
(te*****@scotdb.com)