Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    25

    Unanswered: How to move table online in production server

    Hi this is Narasimha, In my production server(db2 ese(9.7 FP 6) i want to move my table sms tablespace to dms tablespace how to move it please help to me.




    Thanks and Regards
    Narasimha A

  2. #2
    Join Date
    Mar 2005
    Posts
    4
    I don't think you can do that 100% "online". Here are the steps you can try .

    1. create the DMS tablespace and TAB_new in it.
    2. Devide your table data to 2 parts by some logic: static and dynamic if you can.
    3. Load cursor the Static part to the new table TAB_new.
    4. Lock the current table and load cursor the dynamic data.
    5. Rename TAB to TAB_old and TAB_NEW to TAB.

    This solution may not apply to your real problem , just provide 1 possible solution with minimum downtime.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Narsimhadb2 View Post
    Hi this is Narasimha, In my production server(db2 ese(9.7 FP 6) i want to move my table sms tablespace to dms tablespace how to move it please help to me.
    Try googling "db2 9.7 move table"
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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