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
------------------------------

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
------------------------------

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:
Sent: Mon June 02, 2025 01:01 PM
From: Jan Nelken
Subject: Moving tables from default to another

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
------------------------------