restore db

[Omar Vazquez]

i'm trying to restore a backup that olriginaly was made from a server
(production). I want to get data into a new server(development).

Does somebody know about a guide to get some information?, i'm working
in windows advanced server (production) and db2 v. 8.1. the
development is win xp and db2 8.1

thanks in advance.

[Poul Møller Hansen]

> i'm trying to restore a backup that olriginaly was made from a server

(production). I want to get data into a new server(development).

Does somebody know about a guide to get some information?, i'm working
in windows advanced server (production) and db2 v. 8.1. the
development is win xp and db2 8.1

I suggest that you use the control center for it.
It gives you all options, and the "Show SQL" is good to learn the commands
from .

Poul

[Yasaswi Pulavarti]

One thing you can do is ftp the backup file from the production
machine to development machine. If the backup file on the production
was in a particular filesystem like /dir1/dir2/backupdir make sure you
have a similar path on the development machine also. You can find out
about that path info by doing db2ckbkp -H backup_filename on the
production machine.

After you ftp'ed the file to the correct directory on development, you
can do one of the following, a redirected restore or populate an
already created database.

For redirected restore exactly follow the procedure in the DB2 command
reference manual, page 610-612. Or if you have the database creation
script or command from the production machine, create the database
first on production and then run the following.

db2 restore db MYDB user xyz using abc from /dir1/dir2/dir3 taken at
2004..... into /dir1/dir2/dir3 into DEVMYDB without rolling forward

Hope this helps,
Yasaswi

oj**@productosmavi.com (Omar Vazquez) wrote in message news:<31*************************@posting.google.c om>...

i'm trying to restore a backup that olriginaly was made from a server
(production). I want to get data into a new server(development).

Does somebody know about a guide to get some information?, i'm working
in windows advanced server (production) and db2 v. 8.1. the
development is win xp and db2 8.1

thanks in advance.

[dotyet]

Correct me someone if need be, but, I think you cannot move tables
from one tablespace to another readily. You may need to:

export data from existing tables
drop the existing tables
recreate new tables in the new tablespace.
load the data back in the newly created tables.
Instead of dropping the tables, other option may be to create
duplicate tables and then do all loading etc etc stuff. Once
satisfied, drop the original tables and rename the new tables with the
original name.

hth,
dotyet
oj**@productosmavi.com (Omar Vazquez) wrote in message news:<31*************************@posting.google.c om>... i'm trying to restore a backup that olriginaly was made from a server
(production). I want to get data into a new server(development).

Does somebody know about a guide to get some information?, i'm working
in windows advanced server (production) and db2 v. 8.1. the
development is win xp and db2 8.1

thanks in advance.