DB2 ver = 9.1 FP1
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.