Results 1 to 3 of 3

Thread: SMS tablespace

  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Talking Unanswered: SMS tablespace

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the manual for db2relocatedb.

    Andy

  3. #3
    Join Date
    Sep 2004
    Posts
    111
    Thank you..

    Seems promising..

    Long live DB2!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •