Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Moving tables from default to another

    Posted 29 days ago

    Greetings, experts,

    I hope you can share your thoughts if you have experience placing a set of tables from the default USERSPACE1 to a separate one using db2move, or other tools like Data Studio and other IDEs.

    Appreciate your generous time a lot!



    ------------------------------
    Senen Jr Dimanahan
    ------------------------------


  • 2.  RE: Moving tables from default to another

    Posted 29 days ago

    Please review:

    https://www.ibm.com/docs/en/db2/12.1.0?topic=reference-data-movement-options

    I frequently use LOAD FROM CURSOR - but you may want to consider export/import (using named pipes) - or ADMIN_MOVE_TABLE procedure.



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for job
    Katowice or Krakow
    +48 783 109 863
    ------------------------------

    Original Message


  • 3.  RE: Moving tables from default to another

    Posted 28 days ago

    Hello there, Jan,

    Thank you very much for providing inputs. I managed to move the tables after reading and using admin_move_table sp. It's more straightforward compared to db2move - tablespace_map.

    My best regards,



    ------------------------------
    Senen Jr Dimanahan
    ------------------------------

    Original Message


Related Content