Hi all,
I 'd like to create a database from backup image, please tell how can i do it?
Thanks

I'm not clear to your question. Do you want to create a new database to store the images?

i mean that i 'd like to create a new database from backup image, please help me.
Thanks

Hi,

Try this

db2 restore database <database name> from <backup-bath> to <new-location> into <new-alias>.

for e.g.

db2 restore database test from e:\db2bk to d: into newtest.

please check the restore command syntax for more details.

Cheers

Nitin

You need to do a redirected restore.

The sequence of events would be

restore database <source-dbname>
from/load <depending on where the backup is>
taken at <backup date and time>
to <target db directory>
into <target dbname>
newlogpath <target db logpath>
with <num buffers that source backup was taken with> buffers
buffer <buffer size that source backup was taken with>
redirect

You will have to know what the source db tablespaces were.

At this point, for every tablespace in the source database, the following must be issued
set tablespace containers for <tbspace id in src db>
using <sms or dms container path>

restore db <source dbname> continue

If this is an MPP system , this will have to be done for each node starting with the catalog node.

Hope this helps.