If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

All of the answers are clearly stated in the Command Reference manual under RESTORE command. PDF versions of the manual can be downloades, or you can use the web bases online InfoCenter. Make sure you get the right version of the doc to match your DB2 version.

In cases where you are restoring to the same server with a different name, the container paths obviously have to be different so as to not over-write the existing database, so you need know whether you have automatic storage to determine how to redirect the storage to a new location.

There is a command option of the RESTORE that just generates the RESTORE command for you (does not execute it) to make it easier to modify the destination container paths for a redirected restore.