Team,

DB2 ver = 9.1 FP1
Linux.
This DB size is 24TB with 70partitions

I have a SMS tablespace.. container sitting on /data1/con1 in a multi partitioned env.
This container has to be moved from /data1 file system to /work file system.

Here is the thing:
1) This SMS tablespace is a history tablespace which we need the definer and create_time values should not be changed
2) We run a history against the create_time and definer field which we need to preserver the originality.
3) I do not want to use redirected restore.. because the restore will take 6 hours.. (Current offline backup is taking 6.5 hours). Our business does not allow this restore DOWN TIME.

How can I move this SMS tsp to /work file system.

Please help

Thanks,
R

Look in the manual for db2relocatedb.

Andy

Thank you..

Seems promising..

Long live DB2!