I'm on DB2 v9.1 on Linux. Trying to do a redirected restore of a DMS
auto-resize tablespace. It seems like the first thing that DB2 tries
to do on restore is to create a file the size of the tablespace to be
restored. But it seems to do this in the original path of the
tablespace instead of the redirected path. Problem is that the
original path doesn't have enough disk space. Is there a way around
this or am I doing something wrong?

Thanks,
Greig

On Jan 31, 9:12*pm, Greig <frital... (AT) gmail (DOT) com> wrote:
Have you tried creating an auto restore script ?
Make sure you have access to the backup file and use the following db2
command to create an automated redirected restore script:

db2 restore db test from [path to backup file without file name] taken
at 20050304090733
redirect generate script test_node0000.clp

Once the script has been created look for the line containing the
appropriate tablespace number :

SET TABLESPACE CONTAINERS FOR 3

-- IGNORE ROLLFORWARD CONTAINER OPERATIONS

USING ( FILE 'full path description' 2560000 );

Change the path to what you require and set the 2560000 to the number
of pages .

Be sure to do that for ALL tablespaces and then finally issue the
command:

RESTORE DATABASE SQ4TEST CONTINUE;

There are of course other parameters to be set such as db name, path,
user id and password etc see http://publib.boulder.ibm.com/infoce...v9r7/index.jsp
for details.

Hope this helps.

Stupid link paste .. heh Try here

http://publib.boulder.ibm.com/infoce.../t0021521.html